Page 1 of 1

PUISQLRPGI Problem in V5R4

Posted: Tue Jun 14, 2011 11:48 am
by jac53
My SQLRPGLE is not compiling. Attached is the compile listing with the errors.

Re: PUISQLRPGI Problem in V5R4

Posted: Tue Jun 14, 2011 1:50 pm
by Brian
Does the program compile correctly using CRTSQLRPGI?

If so, can you provide me with a text file of the original code so that we can test it in house?

Re: PUISQLRPGI Problem in V5R4

Posted: Tue Jun 14, 2011 2:23 pm
by jac53
Yes, it compile with CRTSQLRPGI .

Re: PUISQLRPGI Problem in V5R4

Posted: Tue Jun 14, 2011 3:42 pm
by Brian
Thanks. We will have someone look into this.

Re: PUISQLRPGI Problem in V5R4

Posted: Tue Jun 14, 2011 3:56 pm
by Brian
Ok. Can you also provide the DDS for your files and display file?

Also, what version of ProfoundUI are you running?

Re: PUISQLRPGI Problem in V5R4

Posted: Wed Jun 15, 2011 9:52 am
by jac53
Attached find out what you requested

Re: PUISQLRPGI Problem in V5R4

Posted: Wed Jun 15, 2011 12:02 pm
by Rob
The pre-processor was having trouble with the SQL COMPILEOPT directive split over multiple lines. Try merging this onto one line:
RPG CODE
COMPILEOPT='DBGVIEW(*LIST) OPTIMIZE(*BASIC) FIXNBR(*ZONED *INPUTPACKED)';
This line will just fit within columns 8 and 80.

We will update the pre-processor to handle this.

Re: PUISQLRPGI Problem in V5R4

Posted: Wed Jun 15, 2011 2:23 pm
by jac53
Rob you were absolutely right. After that change the program compiled perfect.
Thank you