On 02-Apr-2012 10:33 , Stone, Joel wrote:
The DOCSQL command is great - it builds larger strings than the one I
copied from the magazines, which is especially useful for building
row 1 of an excel spreadsheet containing all the column headings from
an Iseries PF with the ZFFDTOCSV command. These SQL commands can
get to be 1000+ characters when a file has lots of lengthy field
names.

Not sure what the length of the field names has to do with the SQL statement length for a statement used to generate a column heading row for CSV, but...

If interested, I had given an example of a recursive query which could be used to generate such a heading row from the catalogs for a named table; a query statement text which would be effectively fixed-length:
# Subject: Re: CSV file with a header
# Date: Fri, 21 May 2010 13:32:10
http://archive.midrange.com/midrange-l/201005/msg00932.html

Regards, Chuck

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].