RE: [WDSCI-L] compiling sql rpg

["Bartell, Aaron L." <ALBartell@xxxxxxxxxxxxxx>]

Here is the command that I have stored in my compile command repository
in WDSc for creating RPG programs with embedded SQL:


CRTSQLRPGI OBJ(&O/&N) SRCFILE(&L/&F) SRCMBR(&N) OPTION(*EVENTF)
TGTRLS(V5R3M0) CLOSQLCSR(*ENDMOD) DBGVIEW(*SOURCE) REPLACE(&R)

And for the archives, if you want to create a module for a service
program that has SQL embedded in it, use this command in WDSc:

CRTSQLRPGI OBJ(&O/&N) SRCFILE(&L/&F) SRCMBR(&N) OBJTYPE(*MODULE)
OPTION(*EVENTF) TGTRLS(V5R3M0) CLOSQLCSR(*ENDACTGRP) REPLACE(&R)
DBGVIEW(*SOURCE) TOSRCFILE(ALBARTELL/QSQLTEMP1)

Note: TOSRCFILE(ALBARTELL/QSQLTEMP1) is specified so I can double click
on errors and have it come up in a LPEX editor vs. having to go back the
iSeries to see it because the SQL precompiler doesn't seem to play as
nice as the CRTBNDRPG command.

Hope that helps,
Aaron Bartell 

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]

Sent: Thursday, March 10, 2005 12:32 PM
To: Websphere Development Studio Client for iSeries
Subject: [WDSCI-L] compiling sql rpg


I'm a novice with sql in rpg.  I inherited a project from a contractor
who's no longer with us.  I modified an sqlrpgle program she wrote to
add a screen option, didn't modify any of the sql.  When I compile it
out of WDSCI the compile fails with a host of duplicate identifier
errors.  In the compile a bunch of new code appears with right hand
comments that say "SQL".  The added code is the sql communications area,
a few anonymous data structures, and api calls following every sql
statement group.  When I compile it from PDM it works fine. 

I wouldn't be surprised if it were a difference in the compile parms,
but I haven't found it yet.  What do I need to change?

Thanks

*****************************
NOTICE:
All e-mail sent to or from this e-mail address will be received or
otherwise recorded by The Sharper Image corporate e-mail system and is
subject to archival, monitoring, and review by and/or disclosure to
Sharper Image security and other management.
This message is intended only for the use of the addressee and may
contain information that is privileged and confidential.

The contents of this message may contain personal views which are not
the views of The Sharper Image.
If you are not the intended recipient, dissemination of this
communication is prohibited.
*****************************

--
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.