Terdata BTEQ script ERROR:

Govind3331 · ‎12-06-2015

####################################
bteq <<EOF
.LOGON servername/username,********
/* sql code on next line(s) */
select  databasename from dbc.databases where databasename="P_EIW_S_LIS_01";
.export reset
.LOGOFF ;
EOF
###################################

Above is the BTEQ Script:
When i am executing the above script i am getting below error:

CLI:Message catalog open failed!: No such file or directory
The file "errmsg.cat" cannot be opened.
There may be problems with your installation.
 *** CLI error: -1 Message Not Found!
 *** Return code from CLI is: -1
 *** Error: Fatal error from CLI.
 ***        Program exiting!

 *** Exiting BTEQ...
 *** RC (return code) = 16

Could any1 plez help me resolving this issue. Thanks in advance.

ulrich · ‎12-07-2015

Can you als run a

bteq

with no input from the shell.

You should see something like

Teradata BTEQ 15.00.00.03 for Mac OS X. PID: 23275

Enter your logon or BTEQ command:

If it not starts you have an issue with the BTEQ installation...

If it starts: please check you /etc/hosts file

it should contain a entry like

xxx.yyy.zzz.www servernameCOP1

if it is not present this is you issue.

Ulrich

Govind3331 · ‎12-08-2015

Yes exactly Ulrich, the installation was done in the server ,that is d reason it got failed .
Thanks ulrich for ur support in solving this issue

Terdata BTEQ script ERROR:

Terdata BTEQ script ERROR:

Re: Terdata BTEQ script ERROR:

Re: Terdata BTEQ script ERROR: