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

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
    59 Posts
    ACCEPTED ANSWER

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

    ‏2012-05-31T16:17:41Z  in response to DRCruikshank
    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
      ACCEPTED ANSWER

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

      ‏2012-06-01T21:18:04Z  in response to null
      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;