LONG VARCHAR in DB2

[dataforums]

Can anyone plz tell me what is worng in the following statement? I am trying to declare a LONG varable to hold a very large string.

DECLARE str LONG VARCHAR(8000);

THX

 

[rbod]

you probably don't need to mention the size for LONG VARCHAR.
try:
DECLARE str LONG VARCHAR;