How to add a modified XFD that already exists in system catalog



If an XFD file has been updated and it has already been loaded into the system catalog (syscat), is it necessary to delete the syscat and recreate it from scratch?


Although, the syscat can be deleted and recreated from scratch, this is not always convenient to do so. Since each XFD is represented as a table in the syscat, a "drop table" command can be issued to drop the corresponding table using the script or directly through the xdbcquery utility. Once the drop has been completed, use the script or use the xdbcutil utility to add the modified XFD to the existing syscat.

Old KB# 3155
Comment List