PROC METALIB can currently access only a single library at one time. Therefore, it is not possible to register metadata for a table that contains a foreign key constraint which references a table in a different library.

If you attempt to register a table that does contain a foreign key like this, you will receive the following error:

   ERROR:  File LIBREF.TABLENAME does not exist.

Currently, the only way to circumvent this problem is to include all tables involved in the foreign key constraint in a single library. Note that if you do this, you must still include all the tables on the SELECT statement in PROC METALIB. If you do not include all the tables, you will receive this warning and the foreign keys will not be registered in the metadata:

   WARNING: Processing primary key table object_id.  Foreign key table
            object_id2 was not selected, so no foreign key changes will
            be applied for it.

Operating System and Release Information