if the size of the file is more than 64KB, then you have to split the
procedure into two or more to avoid this error, as the max size of
procedure in DB2 v8 is 64KB.
otherwise, let me know...

Jay

Satya wrote:

>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.
>
>---------------------------------------------------------
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>website: http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>

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