cancel
Showing results for 
Search instead for 
Did you mean: 

Sender JDBC adapter donot want to update database..

Former Member
0 Kudos

Hi,

We have JDBC to RFC scenario. In This we need to read only database table , we should not update it. As in sender JDBC adapter configuration Update SQL Statement is mandatory, so what needs to be done in this case?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Aparna,

If you do not want to update DB, then just put <TEST> in the update section.

Regards,

Vishal

Former Member
0 Kudos

Hi Aparna,

I agree with Vishal Reply. if there is no need of any updatation just u can text it as <TEST> for the Update statement field.

Regard's

Preethi

Answers (6)

Answers (6)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Follow VIshal's reply. Use <TEST> tag in the update statement. Though it is not recommended in the production environment, it does not impact.

Former Member
0 Kudos

Hi,

In place of the SQL statement, you can also enter <TEST>. Once the data determined from Query SQL Statement has been successfully sent, the data in the database remains unaltered.

This is recommended if the data has not only been read, but also changed by a stored procedure entered under Query SQL Statement.

http://help.sap.com/saphelp_nw04/helpdata/EN/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Regards,

Manjusha

Former Member
0 Kudos

Hi,

Go with Vishal P reply...

Regards,

Krishna

Former Member
0 Kudos

Hi Aparna,

Even if you pick records from a delta table (deletes old records and insert new records to be processed), it is better suggested to use update statement updating a status field.

However if you are looking not to use UPDATE query use <TEST> or * in the col.

Regards,

Pranav

former_member192238
Participant
0 Kudos

Aparna,

With out updating the status column duplication of data will happen.

Regards

Praveen

naveen_chichili
Active Contributor
0 Kudos

Hi Aparna,

What exactly are you going to acheive by only reading data from database??

if you are not updating the database there are chances to process duplicates.

please elobarate.....

Regards,

Naveen