Re: Fetching into different host variable types

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Rob,

I Missed the original post, but Simon is correct. You do
need an SQLDA or to use the Call Level Interface (CLI).
If you are interested, you can download a set of procedures
I created that supports running dynamic SQL statements
and the SQLDA. They are part of the iSeries-toolkit.

Here are some links to an example that shows how this is used
and also the source for the DYNSQL prototype and module:

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


http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/iseries-toolkit/CVSROOT/src/qprotosrc/dynsql.proto.irp?rev=HEAD&content-type=text/vnd.viewcvs-markup

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

There is a lot more support for the SQLDA and I am working
on a file generation procedure (you give it an SQL statement
and it will create a file based on the statement). To download
the full package, go to:

http://iseries-toolkit.sourceforge.net

David Morris

>>> shc@flybynight.com.au 01/28/02 05:55PM >>>

Hello Rob,

You wrote:
>If this is my problem, then help me understand to do dynamically
select
>the variable types on the Execute FetchStmt using...
>For example, the next time I run this program it may be :AlphaK,
:Packed,
>:PackedR

It's been a very long time since I did anything like this but I think
you
need to build an SQLDA to accomplish this.  You could probably use the
SQL
CLI APIs also.

Regards,
Simon Coulter.