Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    35

    Unanswered: db2 query text limit

    Hi ,

    Does anybody knows what the query text limit in db2 (8.2,9.1,95)?

    and does using bind variables helps in reducing the query text size?

    Thank you,
    Ronen

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this page keeps all limits for current version
    SQL and XML limits
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this page keeps all limits for current version
    SQL and XML limits
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Sep 2004
    Posts
    35
    mucho gracias :-) but there's no indication to lime size of the entire SQL statement size??
    and still dont know if switching to using bind variables wil help reducing the size of an SQL statement

    Thank you,
    Ronen

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You need "Maximum total length of an SQL statement (in bytes)". That's the maximum length as it appears in your code. If you have parameter markers, the text is relevant. If you have spaces or comments, those count as well. The actual value to which a host variable refers to does not count.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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