|
Thanks, I am completely baffled. I can use STRQM and STRSQL which I verified. I then tried C/EXEC SQL again in a SQLRPG member and it worked. Before, there was a message stating that the directive didn't exist, now the message says there are no SQL instructions. I will try to create my first SQLRPG as soon as possible. Ps before you think me completely mad, no one else was able to type C/EXEC SQL either. We have been trying on and off for years. When we were on V5R2 and it didn't work, we waited for V5R3 and it still didn't work. ----- Message d'origine ----- De : "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx> À : "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx> Envoyé : mardi 19 septembre 2006 16:40 Objet : Re: [WDSCI-L] /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. -- 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
