Insert to AS400 hangs
Posted: Mon May 19, 2008 5:53 am
Something I don't understand currently is happening during an insert to AS400.
- DRS Stage over ODBC (AS400 client not installed on DS Server)
- AS400 table is journalized
- Field datatypes - all character except one numeric. Data verified for Numeric field to be numeric (eg. :010) for all records
Job flow is as follows:
1. Calls procedure to create table by company site (list derived from source file)
2. Inserts records to table.
The job seems to insert a single line, then hangs. AS400 guys think this is a DS problem, because the table is created and accepts one line...I think it may be an AS400 problem for the same reason...
the truth is somewhere in the middle...
any ideas what might be causing this?
- DRS Stage over ODBC (AS400 client not installed on DS Server)
- AS400 table is journalized
- Field datatypes - all character except one numeric. Data verified for Numeric field to be numeric (eg. :010) for all records
Job flow is as follows:
1. Calls procedure to create table by company site (list derived from source file)
2. Inserts records to table.
The job seems to insert a single line, then hangs. AS400 guys think this is a DS problem, because the table is created and accepts one line...I think it may be an AS400 problem for the same reason...
the truth is somewhere in the middle...
any ideas what might be causing this?