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 ?
- John Voris
