Created On:  21 February 2011

Problem:

The problem happens when you try to execute  the CREATE SEQUENCE  statement  using DDL Processor UI menu in HCO.  The sequence is created but HCO returns a message: "804-S Syntax error - Invalid token: SEQUENCE found processing statement". The highest return code is 8.

Resolution:

To avoid the problem turn off the "Modify DDL" option under "Options"  in DDL Processor UI menu to N   "Modify DDL= N".  Execute the statement again. The HCO returns  the message <*** PREVIOUS INPUT DDL STATEMENT EXECUTED AS PROVIDED> and the highest return code is 0.