i'm developing a handler pgm to replicate a CHAIN to a SQL Select...
so i have done everything i need within my handler pgm to do the sql select and then what i thought i needed to do to loop back through the namesValues and update the value, valuelenbytes, and hasnullvalue...
I turn on p_IO.found because my row was fetched from the sql select.
but when it returns back to the calling rpg pgm i get...
A character representation of a numeric value is in error.
the dump shows that the fields for the chain (in which i replicated the sql select for) are all blank.
what am i missing?
btw, i'm working from Dans tutorial at...
and this part i'm referring to is covered under "Executing the statement"
so i have done everything i need within my handler pgm to do the sql select and then what i thought i needed to do to loop back through the namesValues and update the value, valuelenbytes, and hasnullvalue...
I turn on p_IO.found because my row was fetched from the sql select.
but when it returns back to the calling rpg pgm i get...
A character representation of a numeric value is in error.
the dump shows that the fields for the chain (in which i replicated the sql select for) are all blank.
what am i missing?
btw, i'm working from Dans tutorial at...
and this part i'm referring to is covered under "Executing the statement"
Comment