Thanks Jay,
Is this true for unix aix 5.2 platform too.
Thanks and Best regards

Satya




"jayakumar " <db2udbdba-ezmlmshield-x63765502.[Email address protected]
11/25/2004 12:02 PM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Re: Procedure compilation error

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
>
>
>


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



----------------------------------------- (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