|
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!!
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.