Reading Spectrum Data Change Records

From Vital Soft Wiki
Revision as of 17:38, 17 January 2014 by >Johno (Editing the Job Parameters)
Jump to: navigation, search

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.

      • Start of Prompts Section ***
  • START-DATE is the range start-date (YYYYMMDD format)
  • END-DATE is the range end-date (YYYYMMDD format)
  • The range maximum is 100 days from the start-date, regardless of end-date.

newreg #START-DATE:I2 = 20140101 newreg #END-DATE:I2 = 20140131

  • INCLUDE-SH-HIST is the flag to include SH-HISTORY ("Y" or "N")
  • INCLUDE-LN-HIST is the flag to include LN-HISTORY ("Y" or "N")

newreg #INCLUDE-SH-HIST:X1 = "Y" newreg #INCLUDE-LN-HIST:X1 = "Y"

  • VALID-TYPES is the list of the datachange HISTORY.TYPE values to look for.

newreg VALID-TYPES:x300 load VALID-TYPES =

 "200,201,202,203,204,205,206,210," cat
 "300,303,304,305,306,307,308,309,313,314,315,396,399," cat
 "400,401,403,405,410,430,440,497," cat
 "500,506,510,550,551,552,560,570," cat
 "600,700,800,850,900,910,920,921,930,940,950,960,970"
  • OUTPUT-FILE is the fully qualified file name of the final Self Describing file .

newreg #OUTPUT-FILE:X100 = “ASKPLUS/visimage/DC-FILE”;


      • End of Prompts section ***