Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Question Unanswered: Subquery restiction

    HI All,

    I am a new user of SYBASE.

    I think Sybase has restriction that a query can contain maximum of 16 subqueries.

    Does any one has any idea on how to over come this restriction?.

    Thanks In Advance
    Vivek

  2. #2
    Join Date
    Jun 2002
    Location
    Dublin, Ireland
    Posts
    23

    Re: Subquery restiction

    Just use temporary tables and that will get around this limitation.

    Originally posted by vivek verma
    HI All,

    I am a new user of SYBASE.

    I think Sybase has restriction that a query can contain maximum of 16 subqueries.

    Does any one has any idea on how to over come this restriction?.

    Thanks In Advance
    Vivek
    Mark Sheehan,
    Senior Sybase DBA

  3. #3
    Join Date
    Sep 2002
    Posts
    2

    Re: Subquery restiction

    Hi,

    I am using the same but still my query which is generated at runtime(dynamis query) still creates a query which exceeds the limit.

    Could we do any setting in the database that can help me out

    Thanks
    Vivek

    Originally posted by msheehan
    Just use temporary tables and that will get around this limitation.


Posting Permissions

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