|
I am working on a query to generate a file with data that will mimic a file that is expected by a particular program, so I need to match field lengths, etc. My challenge comes because a few of the fields needed are packed numeric fields, as well as zoned numeric and character fields. I'm not aware of a way to accomplish this with query, but I would like to be surprised to hear that it is possible. Otherwise is there a way to convert the numeric fields that should be packed when copying the file to its destination library, or is there some other way to accomplish this? We are at V3R3. thanks -doug ***************************** DOUGLAS JOHNSON System Administrator University Book Store 711 State Street Madison, WI 53703 djohnson@xxxxxxxxxxxxxxx phone (608)257-3784 fax (608)257-9479
As an Amazon Associate we earn from qualifying purchases.
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.