RE: SQLDA

David,

Wow, that will take some time to digest....  Maybe I'll get a little time to
play over the holidays.  :) Thanks for the pointers.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: David Morris [mailto:David.Morris@plumcreek.com]
Sent: Wednesday, December 18, 2002 5:36 PM
To: rpg400-l@midrange.com
Subject: RE: SQLDA


Eric & Ron,

The iSeries-toolkit at www.iseries-toolkit.org contains examples of
using the SQLDA
and late bound numeric copy APIs. See:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/iseries-toolkit/iseries-toolk
it/src/qrpglesrc/dynsql.sir?rev=HEAD&content-type=text/vnd.viewcvs-markup
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/iseries-toolkit/iseries-toolk
it/src/qrpglesrc/cvtnumfmt.irp?rev=HEAD&content-type=text/vnd.viewcvs-markup

These allow you to build dynamic screens. Here is some documentation:

http://sourceforge.net/docman/display_doc.php?docid=8869&group_id=39365

David Morris




>>> Ron@cpumms.com 12/13/02 09:12AM >>>
[ Converted text/html to text/plain ]

Eric,

I imagine this would work too. But Barbra (and I'm appologizing in
advance if
I'm misspelling her name cuz I know that irritates her but I don't have
a
posting from her handy at the moment) once posted an easy method of
unpacking
packed fields from a character string. I think I posted an example of
that
method on my first post. Do you know if these API's would work for
other data
types,ie. binary, timestamps, etc. ?



Ron Hawkins


"DeLong, Eric" <EDeLong@Sallybeauty.com>
Sent by: rpg400-l-admin@midrange.com
12/13/2002 09:31 AM CST
Please respond to rpg400-l
To: "'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
cc:
bcc:
Subject: RE: SQLDA

This is getting way beyond me, but wouldn't the "late bound copy" apis
be
appropriate to extracting your parsed values?  Here's the post I
remembered....
_______________________________________________
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.