Unanswered: how to execute sql script (ddl, dml) in db2?
i have ddl and dml sql scripts... how do i execute it in db2 command line or control center or command center.
the sql commands (dropt/ create table) contains semi-colons and "create table" commands is multi-line.
hi i got it but it wont execute the sql commands...
DROP SEQUENCE alert_id_seq restrict
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0900N The application state is in error. A database connection does not