ODBC Script Error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
antonyraj.deva
Premium Member
Premium Member
Posts: 138
Joined: Wed Jul 16, 2008 9:51 pm
Location: Kolkata

ODBC Script Error

Post by antonyraj.deva »

Hi All,
I tried to execute the odbc shell scripts and got the corresponding error messages in the server. Kindly requesting support on how these errors can be rectified.

odbc.sh (ran this script on ksh & bsh)

if [ "$LIBPATH" = "" ]
then
LIBPATH=/datastage/dsadm/Ascential/DataStage/branded_odbc/lib
else
LIBPATH=/datastage/dsadm/Ascential/DataStage/branded_odbc/lib:$LIBPATH
fi
export LIBPATH
fi

error message

dsadm@dev01:/datastage/dsadm/Ascential/DataStage/branded_odbc>./odbc.sh
./odbc.sh[8]: 0403-057 Syntax error at line 9 : `fi' is not expected.

dsadm@dev01:/datastage/dsadm/Ascential/DataStage/branded_odbc>bsh
$ . odbc.sh
Syntax error: `fi' not expected.
$ exit

odbc.csh

if ($?LIBPATH == 1) then
setenv LIBPATH /datastage/dsadm/Ascential/DataStage/branded_odbc/lib:${LIBPATH}
else
setenv LIBPATH /datastage/dsadm/Ascential/DataStage/branded_odbc/lib
endif
if ( ! $?INFORMIXDIR ) setenv INFORMIXDIR /datastage/dsadm/Ascential/DataStage/branded_odbc

error message

dsadm@dev01:/datastage/dsadm/Ascential/DataStage/branded_odbc>csh
% ./odbc.csh
./odbc.csh: Syntax error at line 6: `setenv' not expected.

Thanks in advance


[/b]
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The two "fi" in the odbc.sh are obviously wrong, the second one should be removed. This error remains at my copy of Version 8.
The question I have is whether or not this script needs to be executed, I've never had to.
Post Reply