Skip to Content

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

JDBC: Dynamic select statement

Hi,

I am working on a JDBC to SAP integration. I am trying to SELECT data from table for a specific time interval.

In the JDBC configuration i am using the Query SQL Statement

For example: select * from X where time='20080808'

Now is it possible to use for example the system date and time of the server where pi is installed or any other dynamic data?

Maybe like this: select * from X where time =@sysdate

If it is possible how? If not why?

I appreciate your help.

Thanks in advance...

replied

Hi,

In case of receiver JDBC you can map todays date to the select statement and make the select statement dynamic, however in the sender it can't be done. The work around may be to call the stored procedure from the sender adapter and using the stored procedure construct the select query dynamically.

Thanks

SaNv...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question