Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Location
    India
    Posts
    96

    Unanswered: Sybase 12.5.0 limitations

    All,

    My name is Karthik. This is my first post in this site. I am very glad to see people here. As i need to travel long distance, I have decided to take some good experts help from here along with me. I hope i can.Okay.

    I am working in sybase12.5.0 & 12.5.4 version.

    I would like to know some basic limitations between these two versions.

    Say for example,

    what is the limitations of the following commands between these two versions?

    1) Number of AND's & OR's
    2) Number of IF
    3) Number of CASE in a select
    4) Number of Columns in a SELECT clause
    5) Number of Joins

    Inputs are welcome !

  2. #2
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    Any Inputs ?

  3. #3
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Quote Originally Posted by karthi_syb
    Any Inputs ?
    Welcome to the forum.


    Usually when you see 12.5 and 12.5.X, it means the X is an patch fix to whatever features that was introduced in 12.Y. So, you shouldnt see any major differences in terms no of cases etc.

    Having said that, this is a very odd query in the fact that not everyone uses 100 case statements on a select.

    Theres a wealth of information on http://sybooks.sybase.com/nav/base.do

    And you can always try out the SQL in your dev environment and see if it bombs

  4. #4
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    Ok.
    But i got an error message when i executed a query.

    Error message is:

    Limitation's of AND's or OR's is 255 only.

    But the same query executed fine in sybase12.5.4 version. How ?

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Are you going to treat us to the SQL?

Posting Permissions

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