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

[Former Member]

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

[Former Member]

Hi,

Thanks a lot for the quick response and making the point clear that delete functionality need not happen from XI's end.

Regards,

Vishal.P.Kulkarni

[Former Member]

Vishal ,

Not necessary that delete functionality should happen from XI's end..

Use "select" and "update" for publishing and updating @ JDBC adapter level.

Regards,

[MichalKrawczyk]

Hi,

update:

there is a field in the sender jdbc adapter - SQL statement for update - put it there

delete - On the first day of every mont

create a job on the database which will trigger the delete statement

it does not/ should not have to be done with XI

Regards,

Michal Krawczyk