Re: Fetching into different host variable types

[rob@xxxxxxxxx]

I took a brief look at the SQL CLI API's and that seemed like a dark art to
me - and I'm fearless!

My workaround was a series of select statements each using a different
fetch.  Put this into a subroutine - crude but effective.

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



                    "Simon Coulter"
                    <shc@flybynight.c       To:     rpg400-l@midrange.com
                    om.au>                  cc:
                    Sent by:                Fax to:
                    rpg400-l-admin@mi       Subject:     Re: Fetching into 
different host variable types
                    drange.com


                    01/28/2002 07:55
                    PM
                    Please respond to
                    rpg400-l







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.

--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists
   http://www.flybynight.com.au/

   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------

_______________________________________________
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.