Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: ? mark in insert statement

    Hi Folks,

    What does question mark (?) in the following insert statement mean ?

    insert into AMERT1.NOTE (NOTE_ID, DEFECTS_VAL_1, DEFECTS_VAL_2, DEFECTS_TYP_ID, NOTE_SETTINGS_ID) values (?, ?, ?, 6, defect)

    Thanks,
    Panditt

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The ? is a parameter marker for a prepared SQL statement. The statement is compliled (prepared), and then it is executed with specific values in place of the parameter markers. This allows DB2 to use one compliled package (with the access plan) that can be cached in memory and reused even though the parameter marker values change for each execution.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Posts
    76
    Excellent !! thanks a lot Marcus.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •