Not able to read data from DB2 API stage
Posted: Thu Aug 28, 2008 7:39 am
Hi All ,
I am using DB2 API stage to read a mainframe tables . My job design is as below :
DB2 API ----->> Transformer ------>>> Oracle enterprise stage
There are 6 jobs like these extracting data from different tables and loading data into corresponding target tables . Apart from one job all jobs are working fine .
In one particular job , I am getting warning message like
Unable to set output decimal field value from argument string ' ' in function setOutputFieldAsDecimal() for field '0' in output dataset '1'.
Because of this i am not able to load the data .There are 5000 rows in the source . Job is running successfully but 0 rows are inserted .
In source there is a field : field1 DECIMAL type .When i viewed the data in DB2 API stage I am able to view ,But there is an empty string in that decimal field . Is this causing any problem ? My target table also its defined as decimal .
Request you all to help in solving this issue .
Thank you all
Nag
I am using DB2 API stage to read a mainframe tables . My job design is as below :
DB2 API ----->> Transformer ------>>> Oracle enterprise stage
There are 6 jobs like these extracting data from different tables and loading data into corresponding target tables . Apart from one job all jobs are working fine .
In one particular job , I am getting warning message like
Unable to set output decimal field value from argument string ' ' in function setOutputFieldAsDecimal() for field '0' in output dataset '1'.
Because of this i am not able to load the data .There are 5000 rows in the source . Job is running successfully but 0 rows are inserted .
In source there is a field : field1 DECIMAL type .When i viewed the data in DB2 API stage I am able to view ,But there is an empty string in that decimal field . Is this causing any problem ? My target table also its defined as decimal .
Request you all to help in solving this issue .
Thank you all
Nag