Metadata Export Reference |
Exporting Host Definitions and Other Shared Metadata describes how to
export the metadata defined for SAS libraries, hosts, DBMS
connections, and contacts. This section describes the format of the exported
data sets.
GENERAL:
# Variable Type Len Pos Label
---------------------------------------------------------------------
1 INFOTYPE Char 8 0 Information Type
2 OBJNAME Char 40 8 Name
3 OBJTYPE Char 40 48 Type
4 OBJ_ID Char 17 88 ID
5 VERSION Char 8 105 Version of Metadata
6 DESC Char 200 113 Description
7 PARENTNM Char 40 313 Owning Parent Name
8 PARENTTP Char 40 353 Owning Parent Type
9 PARENTID Char 17 393 Owning Parent Metadata ID
10 PARENTLB Char 8 410 Owning Parent Metadata Libref
11 MDLIBREF Char 8 418 Metadata Libref
12 MDCREATE Char 20 426 Metadata Created
13 MDMODIFY Char 20 446 Metadata Modified
14 DTCREATE Char 20 466 Data Created
15 DTMODIFY Char 20 486 Data Modified
16 NOTES Char 3 534 Notes Available
17 NOTESLOC Char 40 537 Notes Location
LIBRARY:
# Variable Type Len Pos Label
-----------------------------------------------------------
1 INFOTYPE Char 8 0 Information Type
2 OBJNAME Char 40 8 Name
3 OBJTYPE Char 40 48 Type
4 OBJ_ID Char 8 88 ID
5 VERSION Char 8 96 Version of Metadata
6 LOCNAME Char 40 104 Library Name
7 LOCDESC Char 200 144 Library Description
8 ASSGNBY Char 30 344 Assigned by
9 LIBREF Char 8 374 Libref
10 ENGINE Char 8 382 Engine
11 PATH Char 40 390 Physical Path
12 LIBOPTS Char 200 430 Options
HOST:
# Variable Type Len Pos Label
-----------------------------------------------------------
1 INFOTYPE Char 8 0 Information Type
2 OBJNAME Char 40 8 Name
3 OBJTYPE Char 40 48 Type
4 OBJ_ID Char 8 88 ID
5 VERSION Char 8 96 Version of Metadata
6 HOST Char 40 104 Host Name
7 LOCALE Char 10 144 Locale
8 REMOTE Char 200 154 Remote Address
9 SCRIPT Char 200 354 Remote Script
10 COMAMID Char 8 554 Access Method
DBMSCONN:
# Variable Type Len Pos Label
-----------------------------------------------------------
1 INFOTYPE Char 8 0 Information Type
2 OBJNAME Char 40 8 Name
3 OBJTYPE Char 40 48 Type
4 OBJ_ID Char 8 88 ID
5 NICKNAME Char 8 96 DBMS Nickname
6 SCHEMA Char 32 104 User/Schema
7 PROTECT Char 3 136 Password Protected
8 LASTMOD Char 20 139 Password Last Modified
9 DBMSOPTS Char 200 159 Connection Options
CONTACT:
# Variable Type Len Pos Label
------------------------------------------------------------
1 INFOTYPE Char 8 0 Information Type
2 OBJNAME Char 40 8 Name
3 OBJTYPE Char 40 48 Type
4 OBJ_ID Char 8 88 ID
5 VERSION Char 8 96 Version of Metadata
6 PERSNAME Char 200 104 Person Name
7 TITLE1 Char 200 304 Title (Primary)
8 TITLE2 Char 200 504 Title (Secondary)
9 PHONE1 Char 20 704 Phone (Primary)
10 PHONE2 Char 20 724 Phone (Secondary)
11 EMAIL Char 40 744 Email Address
12 ADDR1 Char 200 784 Address (line 1)
13 ADDR2 Char 200 984 Address (line 2)
14 ADDR3 Char 200 1184 Address (line 3)
15 ADDR4 Char 200 1384 Address (line 4)
EXTATTRS:
# Variable Type Len Pos Label
------------------------------------------------------------
7 DESC Char 200 313 Extension Description
1 INFOTYPE Char 8 0 Information Type
2 OBJNAME Char 40 8 Name
3 OBJTYPE Char 40 48 Type
4 OBJ_ID Char 17 88 Metadata ID
6 VALUE Char 200 113 Extension Value
5 VERSION Char 8 105 Version of Metadata
![](../../../../common/65445/HTML/default/images/spacer.gif) |
![](../../../../common/65445/HTML/default/images/spacer.gif) |
Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.