RE: SQLDA

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
What runs faster:

-DSPFFD from withing RPGLE, (I assume QCMDEXC, system() or some such
thing).  Then reading that output file.

-SELECT SYS_CNAME, SYS_TNAME, SYS_DNAME
 FROM syscolumns
WHERE sys_tname='IIM' and SYS_DNAME='DATDIVF'

-SELECT DBILIB, DBIFIL, DBIFLD,  DBIITP, DBIFLN, DBINSC
FROM qadbifld
WHERE dbilib='DATDIVF' and dbifil='IIM'

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Mike Haston ** Data" <MJH@jny.com>
Sent by: rpg400-l-admin@midrange.com
12/10/2002 04:49 PM
Please respond to rpg400-l

        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: SQLDA


I might have something that I'll look for later.  Not SQLDA, but RPGLE
that uses DSPFFD to an outfile and allows the user select fields to sort
by.


-----Original Message-----
From: Smith, Nelson [mailto:NSmith@lincare.com]
Sent: Tuesday, December 10, 2002 4:30 PM
To: rpg400-l@midrange.com
Subject: SQLDA


Does anyone have a good sample of Using the SQLDA in an RPG program where
the file name is completely dynamic?  In other words, to determine the
field
names and values on-the-fly, after determining the file name.  Or, a good
book of examples in RPG?

Nelson Smith
nsmith@lincare.com
ncsmith@tampabay.rr.com



************************************************************************************************************************************************************************************************************
This message originates from Lincare Holdings Inc. It contains information
which may be confidential or privileged and is intended only for the
individual or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the
contents of this message.
All personal messages express views solely of the sender, which are not to
be attributed to Lincare Holdings Inc., and may not be copied or
distributed without this disclaimer.
If you received this message in error, please notify us immediately at
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************************************************************************************************************************************************

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.