What is wrong with thnis Syntax? I am getting a syntax error on the IF...THRN....ELSE statement.

SQL SQLMSS
INSERT INTO XXX
(YYY
,ZZZZ)
END
-RUN

-IF &RETCODE NE 0
THEN
-EXIT
ELSE
END



All I want to do is exit the report if the write wasn't successful. If it was, then go on processing the report.

This message has been edited. Last edited by: Ted Michalski,

More like this:

 SQL SQLMSS
INSERT INTO XXX
(YYY
,ZZZZ)
;
END
-RUN 
-IF &RETCODE NE 0 THEN GOTO EXIT ELSE GOTO CONTINUE; 
-CONTINUE
{yada yada}
-EXIT

(FOC1517) UNRECOGNIZED COMMAND IF 2627 NE 0 THEN GOTO EXIT ELSE GOTOCONTINUE;

-IF &RETCODE NE 0 THEN GOTO EXIT ELSE GOTO CONTINUE;

Must have the -

You have to do something like this:

-IF &RETCODE NE 0 THEN GOTO EXIT_LBL ELSE GOTO END_LBL;
-*
-EXIT_LBL
EXIT
-*
-END_LBL
END

Thanks for the input. Works fine now.

dbeagan,

CONTINUE is a researved word and does not play nicely with goto.

At least under 7.6.11, "-GOTO CONTINUE" will work but using with a "-IF" will not.

Thanks Rob. Hopefully MichaelBalle only used it as an example and had his own label names.