Printing large DB2 table with LONGVAR column

Richard Pack

Printing large DB2 table with LONGVAR column
Looking for suggestions on how a customer can print a LONGVAR column of
data that is text.

COLUMN NAME COLTYPE LENGTH
TXT LONGVAR 3,948

I have customized DSNTEP2 to print 162 character column but I am not sure
about changing it for 3,948.
Are there other options available. I can get CA's ISQL to show all the
data on the screen but when I print it truncates it.

Thanks, and Happy and Safe Holidays!



James Campbell

Re: Printing large DB2 table with LONGVAR column
(in response to Richard Pack)
run SPUFI in batch?
http://jupiter.ryci.com/cgi/wa.exe?A2=ind0102B&L=DB2-
L&P=R16612 has some JCL from many years ago. You might be
able to get it to work for your current version.

James Campbell

On 21 Dec 2001, at 7:57, Richard Pack wrote:

Date sent: Fri, 21 Dec 2001 07:57:36 -0600
Send reply to: DB2 Data Base Discussion List <[login to unmask email]>
From: Richard Pack <[login to unmask email]>
Subject: [DB2-L] Printing large DB2 table with LONGVAR column
To: [login to unmask email]

> Looking for suggestions on how a customer can print a LONGVAR column of
> data that is text.
>
> COLUMN NAME COLTYPE LENGTH
> TXT LONGVAR 3,948
>
> I have customized DSNTEP2 to print 162 character column but I am not sure
> about changing it for 3,948.
> Are there other options available. I can get CA's ISQL to show all the
> data on the screen but when I print it truncates it.
>
> Thanks, and Happy and Safe Holidays!
>
>
> DB2-L webpage at htt
p://www.ryci.com/db2-l. The owners of the list can


James A Campbell



Raymond Bell

Re: Printing large DB2 table with LONGVAR column
(in response to James Campbell)
You could try QMF. Try changing the edit code for your TXT column to be CW
(I think; check the online QMF help for the right value) which wraps the
column data at the length you specify. So you'll also have to change the
column length from presumably 3948 to, say, 80. I'm guessing this would
also work in QMF batch.


Raymond



Richard Pack
<[login to unmask email] To: [login to unmask email]
ATE.MO.US> cc:
Sent by: DB2 Subject: Printing large DB2 table with LONGVAR column
Data Base
Discussion List
<[login to unmask email]
>


22/12/01 02:57
Please respond
to DB2 Data
Base Discussion
List





Looking for suggestions on how a customer can print a LONGVAR column of
data that is text.

COLUMN NAME COLTYPE LENGTH
TXT LONGVAR 3,948

I have customized DSNTEP2 to print 162 character column but I am not sure
about changing it for 3,948.
Are there other options available. I can get CA's ISQL to show all the
data on the screen but when I print it truncates it.

Thanks, and Happy and Safe Holidays!