If you need to extend the UNLOAD LRECL created by Batch Processor
Unload, so the unloaded records fit into ONE-RECORD-PER-ROW - this
can be done too:
ROWLEN ( [F,V] )
The ROWLEN keyword directs the UNLOAD to unload the table one row
Specify F for fixed blocked records, or V for variable blocked
records. The LRECL and
BLKSIZE will be determined for you. The LRECL will equal the
maximum length of the
An example of the ROWLEN keyword being used is shown below.
FOR FETCH ONLY
> -----Original Message-----
> From: Rob Crane [SMTP:[login to unmask email]
> Sent: 18 December 2000 16:48
> To: [login to unmask email]
> Subject: Re: CA/Platinum LRECL Usage
> The intended benefit of using the LRECL-USER value is to allow
> unloaded data (sysrec dd) to have a specified length greater
> fast unload would have calculated (based on # of columns and
> those columns). Probably tied over to the old vsam days when
> wanted to unload DB2 tables to a flat file and then process
> file instead of the DB2 table. Having the ability to have a
> in a program and the unload file would allow the vsam program
> change if the table added columns or deleted columns, etc. The
> length is padded with blanks.
> Here are the warnings, etc.
> Fast Unload determines the record length for the unload
> upon the number of columns and the sizes of the columns being
> However, you can force the record length for subsequent
> processing by specifying both the LRECL and the LRECL-USER YES
> on the DD statement. The LRECL you specify must be at least as
> the record length Fast Unload would assign to the unload
> extra space is padded with blanks.
> Note > *> While an effort has been made to minimize its
impact, forcing the
> record length could result in performance degradation as more
> data are written for an LRECL that is longer than the Fast
> Unload-determined record length.
> WARNING > *> This feature can be unintentionally
influenced by SMS ACS
> routines that provide default LRECL values. Using Fast Unload
> data class that provides this feature is not recommended.
> Billy Shears wrote:
> > I have a question to all CA/Platinum utility users:
> > We need to extend our LRECL beyond what Pt/Unload would
> > It seems there is a LRECL parameter in the utility that
can do the trick.
> > Questions: Are there any users using this feature? How
does it work? Are
> > there any things I should know (e.g. what comes in the
> > Thanks,
> > Bill Shears - [login to unmask email]
> > DB2 DBA
> > HOLO Enterprises Inc.
> > Get your FREE download of MSN Explorer at http://explorer.msn.com