How to pass return code of a mload to shell script

Tools & Utilities

How to pass return code of a mload to shell script

Hi All,

I am bit new to teradata. I have invoked a mload from UNIX and want to get the return code of the MLOAD to shell script to perform next operation. can any one help me out on this on how to get the same?

I serached the forum and found few but those werent working on.

Thanks,

Anand

1 REPLY
Teradata Employee

Re: How to pass return code of a mload to shell script

Any command executed on shell will lead to $? to be filled with exit status of the last command. After you can test it and branch it, in your envelope script ... for example like this ...

mload < my_mload_script

if [[ $? -eq 0 ]]

then echo "mload script ended with error"

# catch the signal/trap or/and exit nicely

else echo "mload script ended succesfully"

#some other commands 

fi

Cheers
-=[VH]=-