Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Posts
    3

    Unanswered: Stored Procedure issue

    Hi ,

    I am using DB2 Work Group Server Edition (Windows). I am quite new to DB2 and DB2 stored procedure. Somehow I managed to write several lines of code for the stored proc, but when the cursor holds number of rows above 100 my output shows the below and is not continuing

    spDefectList - Run information has been updated.
    DB2ADMIN.SPDEFECTLIST - Run started.
    Data returned in result sets is limited to the first 100 rows.
    Data returned in result set columns is limited to the first 20 bytes or characters.

    If anyone has any view on this please help me out.


    Thanks and regards,
    Anoop

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    How about posting the stored procedure definition and which version of DB2 are you using?

    Andy

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    are you using developer workbench for SP. It usually returns the first 100 rows. Just check there must be a option somewhere to disable it
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    AFAIK, there is no option to disable it ... If you want the full output, run it from a command window
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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