Usage Note 43378: META Libname Engine does not support SAS® Catalog access
The SAS Metadata Libname Engine is a thin layer engine which receives commands and passes them to the underlying data access engine for performing the tasks. The META engine is capable of interfacing with tables and views from SAS and third–party DBMSs (database management systems). The META engine supports only tables and views. It does not support other SAS® files such as catalogs.
This limitation is often seen when working with SAS Formats because formats are stored as entries in SAS Catalogs. You cannot create a format in a library that is assigned with the META engine. You cannot use a format that is stored in a library that is assigned with the META engine. Common error messages are:
ERROR: LIBREF.CATALOG_NAME.CATALOG cannot be opened because files of type CATALOG are not supported in the FMTLIB library.
ERROR: The format FORMAT_NAME was not found or could not be loaded.
When creating formats for later use, plan for how clients and client applications will access the formats. Include a strategy for assigning the library using the native engine (BASE, V9) rather than the META engine, such as:
- assign the library within an autoexec file, specifying the native engine on the LIBNAME statement
- assign the library in client start–up code, specifying the native engine on the LIBNAME statement
- define the library in the SAS® Metadata Repository and mark it as pre–assigned
- use client options to assign the library using the native engine
Including a Libref in the FMTSEARCH SAS System Option is not a circumvention to this limitation. The library in which the format is saved to or read from must be assigned using the native engine.
For more information on the Metadata LIBNAME Engine, please see
SAS® 9.1.3
Metadata LIBNAME Engine
User's Guide
Second Edition
or
SAS® 9.2
Language Interfaces
to Metadata.
Operating System and Release Information
SAS System | SAS Metadata Server | z/OS | 9.1 TS1M0 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
Microsoft Windows NT Workstation | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | |
Microsoft Windows XP Professional | 9.1 TS1M0 | |
64-bit Enabled AIX | 9.1 TS1M0 | |
64-bit Enabled Solaris | 9.1 TS1M0 | |
HP-UX IPF | 9.1 TS1M0 | |
SAS System | Base SAS | z/OS | 9.1 TS1M0 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
Microsoft Windows NT Workstation | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | |
Microsoft Windows XP Professional | 9.1 TS1M0 | |
64-bit Enabled AIX | 9.1 TS1M0 | |
64-bit Enabled HP-UX | 9.1 TS1M0 | |
64-bit Enabled Solaris | 9.1 TS1M0 | |
HP-UX IPF | 9.1 TS1M0 | |
Linux | 9.1 TS1M0 | |
OpenVMS Alpha | 9.1 TS1M0 | |
Tru64 UNIX | 9.1 TS1M0 | |
*
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.
Date Modified: | 2011-07-11 11:05:18 |
Date Created: | 2011-05-31 11:09:43 |