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

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 10/17/2017 01:29:06
PM:

so since namesValuesDS.value is a pointer, i'd need %addr(g_hostData(i))

to

assign the pointer of g_hostData(i) correct?

Seems logical.

but what if that g_hostData value should be returned as char or numeric
depending on the column that namesValuesDS.value is representing?
g_hostData is simply a char value.

To the caller, g_HostData is just storeage (memory). If you only
need to return a pointer for it then you don't need to worry about the
fact that your program sees it as character storage. When you pass a
pointer then it is IBM code that has to deal with the format. Issues will
only arise if the value is not in your character storage as correct
hexadecimal format (packed, binary, or floating-point) for the caller or
if you have to move the value from your storage to a numeric field for
passing back the value. That is where and when the special handling I
alluded to earlier would come into play.

Sincerely,

Dave Clark