Hi,

I have an issue using &RETCODE in the IF statement.

I have written the following code to check whether the INSERT statement is passed or not.

Insert stmt;
-IF &RETCODE NE 0 THEN GOTO ERRPG ELSE GOTO SUC;
-ERRPG
-TYPE FOCERNUM &FOCERNUM
-TYPE RETCODE &RETCODE
-SUC
*SQL stmt to display in report*

My issue is the insert statement is working correctly but the SQL statement that follows -SUC doesn't work and i am getting no report as an output.

Is my understanding correct? Please correct me if i am wrong.

Thanks in advance,
Vasanth

This message has been edited. Last edited by: Kerry,

OK, so why do you only post the working part of your code

What kind of errors do you get?

VK -

Add
-RUN
between the end of the SQL request and the -IF test.