Question Regarding DB2 Host Variable Limitation

[mgjagadish]

Hi DB2 Pals,
I have a DB2 COBOL Host Variable which has to store char greater than 254 char.For DB2 V5 Max char length can be 254 bytes.What I need to store in DB2 Table is length of 2048 Char.I am developing a Stored Proc which has to insert those 2048 char into Database.So my question is How to I go about inserting data.I faced an SQL Error Code of -134.What this error Code says is the Max Length can be only 254 Char.I would sincerely appreciate your answers?

 

[dhecht]

In V.5, the maximum length of a VARCHAR is 4046 bytes for 4K pages;
32704 bytes for 32K pages.