Description

When importing the DCSAMPLES.DMP from the …/direct2023/examples folder, there are a number of index creation errors at the end.

Solution

The data is imported correctly but the indexes are not imported as these still points to the Direct 2022 schema. The following SQL statements will correct this.

Run the following SQL statements in the schema to which the DCSAMPLES.DMP file was imported (e.g. DCSAMPLES) so that the structures are defined with Direct 2023 chemistry:

UPDATE SAMPLE2D SET CTAB = MOL(MOLFILE(CTAB));

UPDATE SAMPLEBIO SET CTAB = MOL(MOLFILE(CTAB));

UPDATE SAMPLEGEN SET CTAB = MOL(MOLFILE(CTAB));

UPDATE SAMPLEMOL SET CTAB = MOL(MOLFILE(CTAB));

UPDATE SAMPLERX_MOLTABLE SET CTAB = MOL(MOLFILE(CTAB));

UPDATE SAMPLERX_REACTION SET RCTAB = RXN(RXNFILE(RCTAB));

COMMIT;

Run the following SQL statements in the schema to which the DCSAMPLES.DMP file was imported (e.g. DCSAMPLES) to create the correct Direct 2023 domain indexes:

CREATE INDEX SAMPLE2D_IX ON SAMPLE2D(CTAB) INDEXTYPE IS C\\\$DIRECT2023.MXIXMDL PARAMETERS ('MOLECULES PREALLOCATE=NOSTORAGECHECK');

CREATE INDEX SAMPLEBIO_IX ON SAMPLEBIO(CTAB) INDEXTYPE IS C\\\$DIRECT2023.MXIXMDL PARAMETERS ('MOLECULES SEQUENCE_EXPAND_LIMIT=35000amu PREALLOCATE=NOSTORAGECHECK');

CREATE INDEX SAMPLEGEN_IX ON SAMPLEGEN(CTAB) INDEXTYPE IS C\\\$DIRECT2023.MXIXMDL PARAMETERS ('GENERICS PREALLOCATE=NOSTORAGECHECK');

CREATE INDEX SAMPLEMOL_IX ON SAMPLEMOL(CTAB) INDEXTYPE IS C\\\$DIRECT2023.MXIXMDL PARAMETERS ('GENERICS PREALLOCATE=NOSTORAGECHECK');

CREATE INDEX SAMPLERX_MOLTABLE_IX ON SAMPLERX_MOLTABLE(CTAB) INDEXTYPE IS C\\\$DIRECT2023.MXIXMDL PARAMETERS ('MOLECULES PREALLOCATE=NOSTORAGECHECK');
​​​​​​​
CREATE INDEX SAMPLERX_REACTION_IX ON SAMPLERX_REACTION(RCTAB) INDEXTYPE IS C\\\$DIRECT2023.RXIXMDL PARAMETERS ('REACTIONS PREALLOCATE=NOSTORAGECHECK');