CODEWITHSUNDEEP
sqldb2truncate
Ruslan
Ruslan

Reputation: 319

DB2 truncated output

when i make select (command prompt WinXP) like:

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:

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?

Upvotes: 1

Views: 5818

Answers (2)

AngocA
AngocA

Reputation: 7693

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.

Upvotes: 1

Ruslan
Ruslan

Reputation: 319

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.

Upvotes: 0

Related Questions