Skip to Content
0
Former Member
Jul 03, 2009 at 07:18 AM

Deleting data from a table(JDBC to IDOC scenario).

36 Views

Hi,

For JDBC to IDOC scenario, the requirement is as explained below:

1: There are 2 tables-> GDDB and CHANGES

2: Poll the CHANGES table every 30 mins everyday.

3: a)Publish the records for which the 'published' flag status is 'N'

b)Update the status as 'Y' after publishing.

4: On the first day of every month, delete the records from the CHANGES table if the record is 3 months old and 'published' status is 'Y'

I would like to know how update and delete can be done using one JDBC adapter?

Regards,

Vishal.P.Kulkarni