This job failed in the dataflow that resets a column from a value to ‘space’ so that each record can be loaded by the target system batch processing.
The target is an AS400 (iSeries) DB2 database table that is accessed via DB2 connect from the job server (pSeries) running AIX 5.3
The error message (obscured for security reasons) is:
Data Services 12.2.3.1
I’m totally flumuxed - did I mention it’s never failed before?
I’m thinking of changing the mapping from:
-> ' ' <- (<single quote><space><single quote>)
to:
char(32)
Anyone able to offer any advice?
Simple Simon (BOB member since 2007-09-07)