RE: SQLDA

["Smith, Nelson" <NSmith@xxxxxxxxxxx>]

I'm trying to determine the best way to dynamically build the INTO clause of
a Fetch statement where the filename is determined dynamically within the
program.  I also want to avoid using any external file definitions.

As your other post mentions, it is possible to determine the field level
information from Syscolumns or the QADB files (which I think Syscolumns is
built over) or an API.  I do have a procedure that returns a MODS to me of
all the field layout info in a file and I can use that, but I also have
never used the SQLDA and was wondering if that was a better (or at least,
more SQLish) method to be using. All the examples I have been able to find
are either in another language, or not dynamic and use hard-coding of
field-layout information.

> -----Original Message-----
> From: rob@dekko.com [SMTP:rob@dekko.com]
> Sent: Tuesday, December 10, 2002 4:52 PM
> To:   rpg400-l@midrange.com
> Subject:      Re: SQLDA
>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Just curious.  I've never used the SQLDA.  What are you trying to
> determine from this?
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
> _______________________________________________
> 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 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.
************************************************************************************************************************************************************************************************************