IBM Sterling Transformation Extender

Sterling Transformation Extender

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

 View Only
Back to discussions
Expand all | Collapse all

Updating a column from outputcard using JDBC adapter

  • 1.  Updating a column from outputcard using JDBC adapter

    Posted 3 days ago

    Hi,

    I have also tried to update a column from outputcard with below command line.

    -URL <url> -USER <id> -PASSWORD <pwd> -T  test.dbl -AS 0 -QTY * -LSN 0 -schema <schemaname> -TABLE <tablename>  -WM UPDATE   -KEY id,fname 

    i have table with column as Id,fname,lname,status,contact

    it supposed to issue a update statement as update <tablename> set status='11' where id ='1',fname='T'

    but its generating update statement as below.

    <10100-9160-09/01/25 17:11:53>:    Generated UPDATE statement: UPDATE "<schema>"."<table>" SET "LNAME" = ?, "STATUS" = ?, "CONTACT" = ? WHERE "ID" = ? AND "FNAME" = ?

    i have tried with SETCOL parameter like below but adapter is not recognizing this parameter.

    -URL <url> -USER <id> -PASSWORD <pwd> -T  test.dbl -AS 0 -QTY * -LSN 0 -schema <schemaname> -TABLE <tablename>  -WM UPDATE -SETCOL STATUS  -KEY ID,FNAME 

    Please suggest if anyone has any suggestion to fix this.

    Thanks

    Santanu



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


Related Content