Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL WITH DEFAULT
The columns in a file are as below.where eve
COLUMNS DATATYPE NULL
COL1 CHAR(5) YES
COL2 CHAR(5) NO
.. CHAR(5)
. . CHAR(5)
COL N CHAR(5) YES
Any suggessions how to implement above mentioend syntax using the columns information from the file?
Regards