Terdata BTEQ script ERROR:

Teradata Applications
Enthusiast

Terdata BTEQ script ERROR:

####################################
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.

2 REPLIES
Senior Supporter

Re: Terdata BTEQ script ERROR:

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

 Copyright 1984-2015, Teradata Corporation. ALL RIGHTS RESERVED.

 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

Enthusiast

Re: Terdata BTEQ script ERROR:

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