CurryWurry
Member
We have table convertor to convert data from a file (native DB2/400) to a OneWorld generated table (FIBS01).
We always ran this convertor locally, which worked like a
charm.
It is our intention to run the convertor on our AS400 using
the OW Scheduler. So we created a server package and deployed FIBS01
and the table convertor to the AS400.
When we ran the TC on the AS400, the TC failed. Error messages were:
OS40001078 - DoPrepare: sql code is -204
JDB9900168 - Failed to initialize db request
JDB9909007 - Unable to obtain driver request handle
we did another test: we switched 'Buffered Inserts to Output
Tables' and 'Force Row by Row processing' of in the TC design,
deployed the TC again and now it worked. Accept:
- there were only 5400 records converted iso of 6700
- all the numeric fields were rounded, fe: .566777 became 1.000000
- some fields were blanc, while the corresponding fields in FIB32 were
populated (just Alphanumeric fields).
We ran the TC again locally (in CRP) and this worked fine. So the
problem is AS400 related.
Help on this would be much appreciated
Thanks!
We always ran this convertor locally, which worked like a
charm.
It is our intention to run the convertor on our AS400 using
the OW Scheduler. So we created a server package and deployed FIBS01
and the table convertor to the AS400.
When we ran the TC on the AS400, the TC failed. Error messages were:
OS40001078 - DoPrepare: sql code is -204
JDB9900168 - Failed to initialize db request
JDB9909007 - Unable to obtain driver request handle
we did another test: we switched 'Buffered Inserts to Output
Tables' and 'Force Row by Row processing' of in the TC design,
deployed the TC again and now it worked. Accept:
- there were only 5400 records converted iso of 6700
- all the numeric fields were rounded, fe: .566777 became 1.000000
- some fields were blanc, while the corresponding fields in FIB32 were
populated (just Alphanumeric fields).
We ran the TC again locally (in CRP) and this worked fine. So the
problem is AS400 related.
Help on this would be much appreciated
Thanks!