RE: RPG SQL precompiiler

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

Hi Rob,

I also tried to pursue this one through my CSR, but basically got nowhere.
They led me to believe that I was the only one in the land who had been
affected by this.

FWIW, I worked around the problem by changing the msg severity of SQL1003
from 30 to 9. The pre-compiler still grumbles about it, but it's no longer
important enough to stop the compile. So far, I have not encountered any ill
effects from using this technique.


John


> -----Original Message-----
> From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
> Behalf Of Rob Berendt
> Sent: Wednesday, July 14, 1999 7:59 AM
> To: RPG400-L@midrange.com
> Subject: Re: RPG SQL precompiiler
>
>
> One thing I don't see the RPG SQL precompiler supporting is nested
> /COPY's.  I use this for my H specs.  My service program does a /COPY
> of one group of H specs.  All other programs do a /COPY of another,
> which in turn does a /COPY of the same one that the service program
> uses, with some additional lines.  When I try this on an SQLRPGLE
> program I get:
> SQL1003- Nested /COPY statements not allowed.
> I submitted a DCR, Design Change Request, formerly called a PASR to
> Kevin Toliver at 507-286-6062.    Kevin is the coordinator for this.
> I've not heard squat.  It has been my experience that the people in
> this position change rapidly.
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> * This is the RPG/400 Discussion Mailing List!  To submit a new         *
> * message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
> * from this list send email to MAJORDOMO@midrange.com and specify       *
> * 'unsubscribe RPG400-L' in the body of your message.  Questions should *
> * be directed to the list owner / operator: david@midrange.com          *
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *