Skip to Content
0
Former Member
Feb 10, 2011 at 03:30 PM

FILE TO JDBC -->JDBC RESPONSE TO DB Table

75 Views

Hi Experts,

My Scenario is FILE TO JDBC:

File -


>DB(has to update 2 DB tables){one for inserting correct data records and the other for inserting error data records}

-


>DB response to update into another table (number of records has been inserted into DB in the above flow)

I have a file to be transfered through PI and store the data into Database.The file has different kinds of rows like header,payment and detail.

Now my requirement is:

1)it should use a control table to store when they ran, records processed, etc.

2)If some rows have wrong information (I.e. invalid number of fields) the entire row(error) should be stored into error tables field.

3)how do i capture number of records that has been inserted into DB and insert into a seperate table.

Could anybody suggest in which way i can proceed to fulfill the requirement.

Thanks in advance for your help.

Regards,

Kalam.