Returning a SQL Code to a Unix Script - PLEASE HELP !!!!
From: Robert sharpe <Robert.SharpeNORoSPAM_at_AbbeyNational.Co.Uk.invalid>
Date: Wed, 19 Jan 2000 03:17:40 -0800
Message-ID: <040317c0.67a08039_at_usw-ex0107-050.remarq.com>
I have a Unix shell script that logs onto SQL*PLUS and involkes a SQL script. If the SQL script fails it will return an error code, SQL.SQLCODE to the Unix script. The Unix script will then truncate the error code to 8 characters - IN BINARY !!!!
Date: Wed, 19 Jan 2000 03:17:40 -0800
Message-ID: <040317c0.67a08039_at_usw-ex0107-050.remarq.com>
I have a Unix shell script that logs onto SQL*PLUS and involkes a SQL script. If the SQL script fails it will return an error code, SQL.SQLCODE to the Unix script. The Unix script will then truncate the error code to 8 characters - IN BINARY !!!!
e.g.
SQLCODE is 904 or 1110001000 in binary
UNIX truncates the binary to 10001000 or 136 in decimal.
Q. How do I overcome this feature-ette and get the correct error code into Unix. ????
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!