Difference between revisions of "Reading Spectrum Data Change Records"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
(Installing the detaching sl/so file)
>Johno
(Installing the Data Change Files)
Line 9: Line 9:
 
or
 
or
 
:gunzip datachange_it64.gz
 
:gunzip datachange_it64.gz
The library file (datachng.sl or datachng.so) must remain in the /ASKPLUS directory.  The extract job (ask_datachange_job) may be moved to any location and may be renamed.
+
The library file (datachng.sl or datachng.so) must remain in the /ASKPLUS directory.  The extract job (ask_datachange_job) should be moved to a location with access to the Spectrum databases and may be renamed.  The contents of the job may also be copied into UC4 script.
  
 
===Editing the Job Parameters===
 
===Editing the Job Parameters===

Revision as of 17:35, 17 January 2014

Reading Spectrum Data Change Records

Overview

The SH-HISTORY and LN-HISTORY datasets (HISTRY database) contain data change records that are stored in a binary format. AskPlus provides two special functions designed to read and interpret these records. To use these functions the datachng.sl (or .so Itanium) must be installed in the /ASKPLUS directory. An AskPlus job is also available that extracts specific data change records based on their TYPE and ENTRY-DATE.

Installing the Data Change Files

The data change library file and the extract job are provided in a single gz download. Choose the pa32 file for PARISC and the it64 file for Itanium. Transfer the gz file to the /ASKPLUS directory on UNIX and execute the command.

gunzip datachange_pa32.gz

or

gunzip datachange_it64.gz

The library file (datachng.sl or datachng.so) must remain in the /ASKPLUS directory. The extract job (ask_datachange_job) should be moved to a location with access to the Spectrum databases and may be renamed. The contents of the job may also be copied into UC4 script.

Editing the Job Parameters

The listener job can be shutdown using the host command KILLVSRV. The syntax is:

KILLVSRV.PUBTCP.ASKPLUS -password

The password must match the password in the VSRVINI file for the VSRVMGR Manager.