Skip to Content

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

Sender JDBC Dynamic parameter value in select query

Hi All,

I have a scnario where i have read only acess to a table and We cannot use stored procedures..

Interface is JDBC to file.

Now there is one filed in the table which holdes the system date and time.Ex filed name as Sysdate.

now can i use query as select * from table1 where Sysdate = x+1.

where X is the last process Sysdate field value.. is there any work arround to store the value in a file and check dynamically every time from that file to get the value of x and after that X+1 value has to be updated back to that file..

main aim is to eliminate duplicate entries.

Regards

Vijay

Helpful Answer

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