With DB2 z os v8, is it possible to load a table using an input file for all columns but one and actually specify a value for that one column in the load cards with the sysin?
like
LOAD DATA INTO TABLE ABC
(COLA POSITION(1) INTEGER,
COLB POSITION(5) CHAR(1),
COLC CHAR(3) 'DEF')
Where columns a and b get values from input file but all occurances oc column c would have DEF as value.
like
LOAD DATA INTO TABLE ABC
(COLA POSITION(1) INTEGER,
COLB POSITION(5) CHAR(1),
COLC CHAR(3) 'DEF')
Where columns a and b get values from input file but all occurances oc column c would have DEF as value.