Hi,

The target table has one extra column. how can I skip that column while loading?

Hi

are you loading using the load utility?
if so, I can only think of:
1) try no to specify the column name in the into clause, maybe db2 will pick the default or null for that column
2) if 1 does not work, try loading a constant value into that column (or null)

one of them should work

pgkrish, Assuming your data is in standard DSNTIAUL format, you need to add Load cards to let DB2 know what columns in the table to add what data from the file. (This is similar in concept to an Insert with fewer values than columns needing a column list).

The easiest way to generate the Load cards is to unload the table. The table can be empty or you can use FETCH FIRST 1 ROW ONLY as you don't care about the data. All Utilities and programs that unload data can generate the Load cards.

Once you have this file, you will need to edit it and remove the column that does not have data in the file (and this column has to be either Nullable or have a Default value).

You only need the list of columns and their position in the file. You would copy this file after the "INTO table-name" parameter of the Load.

If your data is NOT in DSNTIAUL format (but is fixed length), you may need other modifications to the Load card file. You might need to change the POSITION start / end values to match the location in the data file. If you have numbers that are 'readable' (ex. 123.92) instead of binary or packed decimal, you will need to add the EXTERNAL keyword for these columns.

You could create a dummy table that does not have the column, load it, then INSERT from SELECT to the target table.

Todd