Re: dynamic sql - receive fetched row values into host variables

On 10/16/2017 4:56 PM, Jay Vaughn wrote:

I'd like to hear from others and any code demonstrations would be nice.

Did you take a look at the link to David Morris' iSeries Toolkit?
In it, he has a service program called DYNSQL that implements most, if
not all, of what you seem to be trying.  The prototype for GetColInf
needed tweaking - I'm now on 7.3.  Several columns needed to become
character type 'c' and CCSID(*UTF16), but it compiled and ran against
his TSTDYNSQL RPG program.

not enough concrete examples.

The one time I needed to do something like this, I was working for a
software house.  That code is their property, and I can't share it.  I
suspect that those few other RPG programmers who have done this are in a
similar situation; thus, few examples.

  --buck

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD