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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB21006E The input command is too long. The maximum length is 65535.

Status
Not open for further replies.
jip102

jip102

Programmer
May 1, 2006
12
KR
Hi,
I would like to know whether I can increase the size of the SQL statement in
DB2 because I am getting the following error message:

DB21006E The input command is too long. The maximum length is 65535.

Some applications inserts blobs or clobs in one sql statement.

If I can change the sql size, then what variables I have to change?
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
269
prashant_0701
P
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
126
gdg1976
gdg1976
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
96
handle907
handle907
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
85
usr1234
usr1234
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
101
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top