Problem Note 37090: PROC METALIB allows you to create duplicate tables with the same name in the same SAS® Metadata Server folder
Beginning with SAS® 9.2, you may no longer store multiple objects with the same name in the same SAS® Metadata Server folder. For example, if you use the Register Tables wizard in
SAS® Management Console and try to register a table in a folder that already contains a table with that same name, you will receive the following error:
ERROR: A table of name SALES is already registered in the specified folder and cannot be added
again. The table will be skipped.
However, if you run PROC METALIB to update table metadata and try to add a table to a folder
that already contains a table with the same name from a different library, PROC METALIB adds the table anyway. This results in multiple tables with the same name in the folder. This duplication can potentially cause confusion and unexpected behavior when the folder is accessed by other SAS® client applications.
To circumvent the problem, always be sure to use the FOLDER statement in PROC METALIB to add new tables to a folder that does not already contain tables with the same names.
Operating System and Release Information
SAS System | SAS Metadata Server | z/OS | 9.2 TS2M2 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M2 | |
Microsoft Windows XP 64-bit Edition | 9.2 TS2M2 | |
Microsoft® Windows® for x64 | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M2 | |
Microsoft Windows Server 2008 | 9.2 TS2M2 | |
Microsoft Windows XP Professional | 9.2 TS2M2 | |
Windows Vista | 9.2 TS2M2 | |
64-bit Enabled AIX | 9.2 TS2M2 | |
64-bit Enabled HP-UX | 9.2 TS2M2 | |
64-bit Enabled Solaris | 9.2 TS2M2 | |
HP-UX IPF | 9.2 TS2M2 | |
Linux | 9.2 TS2M2 | |
Linux for x64 | 9.2 TS2M2 | |
Solaris for x64 | 9.2 TS2M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
SAS
® 9.2 no longer allows multiple objects with the same name to exist in the same metadata folder. PROC METALIB does not enforce this restriction as it should.
Type: | Problem Note |
Priority: | medium |
Topic: | Data Management ==> Data Sources ==> Metadata
|
Date Modified: | 2009-09-04 14:38:45 |
Date Created: | 2009-09-03 15:41:54 |