Skip to Content
author's profile photo Former Member
Former Member

MaxDb 7.6 Output Size

What is the limit on the size of the output of a SQL query; and is this

configurable.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 21, 2007 at 11:54 PM

    Hi David,

    this depends on the client you are using. How are you querying the data? Do you mean the # of rows returned, or the data size of the returned query?

    In R/3, you can specify the # of result rows to be returned, while in SQL studio, the entire result set is returned.

    Thanks,

    Ashwath

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 22, 2007 at 02:27 PM

    The client is a java program and it uses a JDBC driver in order to do database access. When I do a select using a JDBC driver what is the maximum length

    of the data that can be returned from a table assuming a single row, and is this a configurable option.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      There is the parameter PACKETSIZE that defines the maximum size of a communication packet sent by the database. The maximum length of the statement directly depends on it, but there's no easy formula that directly derives from the PACKETSIZE the maximum length of an SQL statement or the output of the command.

      The lower and upper limits are 16384 <= PACKETSIZE <= 131072

      PACKETSIZE limits the length of the communication packets that transfer SQL statements and data. Increasing the PACKETSIZE accelerates data transfer for bulk commands, and also enlarges the storage requirements per user task.

      As a rule of thumb you can take the parameter PACKETSIZE, and subtract the parameter MINREPLYSIZE and ~ 1 KB (overestimation of the protocol overhead) to come up with the maximum output size.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 07:09 PM

    I tried your suggestion and found the "_PACKETSIZE" parameter to already be at the maximum length which is 131072. When I perform the query I still get the same error below

    Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

    General error;-2003 POS(8) Output columns too long

    select * from LineItem inner join LineItemTaxOvrflw on LineItem.lineItemId=LineItemTaxOvrflw.lineItemId

    The tables that I am joining don't fail on other databases such as Oracle,Sql Server,MYSQL, and DB2.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 27, 2007 at 08:35 PM

    My answers to your questions:

    a) which exact MaxDB version you are using (incl. Build-nr.)

    MaxDB 7.6.00.37

    b) the table definition

    LineItem and LineItemOvfl table each table has 512 columns and they are being joined together

    using a simple inner join on the primary key Id and number of columns that are being generated from the join are approximately

    1000 columns although alot of them have null values.

    c) UNICODE ?

    No

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.