InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:08:41 GMT20http://www.teradata.com/teradataforum/Topic11877-10-1.aspxI found the problem is with connectivity b/w Unix and teradata. Teradata Client is installed on Pc but Unix is not connected to Teradata.could anyone help me in making this connection.what are the things necessary for this connection? I have already included teradata server host string in Unix Hosts file, But didnt find any teradata utility connectivity to Unix.Thanks and regards,KunalThu, 19 Jun 2008 01:52:29 GMTkunalhttp://www.teradata.com/teradataforum/Topic11877-10-1.aspxThat's normally given by unix if the user does not have execute permission on the executable... so check the permissions on the bteq executable and make sure the unix user id you are using has execute permissions for it.ls -ltr $(which bteq)Tue, 17 Jun 2008 02:09:48 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11877-10-1.aspxHi all,I am trying to run the below mentioned script. It works fine in AIX unix box but in Sun Unix box, an error occurs:test.sh: bteq: execute permission deniedcould you please tell me how i can resolve this problem?FUNC_VALIDATE_ENTRIES(){ bteq<<-END .logon DemoTd/User1,******; .export report file=VALIDATE_FILE.sol select distinct DatabaseName from dbc.Tables where DatabaseName = 'USER1'; .if ACTIVITYCOUNT > 0 then .goto labelC select 5; .goto labelD .label labelC select 0; .label labelD .export reset .quit errorcode .LOGOFF END}FUNC_VALIDATE_ENTRIES thanksMon, 16 Jun 2008 04:30:19 GMTkunal