Error in DB2 stage
Posted: Thu Sep 09, 2010 3:21 am
Hi,
I have ajob design as below:
DB2 stage------>copy stage------->DB2 stage
In Source DB2 stage I'm writing query as "SELECT Rtrim(CHAR(BIGINT(INTERNET_ORDER_NBR))) AS INTERNET_ORDER_NBR from #$prsnt_SchemaName#CS_ORDER_FACT where ORDER_KEY IS NULL" to get INTERNET_ORDER_NBR(decimal(9,0)).
In target DB2 stage I'm just specifying the table name to load the records and the write method i used is LOAD and write mode as APPEND.
My issue is the job is getting executed succeessfully and its showing the Job performance statistics correctly but when I tried querying target table,it is showing total no records as 1 with value 0.
Please help me out in getting out of this issue and where the issue lies..
Thanks & Regards,
Kalpana.
I have ajob design as below:
DB2 stage------>copy stage------->DB2 stage
In Source DB2 stage I'm writing query as "SELECT Rtrim(CHAR(BIGINT(INTERNET_ORDER_NBR))) AS INTERNET_ORDER_NBR from #$prsnt_SchemaName#CS_ORDER_FACT where ORDER_KEY IS NULL" to get INTERNET_ORDER_NBR(decimal(9,0)).
In target DB2 stage I'm just specifying the table name to load the records and the write method i used is LOAD and write mode as APPEND.
My issue is the job is getting executed succeessfully and its showing the Job performance statistics correctly but when I tried querying target table,it is showing total no records as 1 with value 0.
Please help me out in getting out of this issue and where the issue lies..
Thanks & Regards,
Kalpana.