JDBC: Dynamic select statement

[Former Member]

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...

[prateek · Accepted solution]

Yes, it is possible. In mapping, u may map the target structure with currentDate standard message mapping function of XI.

Regards,

Prateek

[Former Member · Accepted solution]

Hi Prateek,

Now i am using Sender JDBC. Isn't it first selecting the data with the Query SQL Statement and then mapping? Am I missing something?

[santhosh_kumarv · Accepted solution]

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...

[prateek · Accepted solution]

At sender the above reply couldnt be applied.

U have to use some stored procedure then which may hanldle things at the sender system.

Regards,

Prateek

[dharamveer_gaur2]

Sender site you have to write sql query:select sysdate from dual. u can also use with other table, if u r selecting some column from any table.