RE: AW: CRTSQLRPGI errors out with DBGVIEW(*SOURCE) but passes with DBGVIEW(*NONE)

I think the proper syntax is CompileOpt = *Source. Havn't tried it yet, though.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jszarlik
Sent: Friday, September 18, 2009 11:59 AM
To: "rpg400-l@xxxxxxxxxxxx"@mail.midrange.com
Subject: Re: AW: CRTSQLRPGI errors out with DBGVIEW(*SOURCE) but passes with DBGVIEW(*NONE)

Thank you for all your responses.
They are helpful for me, I have what I wanted.

Brigitta,
I had a problem with your advise. I added to my program compile option:

C/Exec SQL Set Option CompileOpt('DBGVIEW(*SOURCE)')
C/End-Exec

but I received compilation error:
SQL0104 30 2162 Position 38 Token ( was not valid. Valid tokens: =.

it isn't problem for me but I have to remember to set
CompileOpt('DBGVIEW(*SOURCE)') each time.

Thank you very much once more
Regards
Jarek


--------- Oryginał wiadomości --------
Od: Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
Do: 'RPG programming on the IBM i / System i' <rpg400-l@xxxxxxxxxxxx>
Temat: AW: CRTSQLRPGI errors out with DBGVIEW(*SOURCE) but passes
with DBGVIEW(*NONE)
Data: 18/09/09 05:44

Hi,

to make it easier (and not to forget it the next time you'll recompile

your

program), you may add it in an SET OPTION statement at the beginning of

your

C-Specs.
If there is already a set option statement in your program, just add the
compile option:

C/Exec SQL Set Option CompileOpt('DBGVIEW(*SOURCE')
C/End-Exec

But to use CompileOpt you need at least release V5R3 (or even V5R4).

Mit freundlichen Gr=FC=DFen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Urspr=FCngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]

Im

Auftrag von Barbara Morris
Gesendet: Thursday, 17. September 2009 21:57
An: rpg400-l@xxxxxxxxxxxx
Betreff: Re: CRTSQLRPGI errors out with DBGVIEW(*SOURCE) but passes with
DBGVIEW(*NONE)

(From: "Jszarlik" <jszarlik@xxxxxx>)

> I found calling command CRTSQLRPGI and changed DBGVIEW(*SOURCE) for
> DBGVIEW(*NONE) and the all is OK.
> But I have to debug this program to find error.
>
> How to compile with DBGVIEW(*SOURCE)?
>

Jarek, you could try compiling this way:

CRTSQLRPGI COMPILEOPT('DBGVIEW(*SOURCE)')

That would let you debug from the intermediate source file that the SQL =

precompiler generates. DBGVIEW(*SOURCE) for the CRTBNDRPG step of the =

compile produces the smallest possible debug information.

By default, the intermediate source file is placed in QTEMP. If you =

want to debug the program from another job, you should also specify the =

TOSRCFILE parameter for CRTSQLRPGI so that the intermediate file goes =

into a permanent library.

CRTSQLRPGI TOSRCFILE(mylib/myfile) COMPILEOPT('DBGVIEW(*SOURCE)')
-- =

This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


-- =

This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/r