I am passing varchar array from my client to DB2 Stored procedure.
Like to know whats the maximum size I can pass using varchar to db2 stored procedure.

Currently I am using Varchar(500) in array(table format) format for passing data from client to db2 storedprocedure. Like to know the maximum value so that I can determine whether I can change this to reflect my future need.

Thanks
Ramki.

Ramki,
As far as I can tell, it is the maximum size of a VARCHAR.

HTH

Andy

if you're talking about the INPARM, a field size max is 254 chars.