OPNQRYF question: how to build format without mapping each field -- MIDRANGE-L

Subject: OPNQRYF question: how to build format without mapping each field
From: "Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx>
Date: Tue, 30 Nov 1999 12:31:32 -0500

Title: OPNQRYF question: how to build format without mapping each field

I use OPNQRYF to make one file format look like another. If the input file format has 10 fields, and the output format has 50 fields, must I map the 40 missing fields and load each with a constant?

Is there a way to avoid mapping the 40 missing fields? I would think CPYFRMQRYF *MAP should work, but maybe that is too late.

Any other ideas?

Does SQL handle this better???

Thanks!

Follow-Ups:

Re: OPNQRYF question: how to build format without mapping each field , Howard Weatherly
Re: OPNQRYF question: how to build format without mapping each field , Peter Dow

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