Re: /Exec sql

Can you use the STRQM or STRSQL commands to build SQL based queries?  If so, 
then you should be able to build embedded SQL programs.  If not, then you could 
use some lower-level alternatives (note: low-level does not mean 
low-functionality) like the SQL-CLI api's or the extended dynamic SQL api's 
(QSQPRCED).  These are a bit more work to get going, but they are supported on 
all os400 boxes, so once you've learned it, you can use it whenever you need....

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of David Foxwell
Sent: Tuesday, September 19, 2006 2:31 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] /Exec sql


I can't use /exec sql in SEU either.
I can open an SQL interactive session and I can use RUNSQLSTM.
I just assumed that I could use SQL in an RPG pgm.

----- Message d'origine -----
De : "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
À : "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx>
Envoyé : lundi 18 septembre 2006 18:39
Objet : Re: [WDSCI-L] Verifying SQL statement in RPG program.


Do you have the SQL licensed product installed?

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of David Foxwell
Sent: Monday, September 18, 2006 7:15 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Verifying SQL statement in RPG program.


Thanks but it is SQLRPGLE.
As soon as I type /E, I get a list of choices from /END-FREE, /ENDIF etc but
no /EXEC SQL.


----- Message d'origine -----
De : "Cary Phillips" <cary@xxxxxxxxxxxxxxxx>
À : "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx>
Envoyé : lundi 18 septembre 2006 13:37
Objet : Re: [WDSCI-L] Verifying SQL statement in RPG program.


Check the source member type.  It should be SQLRPGLE.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On
Behalf Of David Foxwell
Sent: Monday, September 18, 2006 5:48 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Verifying SQL statement in RPG program.

I can't even type /EXEC SQL in WDSc 5.1

As soon as I reach /EX, an error message tells me that the directive is
unknown. Can anyone help?

----- Message d'origine -----
De : "Michael Ryan" <michaelrtr@xxxxxxxxx>
À : "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx>
Envoyé : vendredi 15 septembre 2006 20:28
Objet : Re: [WDSCI-L] Verifying SQL statement in RPG program.

Try putting a C before the +.

On 9/15/06, Alan Campin <Alan.Campin@xxxxxxxxxxxxxxxx> wrote:

I have SQL statements in an RPG IV program that look like this:

     C/EXEC SQL
      +  Declare C2 Cursor for
      +   select a.fitemf, b.wkctrf, sum(a.qtyrcf),
      +   sum(b.sslhuf), sum(b.slhtdf), sum(b.srlhuf * a.qtyrcf),
      +   sum(b.rlhtdf), c.pfdsc2
      +   from cstsum a join labeff b
      +   on a.ordnof = b.ordnof and a.fitemf = b.fitemf
      +   join facmstl0 c on b.wkctrf = c.pfidc2
      +   where a.ostatf between '45' and '55' and a.qtyrcf > 0
      +   and a.latdtf >= :SDATE and a.latdtf < :LRDATE
      +   and a.fitemf = :ITEM# and b.opstcf <> 00
      +   group by a.fitemf, b.wkctrf, c.pfdsc2
     C/END-EXEC

If I run this program through the compiler, everything compiles fine but

if I use the verify in WDSC, I get errors on each line with a "+".

     C/EXEC SQL
      +  Delete from LEADSWRK
RNF0257: Form-Type entry for main procedure not valid or out of
sequence.
     C/END-EXEC

Anyone else running into this? I am up to date with all fixes in V6.0.

--
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.

--
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.

--
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.

--
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.



--
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.


--
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.