####################################
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.
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...
it should contain a entry like
xxx.yyy.zzz.www servernameCOP1
if it is not present this is you issue.
Ulrich