Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Lightbulb Unanswered: I Want To Get Only First Rows !!

    I WANT TO GET ONLY FIRST ROWS !!
    WHEN I EXECUTE NEXT STATEMENT,OCCURS ERRORS.
    WITHOUT FETCH FIRST SENTENCE,NO ERRORS
    WHY? WHY? WHY?

    SQL SENTENCE
    Eselect BBB from AAA FETCH FIRST 10 ROWS ONLY

    APPLICATIONS ENVIROMENT
    EWebsphere4.0.1
    EDB2 Universal Database 7.2

    ERROR MESSAGES
    ESQL0405N

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What does error SQL0405N say in the Messages and Codes manual?

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    Originally posted by Marcus_A
    What does error SQL0405N say in the Messages and Codes manual?

    "The numeric literal literal is not valid because its value is out of range"
    in the Messages and Codes manual.
    but I have no solution .

    now I think that cache of Websphere may be the cause...

  4. #4
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    37

    Re: I Want To Get Only First Rows !!

    It appears your trouble stems from WebSphere's use of the statement cache. IBM has published a fix in DB2 Version 7 FixPak 9.

    If you do not want the fixpack (you should unless some really compelling reason prohibits you from appying it), do not use the statement cache, SETMAXROWS(0).

    More info:
    http://www-3.ibm.com/cgi-bin/db2www/...aparno=IY34909

    Cheers,

    Julius

  5. #5
    Join Date
    Sep 2003
    Posts
    4

    Re: I Want To Get Only First Rows !!

    thank you !!

    It succeeds with Fixpak.
    (DB2 version 7 Fixpak 9 )

    cheers

Posting Permissions

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