AcuXDBC error adding XFD "Error: Empty condition tablename, condition 1"
Using version 9.0.0 or newer, when attempting to add an XFD to the AcuXDBC system catalog an error is reported "Error: Empty condition tablename, condition 1". Previous versions of AcuXDBC added this XFD without error.
The XFD involved was generated from old code and used the XFD WHEN directive to distinguish multiple record types in the FD.
For the first record type it specifies:
$XFD WHEN RECORD-TYPE=5 TABLENAME=USERFILE
The FD also included this directive:
$XFD WHEN RECORD-TYPE=OTHER
The requirement is that if the TABLENAME clause is used it must be defined for all of the WHEN conditions. So the 'OTHER' condition is missing the TABLENAME clause. Previous versions were not strict about this and reported no error.
To resolve add a table name:
$XFD WHEN RECORD-TYPE=OTHER TABLENAME=OTHERTABLE
Then generate a new XFD add that to the system catalog.