Skip to Content

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

JDBC DATE conversion Issue

Hi All,

I am working on a Proxy to JDBC (Async to Sync) scenario in this I am passing a sender field to target and retrieving the data from data base as response

Created the Request structure as below

Statement

   Action

     Aceess

      f1

      f2

      f3

     f4

    Key

     f1

      compareOperation

     f2

      compareOperation

Mapped the source field to  f1 under key node and maintained the compare Operation as EQ and where the f2 field is the date,I have mapped it with constant( Value is GET DATE ()-90) and maintained the compare operation as GTEQ.

during run time getting issue at mapping as unable to convert the date,Could any one please help me with this.

Thanks & Regards,

AK

replied

Hi AK,

Second point is about doing string concatenation like below:

String1 = "SELECT f1,f2,f3,f4 from xyz where f1 = '"

f1 is from source field

String2 = "' and f2 = getdate() - 90'"

With this the access field will have entire select statement with source field value. The use of single quote (') in String1 and String2 will depend on value of f1. Single quote is required if the value of f1 is string and it's not required if it's numeric.

Better you can execute the query in database first and then place it in mapping.

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