hogger_out
Purpose:
-
Convert the SQLite3 database created by the hogger application into a readable format.
This function is available with CyFlex 7.1 and subsequent releases.
Enter:
-
hogger_out <-s spec_file> | <-i database_file> <-L> options
Where:
-
-s spec_file
Specify a spec file to read. Required if the spec file includes a database file.
If the spec file does not include a database file, use the -i option.-i database_file
Specify a database file if not in the spec file. Required if a spec file is not specified.
-L
Specify the CSAR label type. Valid options are:
- csar to use a variable CSAR label without an ECM prefix
- prefix to use a variable CSAR label with an ECM prefix
- external or ext to use the external CSAR name
Options
-o output_file
If not in the spec file, specify an output file to write into. Specify either a fully qualified path or a relative path.
-d delimiter
Specify a custom delimiter to use. This will override the spec file. Use non-white space characters only.
-e
Specify this flag to add an index and exit. This greatly speeds up data retrieval from the database.
-g
Specify this flag to perform debug+query. No output will be produced.
-n
Specify this flag to prevent conversion of units to log units. By default, if the units get converted to log_units which are selected in the hogger application. The variables are stored in the units that they are in when logged, but if hogger also stored log_units than a conversion takes place. This option disables that conversion, and the original units are used in the report.
-q
Specify this flag to query the database and exit. No output will be produced.
-A
Specify this flag to prevent writing of headers when appending to the file.
-D
Specify this flag to display debug information.
-E
Specify this flag to remove the index and exit.
-H
Specify this flag to disable writing of headers.
-I
Specify this flag to add an index to the database. The application will run to completion.
This improves performance on large data sets.-R
Specify this flag to remove indexes and reclaim disk space when the application is done with the database.
Example:
-
hogger_out -s /specs/hogr_out_spec.1 csar
The preceding uses specification file /hogr_out_spec.1 and a variables CSAR label without an ECM prefix.hogger_out i /data/PC_format/database.db prefix
he preceding uses database file /data/PC_format/database.db and a variables CSAR label with an ECM prefix.