SQLCODE returned with UNION

[Robert Singer]

If you have multiple SELECT statements that are joined by the UNION keyword (UNION, UNION ALL, etc.), which SELECT statement determines what the value of SQLCODE will be after execution? Is it the result of the first SELECT, the last SELECT, the highest (absolute value) SQLCODE, or something else? (Also, in which manual can you find this information?) Thank you for your assistance.

 

[fredericofonseca]

if there is a UNION then it is a single SQL statement so the value of SQLCODE applies to that single SQL.

You may have more than one error and only the first one that the parser detects is shown - order "errors" are processed could be, but can't guarantee, the order they are.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886