DB2 truncated output

Question

Hi, when i make select (command prompt WinXP) like:

enter code here db2 select message_data from messages where message_id = 20043

i get output + 'Output is truncated' message. message_data is LONG VARCHAR > 30000 characters

If i do like:

enter code here db2 select message_data from messages where message_id = 20043 > c:\otpt.xml

I get the same result. Is there any way to all data, not truncated?

Answer 1

OK, that's limitation of CommandLineProcessor(CLP). Up to 8000 symbols (db29320w - bug/feature). Other interface needed to run the query. For example MicrosotQuery in Office.

Answer 2

Hi

You could do a db2 export in order to retrieve the data.

db2 export to output.txt of del select message_data from messages where message_id = 20043

This will create a file calle output.txt that will have the value of column "message_data" between quotes.