HP NonStop G-Series - Manual (Page 185)

Measure User’s Guide —520560-003
C- 1
C
Loading Measure Data Into an SQL
Table
To create a structured data file and then load the data from the file into an SQL table:
1. Create a data dictionary using the DDL utility and MEASDDLS file:
> DDL
!?dict subvol !
!?source measddls
!exit
2. Use MEASCOM to create a structured output data file. This example creates a file
that contains data for all PROCESS entities in the measurement MEASFILE:
> MEASCOM
1+ add measfile
2+ set report format structured
3+ list process *, rate off
3. Use the SQL CONVERT command to create a command file (CNVSRC) that
converts the structured file to an SQL table:
> SQLCI
>>convert record process to table $vol2.perf.prodata
+>catalog $vol2.perf, dictionary $system.sys01, file is
process
+>load, source cnvsrc clear;
>>exit
4. Edit the CNVSRC file to remove the reserved word GROUP:
> edit cnvsrc;&
> ca/GROUP /GROUP_/all;&
> exit
5. Execute CNVSRC to create an SQL table and load data from the structured file to
an SQL table:
SQLCI
>>obey cnvsrc
>>exit