Thanks for the explanation, Razzak! This weekend I'm going to read through your response carefully and play around with the command and see if it's something to standardize on ...
Karen > Technically, WHENEVER is like a gate; it checks SQLCODE and one continues > through or goes around. This command is similar to the error variable in > that it is placed once in the code and from there is used to check all > subsequent commands. But while the R:BASE error variable is used once > per R:BASE session, WHENEVER is used once per command file or block. > Each command file or block requires a separate WHENEVER command, but > they all share the same R:BASE error variable. There are two parts to > the WHENEVER command: first, determine if an error condition exists; > second, tell the program what to do.
