On 28-Mar-2012 15:36 , Stone, Joel wrote:
I need a flat file with a large record length to send to Excel, so I
CRTPF FILENAME rcdlen(3000)
CRTPF FILENAME RCDLEN(specified) creates a /flat file/ which requires
the program to describe the file; i.e. a program described file. Unless
the utility being used can be told how to describe the file [because an
external description is not available to the utility-as-the program], a
utility may honor the definition of the undescribed file as CCSID(*HEX)
[aka CCSID(65535)] meaning "do not translate" the data.
One option is to use CRTSRCPF FILENAME RCDLEN(3012) instead, to
create an externally described text [aka source] file, optionally
specifying a CCSID() other than the default of CCSID(*JOB).
Another option is to use
CREATE TABLE FILENAME (
aField CHAR(3000) /* CCSID specified-or-dft-job-CCSID */ not null )
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.