Re: SQLRPGLE (was External file reads into DS's)

Nelson,

My solution to the dearth of SQL RPGIV support was to write a set of 
procedures that support SQL dynamically which I call from RPGIV 
programs.  It contains procedures like execsel, fetch, etc.  That way 
only that one module is limited.

The pre-compiler has historically been about a release back.  
Lately, it has been worse.  I haven't tried lately, but long field 
names, like named local variables, %null, embedded /copy, 
variable character, field prefix (causes mch on compile), etc.  
I was told that sending in the comment card at the back of the 
manual is the best way to get results.

David Morris

>>> "Nelson C. Smith" <ncsmith@gate.net> 07/10/99 08:20PM >>>
If IBM is serious about wanting us to use SQL as a "standard" database
language, they could at least give us an RPG precompiler that works.  I
would be willing to to bet that the C SQL precompiler understands Includes
and local variables.


>>> -----Original Message-----
>>> From: John Carr <74711.77@compuserve.com>
><SNIP>
>
>
>I believe Rochester owns the precompiler.  I really don't think they
>give a rip about RPG period,  so it's hard getting any thing done.
>It's a single pass precompiler,  which is why you can't have the
>FETCH physically before the DECLARE etc in your program code.  It S@#$%^
>If anyone is listening from Rochester would love to hear from you
>on this matter.
>
>John Carr


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