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.
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