IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  JDBC adapter in ITX

    Posted 4 hours ago

    Hi,

    I am getting error and in somecases trace file not even getting generated while i am using the below query. i am using oracle jdbc driver to connect.

    GET("JDBC","-URL <URL> -USER <id> -PASSWORD <pwd> -TV -AS 0 -QTY * -LSN 0 -QUERY 'select * from employee where employeeid='1' ' ")

    select * from employee where employeeid='1'

    no trace is being generated for the above query and when i have changed the query by removing single quote like below then getting error as "missing expression".

    select * from employee where employeeid=1

    same type of issues for the below query as well. its not able to recognize %

    select * from employee where employeename like 'A%'

    is there any way to resolve this?

    Thanks

    Santanu



    ------------------------------
    Santanu Baral
    ------------------------------