Help with Export/Import statement

[glenpark]

I did a little searching but didn't find exactly what I was looking for.

Would there be a problem with doing an EXPORT of data from a table into a flat file, adding a column to the table, then executing an IMPORT into that table? Assuming that new column is non-nullible and carries a default value setting, how would the import statement look?

EXPORT TO myfile.ixf OF ixf SELECT * FROM MYTABLE;
IMPORT FROM myfile.ixf OF ixf INSERT INTO MYTABLE (col1, col2, col3) VALUES ?

Any help is appreciated.

Thanks,
Glen

 

[LKBrwnDBA]

You could EXPORT the null column:

EXPORT TO myfile.ixf
       OF ixf SELECT MYTABLE.*, NULL as NewCOL
                FROM MYTABLE

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb