Hi:

When I executed a 3000 line sql procedure using db2, I get the following
error:

DB21034E The command was processed as an SQL statement because it was not
a valid
Command Line Processor command. During SQL processing it returned:
SQL0101N The
statement is too long or too complex. SQLSTATE=54001
Can some one give any solution, tried to increase following paramter too,
but did not help

(STMTHEAP) = 40960
(APPLHEAPSZ) = 40960


Thanks and Best Regards

SP
----------------------------------------- (on scbaprssxmrl)

This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by SCGroup and this email is not an offer, solicitation, recommendation or agreement of any kind.



Standard Chartered Bank ("SCB") is a member of SCGroup incorporated in England with limited liability. SCB's principal office is 1 Aldermanbury Square, London, EC2V 7SB, UK. SCB is authorised and regulated by the Financial Services Authority ("FSA") and in FSA's register under no. 114276. SCB's VAT no. is GB244106593. FSA is the lead regulator for the SCGroup. For regulators in other countries contact the local compliance officer.

---------------------------------------------------------

DB2 & UDB email list listserv db2-l LazyDBA home page