how to access DB2 Counts in a job
Posted: Thu Nov 05, 2009 12:06 pm
Hello,
I have a job where I am loading data from a flat file to a database.
Flat file -> Transformer -> Db2 API Stage
I know that there are 100 records in the flat file. Now I want to know how many of them are inserted into the DB2 Tables?
I can get that by saying select (*) from db2.table, but how can I do a comparision between the flat file content to that of Db2 count? Is there a way in which I can accesss Db2 counts with in the same job?
Regards,
I have a job where I am loading data from a flat file to a database.
Flat file -> Transformer -> Db2 API Stage
I know that there are 100 records in the flat file. Now I want to know how many of them are inserted into the DB2 Tables?
I can get that by saying select (*) from db2.table, but how can I do a comparision between the flat file content to that of Db2 count? Is there a way in which I can accesss Db2 counts with in the same job?
Regards,