MVSFORUMS.com

mickeygoo · Beginner Joined: 15 Nov 2007 Posts: 26 Topics: 7

Is there a dataset for DSNTIAUL that would display the SQL as read/interpreted at execution time? I received a -104 on an SQL that has been executing successfully for a while now, and the token being flagged as illegal is nowhere on the SQL itself. SYSUDUMP, SYSDBOUT don't seem to work. TIA Very Happy

jsharon1248 · Posted: Fri Dec 07, 2007 11:01 am Post subject:

If I remember, SYSPRINT shows the SQL, control totals, and any error messages. I'm pretty sure it's required, and since you're seeing an error message, I suspect you already have it coded. Please post the SQL and the full text of the -104. The actual cause of a -104 is often unrelated to the SQL itself; it can be caused by a missing end of statement delimiter or omitting the PARM('SQL') option on the RUN PROGRAM command.