Can BTEQ return an error code to Unix shell script?

[CapsuleCorpJX]

BTEQ when used in UNIX returns a "return code" at the end of the run. Is there a way to manually set the RC?
Bascially if one of my BTEQ queries find something bad in the data, I want it to send a signal to the Unix Job (shell script) it is running under, that something went wrong, and then have Unix Job itself return an error code (abend).

 

[dnoeth]

check the manuals for EXIT/QUIT, there's an option:

.quit ERRORCODE|ERRORLEVEL|ACTIVITYCOUNT|1234

Dieter

 

[forumbo]

Hello All:

Talking about "error code" in bteq, is there any variable that keep the error code when one error ocurrs in a bteq ? I know that in mloads we've got "&sysrc" but in a bteq?

Thanks.

 

[CapsuleCorpJX]

Well I think you can store it in a korn shell script variable. But you'd have to split your BTEQ portion up into chunks inside your ksh script.

Say BTEQ "A" does this, and an error code is stored in $ErrorCodeA, and BTEQ "B" is called afterwards, and the error code is stored in $ErrorCodeB.

For example:

<Korn shell script start>
echo "hello"
BTEQ << EOF

< your bteq statements >

.IF Activity_Count <> 0 THEN .quit <errorcode>
EOF

ErrorCodeA=${?}

BTEQ << EOF

< your bteq statements >

.IF Activity_Count <> 0 THEN .quit <errorcode>
EOF

ErrorCodeB=${?}

<Korn shell script end>