cancel
Showing results for 
Search instead for 
Did you mean: 

UPDATE QUERY IN JDBC

Former Member
0 Kudos

Hi,

i am trying to update data in database but its not getting updated.can anyone tell me the solution for this.

can i get a link which involves updating data in database.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi

Edited by: vikas jain on Feb 12, 2008 11:57 AM

Former Member
0 Kudos

Hi,

1) What is your scenario basically tells about......

2) And what is the Error message you are able to see in MONI and in CC monitoring for Sender CC and Receiver CC....

Regards

Seshagiri

Former Member
0 Kudos

scenario is file -xi-jdbc.Im trying to update data in database but its not geeting updated.before this i try inserting data in database i was able to do it.but now updating is not taking place

also there is no error in sxmb_moni and cc of sender and receiver

Former Member
0 Kudos

Hi,

Do you have any error messages in sender cc. Check whether the input data which you are trying to send in the file is correct. Because sometimes the data format will cause an error in updating the DB.

Regards,

Nithiyanandam

Former Member
0 Kudos

Hi,

You can use the following statement

Update SQL Statement : Update student set readflag = 'Y' where readflag = 'N'

Folloow the receiver JDBC Structure as follows

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Seshagiri

Former Member
0 Kudos

Hi,

i have maintained the same structure as shown in the document

but the value is not geeting updated.also in runtime workbench

its giving no error

can u send me a link in which data is getting updated in the database is shown

plz its urgent

justin_santhanam
Active Contributor
0 Kudos

Vikas,

Did u created the structure as mentioned in the link

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

raj.