Previous Topic: Web OptionNext Topic: Web Option

Known Issues

Known Issues

This section of the Release Notes contains known issues for r8.7.

CA 2E

Issue with the Select Record Function Compilation

The Select Record function does not get compiled when virtual fields are used for the generation method of *SQL or *DDL, and for the data access method of *TABLE.

Compilation of CBI Functions Fail

The DSPFIL, SELRCD, and EDTFIL CBI functions fail to compile when a Select/Omit criteria is specified.

Issue with the Copy Process for SQL Tables

The copying process for SQL Tables fails. When you setup YCPYLIB and YOLDLIB processing and regenerate/recompile the access paths (*SQL or *DDL), the data does not get copied over.

Trigger Loss When Moving to DDL/SQL

  1. Triggers are only supported when the physical files on which trigger is implemented, are present in the generation library, denoted by model value (YGENLIB).
  2. When we convert the database from DDS to DDL or SQL, the access path objects get recreated in SQL collection library, denoted by the model value YSQLLIB. However, because of a limitation in trigger processing algorithm, the trigger functionality can only be implemented on access paths present in generation library, denoted by the model value YGENLIB. Therefore, trigger implementation fails when you convert the database from DDS to DDL or SQL and the SQL collection library is different from the Generation Library.

The following lists the steps that you must perform for the trigger functionality to work after converting the database from DDS to DDL/SQL:

  1. Ensure that the SQL collection library is same as the Generation library, (that is, both model values YSQLLIB and YGENLIB hold the same value) before regenerating your access paths as DDL or SQL. This ensures that the DDL/SQL type access paths objects are recreated in the same library where the original DDS-based access paths existed.
  2. After converting the database to DDL or SQL, delete the trigger reference by using YWRKTRGREF command and choosing option 4=Delete against the access path that is being converted from DDS to DDL/SQL.
  3. Rerun the YCVTTRGDTA command.