• Subject: Re: SQLRPGLE (was External file reads into DS's)
  • From: "Nelson C. Smith" <ncsmith@xxxxxxxx>
  • Date: Tue, 13 Jul 1999 22:30:19 -0400

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


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].