Data Replication 2
Results 1 to 1 of 1

Thread: ERROR: [A00D] Failed to open table

  1. #1
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    Jdbc for Tandem Enscribe - ERROR: [A00D] Failed to open table

    Description
    Problem with ADDIMP on Tandem (HP Non-Stop)

    I am trying to import a record layout from DDL using the addimp utility. The import runs fine but I get an error when trying to access the data. The file has a primary key length of 20 bytes offset of 0 and no alternate keys.

    The record layout begins as follows...
    01 RECORD.
    05 A-CHAR-COL PIC X(04).
    05 B-CHAR-COL PIC X(01) OCCURS 16 TIMES.
    05 ....

    I get an error that there is no field at offset 0 for a length of 20.

    From navlog file...
    Table jeff_rec has no field with length 20 at offset 0
    [A00D] Failed to open table DDLTEST:jeff_rec

    When the record is imported it creates the second column as lenght of 1 with a dimension of 20. As a temporary fix, I changed the size to 16 and the dimension of 0 using Studio and was able to access the table.


    Solution
    The Enscribe driver cannot support having arrays (occurs) in an index.
    Last edited by Admin_attu; 08-31-2006 at 12:43 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •