Forum Discussion

N78A's avatar
N78A
Contributor
7 years ago

Hi, I am trying to use a SQL query in JDBC oracle connection test step

Hi, I am trying to  execute SQL query using 'LIKE' operator in JDBC oracle connection test step   Details: I have defined property - "yearMonth" in JDBC test step . yearMonth is picking value from ...
N78A's avatar
N78A
Contributor

Hi nmrao,

 

Thanks a lot for your response!

But unfortunately I can not use '%' in value because I am fetching the data from test data file (which I am using to run my request) , so adding % in value will make the test data invalid and my request would fail. 

basically I am trying to fetch the response for the 'customerId' for duration 'yearMonth'.  And then comparing the response with the data present in database for that particular customerId for that duration - yearMonth

 

anything else you can suggest please ? 

 

  • N78A's avatar
    N78A
    Contributor
    7 years ago

    Hi ,

     

    Thanks again. I tried to understand the property expansion feature. Will come back once I do it. 

    thanks. 

    • N78A's avatar
      N78A
      Contributor
      7 years ago

      Hi,

       

      I used substr(transaction_date_key,1,6) = :yearMonth and it did the work. Anyways thanks for your responses.