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

["Nelson C. Smith" <ncsmith@xxxxxxxx>]

Basically, that's what I'm trying to do.  Create standardized I/O procedures
in service program for various files.  However, the precompiler prevents me
from using common sections of code (which could be about 95% of it) because
it thinks everything is a duplicate, even though they are in separate
procedures.  I'm really trying to avoid having to create a separate service
program for each procedure.

By the way, have you ever run into the problem of using the cursor to fetch
multiple records into a multiple occurrance data structure and having it say
it only returned one record, even though it actually loads two records, and
returns with absolutely no errors of any kind.  It seems to only happen when
a variable length field is one of the fields being returned to the MODS.
I've tried defining it at the minimum length, the maximum length, and even
the maximum length + 2.  Same result every time.

-----Original Message-----
From: David Morris <dmorris@plumcreek.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Monday, July 12, 1999 12:56 PM
Subject: 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.


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