JDBC adapter - Select

[Former Member]

Hi,

We are faced with a scenario where we have to select from a very sensitve database which has tables without a flag for new or updated records. Therefore we are faced with a Select without Update as the DBMS tables cannot be appended nor a work area be created. The scenario calls for selecting close to 300,000 records on single run/daily. I guess the only option not a pretty one is to do the select without update. Any other ideas??

Teresa

[Former Member]

Hi Teresa,

Since you have to run this interface only once a day you can schedule in jdbc sender adapter poll interval accordingly. So select all the records should not be a problem. Since you dont have an update option in jbdc sender communication channel it is mandatory. So put <TEST> in update column in sender communication cahnnel which should take care of this. Rest your approach should be very straight forward as you mentioned.

Regards,

---Satish

[abhijitbolakhe]

Hi

If you have 'updated date' column in your table...select records based on updated date.

another option : create a table with fields as table name, flag,updated date.

Now write a select query such that ...records be fetched from the table based on the new table.

also write a update query ...like update flag and date to current date time.

Regards

Abhijit

[Former Member]

Hi,

We have zero support on the DBMS side and the updated column is very inconsistent. I was wondering if there was anything that can be done on the PI part to seggregate old and new records?

Teresa