Please help me in resolve the issue facing while executing a script in Unix environment.
I'm trying to pass database name by an unix variable like below
But it is unable to executing the script and throughing below error.
*** Warning: You must log on before sending DBC/SQL requests.
*** BTEQ exiting due to EOF on stdin.
*** Exiting BTEQ...
*** RC (return code) = 2
Even I did keep my logon script with in myfile.sql
Please help me to resolve the same.
Do you have the logon script in the beginning (the very first line) of the BTEQ ? If not, then it will give you this error. If it is, then just make sure that it is the correct script/statement. If it still creates an issue, please share the bteq and can look into it.