henrycuyos
Member
Hi guys,
We're on Oneworld/xe S.P. 18 Rev. 4. HP/UX
I'm trying to convert journals from a legacy system into OW using Amtrix as the integration tool. The theory is that Amtrix uses the std. OW Apis' to insert records into the F0911Z1 table.
Everything seems to work ok aside from the date fields, DGJ, in particular. I turned jdedebug on which shows me the actual insert command line to the database. The fields/attributes values are what i expected them to be aside from DGJ.
I've tried julian dates, with and without quotes, dd/mm/yy, mm/dd/yy, mm/dd/yyyy formats with and without quotes, but all it's showing on the insert line for the date field is NULL DATA.
Anyone else out there encountered this before?
Regards
Henry
BBWE
Australia
We're on Oneworld/xe S.P. 18 Rev. 4. HP/UX
I'm trying to convert journals from a legacy system into OW using Amtrix as the integration tool. The theory is that Amtrix uses the std. OW Apis' to insert records into the F0911Z1 table.
Everything seems to work ok aside from the date fields, DGJ, in particular. I turned jdedebug on which shows me the actual insert command line to the database. The fields/attributes values are what i expected them to be aside from DGJ.
I've tried julian dates, with and without quotes, dd/mm/yy, mm/dd/yy, mm/dd/yyyy formats with and without quotes, but all it's showing on the insert line for the date field is NULL DATA.
Anyone else out there encountered this before?
Regards
Henry
BBWE
Australia