Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure CALL limitation

Status
Not open for further replies.
vmmdesai

vmmdesai

Programmer
Aug 7, 2002
4
IN

The DB2 Command Reference (pg 188) states that

"The maximum length for an INPUT parameter to CALL is 1024"

I have a SQL Stored Procedure accepting a string of length around 4000 bytes.
Is there any way to override this limitation and still be able to give a call to the SQL Stored Procedure?

 
Status
Not open for further replies.

Similar threads

galaxy0815
  • Locked
  • Question
SQL Multiple Joins + Subquery limitation
Replies
7
Views
156
galaxy0815
galaxy0815
vskr72
  • Locked
  • Question
Stored procedure stuck in a loop
Replies
1
Views
95
papadba
papadba
jjluna23
  • Locked
  • Question
rollback stored procedures 1
Replies
1
Views
147
MarcLodge
MarcLodge
letmelive1
  • Locked
  • Question
Identify Binary data stored in DB2 CHAR field 2
Replies
5
Views
287
papadba
papadba
niceboykunal123
  • Locked
  • Question
helpt to fix the stored proc to count rows of tables in db
Replies
5
Views
128
MarcLodge
MarcLodge

Part and Inventory Search

Sponsor

Back
Top