Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can we use both INSERT and UPDATE at the same time in JDBC Receiver

Hi All,

I would like to know is it possible to use both INSERT and UPDATE at the same time in one interface because I have a requirement in which I have to perform both the task.

user send the file which contains both new and old record and I need to save those in MS SQL database.

If the record exist then use UPDATE otherwise use INSERT.

I looked on sdn but didn't find any blog which perform both the things at the same time.

Interface Requirement

FILE -


> PI -


> JDBC(INSERT & UPDATE)

I am thinking to use JDBC Lookup but not sure if it good to use for bulk record.

Can somebody please suggest me something or send me the link of any blog or anything to solve this problem.

Thanks,

Former Member
Not what you were looking for? View more on this topic or Ask a question