User Profile

Collapse

Profile Sidebar

Collapse
mfdeveloper
mfdeveloper
Last Activity: Mar 28 '11, 06:56 PM
Joined: Mar 25 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mfdeveloper
    started a topic Using Host Variables in Xquery
    in DB2

    Using Host Variables in Xquery

    I am trying to update some data in XML column. Input data is coming from file.
    I wrote this SQL in COBOL program.

    Here is my SQL.

    EXEC SQL
    UPDATE COMFIL.FORM
    set Form_Data_xml =
    xmlquery('trans form copy $new := $FORM_DATA_XML
    modify do replace value of
    $new/Filing/FilingKeys/INT_DCMT_ID with "129292929" return $new')
    where DCMT_LCTR_NMBR = 'PM1148600349'...
    See more | Go to post
    • mfdeveloper
      started a topic Using host variable in XQuery - for embedded SQL
      in XML

      Using host variable in XQuery - for embedded SQL

      I am trying to update some data in XML column. Input data is coming from file.
      I wrote this SQL in COBOL program.

      Here is my SQL.

      EXEC SQL
      UPDATE COMFIL.FORM
      set Form_Data_xml =
      xmlquery('trans form copy $new := $FORM_DATA_XML
      modify do replace value of
      $new/Filing/FilingKeys/INT_DCMT_ID with "129292929" return $new')
      where...
      See more | Go to post
      No activity results to display
      Show More
      Working...