Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: varchar limit in passing to db2 stored procedure

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Ramki,
    As far as I can tell, it is the maximum size of a VARCHAR.

    HTH

    Andy

  3. #3
    Join Date
    Oct 2004
    Posts
    3
    if you're talking about the INPARM, a field size max is 254 chars.

Posting Permissions

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