User`s guide

Hard Disk and System Recommendations
13-8
6700-A2-GY31-70
July 1999
Database Export
The Export database function allows you to extract information from all or
individual tables. To choose this function, click on the Export icon recorded within
the 6700 NMS group. The EXPORT.REQ file residing in the BACKUP directory
assigned to the COMSPHERE 6700 root directory is used. All export data files
created will be assigned to this BACKUP directory.
All tables will be exported if the AllTables label is set to Yes. If the AllTables label
indicates No, then only those tables indicating Yes will be exported.
Before the database information is exported to the data files, the Format and
Separator labels are processed. The Format label determines how the data will
be formatted and which data files will be used.
If Format label indicates. . .
The data is . . .
Binary (default) Stored in the database to the appropriate file using
the extension DAT (e.g., DEVICE.DAT).
ASCII Converted to ASCII and written to the appropriate
file with the extension FIL.
The name of each column and its characteristics will be written to the appropriate
file with the INF extension. Character data is enclosed in double quotes (”),
commas are inserted between values in different columns, and spaces between
values are stripped out. Each written record is terminated with a carriage return
(x’0d’) and a line feed (x’0a’). The Separator label separates individual fields.
Example: 4,”Largo1,”,””,2,0,0,””,0,””,””,””,””,150,100,201,”1
/6”,0,0, 1,2,3,15,1,0,0,”A0
The table information file consists of the column name, column type, and column
length. All columns defined as either Smallint or Integer will be converted to
signed ASCII digits.
Example: Column Name Type Len
dv_device_id Smallint 0002
dv_name Char 0015