 |
Harrington Michael |
at Oct 9, 2001 at 12:43 pm
|
⇧ | 
| |
Jie,
Since all you get back is a cursor (pointer), there is no limit on number
of rows.
As far as parameters :
CLOBS and BLOBS are supported in V6 - whatever those limits are...beyond
that I don't know of any beyond what the standard data types support.
The number of parameters is limited by the maximum value of the ORDINAL
column in SYSIBM.SYSPARMS (SMALLINT).
Hope this helps.
-----Original Message-----
From: jie zhang [SMTP:
[email protected]]
Sent: Monday, October 08, 2001 5:32 PM
To: Harrington Michael
Cc:
[email protected]Subject: Re: mutiple rows result from a stored procedure
Hi, Harrington,
Do you know if there is a limit of how many rows it could return ? I read
somewhere that there is 64K limit
on the in and out parameter ?
Thanks a lot,
Jie
Harrington Michael wrote:
Jie,
Stored procedures can return multiple rows. Personally, I just step thru
the array that fetch brings back to work with the rows. Works like a
charm!
-----Original Message-----
From: jie zhang [SMTP:
[email protected]]
Sent: Monday, October 08, 2001 3:17 PM
To:
[email protected]Subject: mutiple rows result from a stored procedure
Hi,
Can stored procedure return mutiple rows of a select statement ? In
another word, could I have collection or
varrys as out paramters ? If yes, is it recommended
to use stored procedure in this case or I should just use sql
statements
