Re: Compiling SQLRPGLE programs

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Robert,

It sounds like you are using CRTSQLRPGI to compile directly to a *PGM object
(option 14 in PDM). If this is the case, try adding DFTACTGRP(*NO)
ACTGRP(*NEW) to the "H" spec.

Another option is to use CRTSQLRPGI to compile to a module(option 15 in
PDM), followed by CRTPGM. This is how I create all of my ILE programs
(including SQL ones), so I know that it works.


John Taylor
Canada

----- Original Message -----
From: <ilechr@cbs.fiserv.com>
To: <RPG400-L@MIDRANGE.COM>
Sent: Friday, February 04, 2000 09:46
Subject: Compiling SQLRPGLE programs


>
> Gentlemen,
>
> I have just created an RPGLE program type SQLRPGLE. In addition to the
> embedded SQL I have included a subprocedure. On compilation the error
> message stated that procedures are not allowed with  DFTACTGRP(*YES) as a
> parameter. But how can this be changed to *NO
> when the option is clearly absent on the  CRTSQLRPGI  command?
>
> Robert Ilechuku
> ilechr@cbs.fiserv.com
>
>
>
>
>
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---