Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bteq Scripts

Status
Not open for further replies.

arzoocbe

Programmer
Nov 21, 2002
8
US
Hi

I would like to know if there is a way to verify the status(Success/failure) of a particular Bteq script (other than by verifying the error code)

Thankyou
Arzoo
 
No you should work with the errorcode.
In Unix your shell script may look like this:

BTEQ<<EOF
SQL command1;
.if errorcode <> 0 then quit 9
SQL command2;
.if errorcode <> 0 then quit 9
EOF
export EXITCODE=$?

you can use the unix-variable EXITCODE to do additional other testing within your unix shell script
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top