×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 )
Regards, Chuck
This mailing list archive is Copyright 1997-2024 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
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
