Generated a DDL script from a DB2 tool called DB2Look. It generates a DDL script that looks like the following:
Test1.SEQ_ADDRESS_BOOK AS INTEGER
MINVALUE 1 MAXVALUE 2147483647
START WITH 1000 INCREMENT BY 1
NO CACHE NO CYCLE NO ORDER@
ALTER SEQUENCE Test1.SEQ_ADDRESS_BOOK RESTART WITH 180375@
CREATE SEQUENCE BKFAIR01.SEQ_ASSET_ID AS INTEGER
MINVALUE 100 MAXVALUE 2147483647
START WITH 100 INCREMENT BY 1
NO CACHE NO CYCLE NO ORDER@
Will produce the following error:
DDL - NO CACHE NO CYCLE NO ORDER@
ERROR - Found 'ORDER@', Expecting: CACHE CYCLE MAXVALUE MINVALUE ORDER
WORKAROUND:
Have the DB2Look tool generate the script with a default parser sign of a semi-colon (";").
STATUS:
Waiting for fix in a future release of Toad Data Modeler.
