Re: sql database in RPGLE program with lots of columns

Hi Kim,

jdbc_getCol() will return an alphanumeric string to your RPG program. Passing this string as input to %char() doesn't make any sense, as it's already a character field! The JDBC environment is converting ti to character for you, already.

I would start by looking at the format it's returning (stick some code in there for now that puts it into a character string, so you can display the data in debug.)

Once you know what the format looks like, it should be a simple matter of substrining it and passing it into the %date() and/or %dec() BIFs to convert it to the numeric format you want.

I see Alan posted a routine -- I don't know if the format you're receiving matches what his routine is expecting, but if it is, then perhaps his routine will save you some effort.

-SK


On 12/12/2012 2:22 PM, Kim Massar wrote:

Now I have a new problem, there are fields defined in the sql table as dates ([Original_File_Date] [date] NULL) in MMDDCCYY. In our iSeries file they are defined as numeric, in CCYYMMDD order.

1. Is this something I should not try, or will not be able to, convert when I get the columns? (removing the slashes and reordering fields).
2. I have tried this syntax, but does not work: CRTDT = %dec(%Char((jdbc_getCol(rs:12)):*iso-):8:0) . I get the first and second parameter are not allowed for *Char, so I am guessing I can't define the column number here? My reason for question #1!!