User`s guide

9030971 E17 Data Structure of SQL Tables
C-15
Imported Data Information
Imported Data Information
Description: Table containing export criteria for tables in the database
Variables: vnm The SpectroSERVER name, a 32-byte
string
lh The landscape handle, a 4-byte integer
table_name The table name, an 18-byte string
export_type The SPECTRUM data type, a 16-byte
string
export_ts The date field
range_start The starting date (Statistics and Events
only), a date field, nulls allowed
range_end The end date (Statistics and Events only),
a date field, nulls allowed
Table C-13. Format for Imported Data Information
SpectroSERVE
R
(vnm)
Landscape
Handle
(lh)
Table Name
(table_name)
Export Type
(export _type)
my_vnm 4194304 stats statistics
SPECTRUM 4456448 events_spectrum events
32-byte string 4-byte integer 18-byte string 16-byte string
Export Date/Time
(export_ts)
Export Range Start
(range_start)
Export Range End
(range_end)
15-April-1998
15:10:05
10-April-1998
00:00:00
14-April-1998
22:00:00
15-April-1998
15:10:05
10-April-1998
00:00:00
14-April-1998
22:00:00
date date date
NOTE
When an export is executed exporting data from multiple landscapes, a
separate Impoinfo entry will be written for each landscape.