Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Maximum Size of statement in dbaccess

    Hi,
    I am trying to run an unload statement which is about 10000 lines long. I get an error which states that "Statement length too long"
    Any workarounds?
    This is on a HP-UX box
    Thanks in anticipation

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    can you do the same think via the script and pipe the statments into dbaccess?

    Can you provide the examples of a few lines?

  3. #3
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi,

    Probably I am not understanding it correctly, but do you really mean 1 statement. Or a lot of statements. I believe the maximum statementsize is limited to 64 KB. So if it is really one statement is looks really to big.

    Of the record: I can not really imagine what type of query I need to write to fill it up with 100000 lines. Only possibility is to have a major IN clause. Of course this can be avoided to firts insert the values in a (temp) table.

    Hope this helps,

    Rob

Posting Permissions

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