471,073 Members | 1,386 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

SQL0101N The statement is too long or too complex.

Hi,

some user is getting error mentioned in subject and sql is 220 lines
long
how can i fix this ?

Sep 7 '06 #1
2 5023
"crazy_jutt" <ud******@gmail.coma écrit dans le message de
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi,

some user is getting error mentioned in subject and sql is 220 lines
long
how can i fix this ?
Hi, increase STMTHEAP in your database configuration, by steps of 1024,
until the statement succeeds (this parameter is dynamic)

HTH,

Jean-Marc
Sep 7 '06 #2
thanks jean.

Jean-Marc Blaise wrote:
"crazy_jutt" <ud******@gmail.coma écrit dans le message de
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi,

some user is getting error mentioned in subject and sql is 220 lines
long
how can i fix this ?
Hi, increase STMTHEAP in your database configuration, by steps of 1024,
until the statement succeeds (this parameter is dynamic)

HTH,

Jean-Marc
Sep 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by Fábio Mendes | last post: by
47 posts views Thread by Andrey Tatarinov | last post: by
30 posts views Thread by John Bailo | last post: by
8 posts views Thread by nano2k | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.