Topic
  • 2 replies
  • Latest Post - ‏2012-06-01T21:18:04Z by DRCruikshank
DRCruikshank
DRCruikshank
6 Posts

Pinned topic Error when Reverse Engineering from DDL Script in IDA Version 8.1.0.0

‏2012-05-31T13:37:33Z |
I receive the following message when reverse engineering a DDL script containing an IDENTITY column: "GenDDL_From_Parent_Child_PDM.sql", line 8: Syntax error: Encountered "INCREMENT" at column 25.

This occurs for DDL scripts generated via IDA (above error) or IBM i Navigator Generate SQL as shown by the following error: "GenDDL_From_iNav_Generate_SQL.sql", line 8: Syntax error: Encountered "INCREMENT" at column 22.

IBM i system release is 6.1
Updated on 2012-06-01T21:18:04Z at 2012-06-01T21:18:04Z by DRCruikshank
  • null
    null
    60 Posts

    Re: Error when Reverse Engineering from DDL Script in IDA Version 8.1.0.0

    ‏2012-05-31T16:17:41Z  
    Thanks for reporting the issue. We don't fully support RE from ddl on iSeries syntax yet.
    The request will be in our future plan.

    Regards,
    -April
  • DRCruikshank
    DRCruikshank
    6 Posts

    Re: Error when Reverse Engineering from DDL Script in IDA Version 8.1.0.0

    ‏2012-06-01T21:18:04Z  
    • null
    • ‏2012-05-31T16:17:41Z
    Thanks for reporting the issue. We don't fully support RE from ddl on iSeries syntax yet.
    The request will be in our future plan.

    Regards,
    -April
    Thank you for the reply. Just so I understand, since the syntax for IDENTITY support is identical for both DB2 for i and DB2 for LUW, what exactly is the issue? The generated DB2 for LUW code does not result in an error when using RE. Since these are both DB2 shouldn't they be treated equally? It seems to me that the error is a bug since the syntax is correct.

    Here is the IDA generated DB2 for i table with IDENTITY column:

    CREATE TABLE Table1 (
    ID BIGINT GENERATED BY DEFAULT AS IDENTITY (
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    MAXVALUE 9223372036854775807
    NO CYCLE
    CACHE 20
    NO ORDER )
    );

    And here is the IDA generated DB2 for LUW table with IDENTITY column:

    CREATE TABLE TABLE1 (
    ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    MAXVALUE 9223372036854775807
    NO CYCLE
    CACHE 20
    NO ORDER )
    )
    DATA CAPTURE NONE
    COMPRESS NO;