Re: SQL INSERT with unequal fields

Jeff,
Many times, when searching for a solution, people tend to
forget that in business (as in life) things don't always
have an "either/or" solution. In the IT "fad world" of
today we have a tendency to run to the latest craze and
forget that there are a myriad of possible answers out
there with our "outdated" tools.

I love SQL as much as the guy next door, but at the same
time I recognize that (at least in our System i world)
traditional I/O can be a perfectly reasonable solution.

Best Regards,

Luis Rodriguez




--- midrange-l-request@xxxxxxxxxxxx wrote:
----------------------------------------------------------------------

message: 1
date: Thu, 16 Aug 2007 13:50:58 -0400
from: "Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>
subject: RE: SQL INSERT with unequal fields

Tee Hee.

I did a hybrid.

To get the records from the file with the matching
format, I used an
embedded SQL Select.

To get the records from the file with the different
format, I used
traditional I/O. In the same program. And the only
field names I had to
'mention' by name in the program were the 2 that I had to
assign a default
value.

Works like a charm.

--
Jeff Crosby
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions