On 06 Mar 2013 08:01, CRPence wrote:
<<SNIP>> However generically, the SQL INSERT is not conducive to
effect the FMTOPT(*MAP) because the data is inserted by column
positions rather than by column names
This got me thinking. I do not recall seeing anything in the Paul
Conte SQL book relative to this.
But after one does a field mapping, is it allowed to do a load in
SQL by column number ?
Could one do something like . . .
INSERT into NEW_FILE
SELECT 1,2,4,7 FROM OLD_FILE
. . . I expect that it is bad form, but does SQL tolerate it ?
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact