Reading Spectrum Data Change Records - Revision history

>Johno: /* Editing the Job Parameters */

2017-01-12T18:44:55Z

‎Editing the Job Parameters

2017-01-12T18:42:06Z

‎Editing the Job Parameters

2017-01-12T18:31:37Z

‎Overview

2017-01-12T18:30:59Z

‎Overview

2014-01-28T19:00:51Z

‎Installing the Data Change Files

2014-01-17T19:33:12Z

‎Installing the Data Change Files

2014-01-17T19:32:30Z

‎Installing the Data Change Files

2014-01-17T19:15:25Z

‎Installing the Data Change Files

2014-01-17T19:06:30Z

‎Editing the Job Parameters

2014-01-17T18:24:56Z

‎Sample AskPlus Query

@@ Line 22: / Line 22: @@
   *** Start of Prompts Section ***
-−
-# StartDate is the range start-date (YYYYMMDD format)
+ # StartDate is the range start-date (YYYYMMDD format)
-# EndDate is the range end-date (YYYYMMDD format)
+ # EndDate is the range end-date (YYYYMMDD format)
-# OutputFile is the fully qualified file name of the final SD file.
+ # OutputFile is the fully qualified file name of the final SD file.
-# IncludeShareHist is the flag to include SH-HISTORY ("Y" or "N")
+ # IncludeShareHist is the flag to include SH-HISTORY ("Y" or "N")
-# IncludeLoanHist is the flag to include LN-HISTORY ("Y" or "N")
+ # IncludeLoanHist is the flag to include LN-HISTORY ("Y" or "N")
-−
-export StartDate=20160101
+ export StartDate=20160101
-export EndDate=20160131
+ export EndDate=20160131
-export OutputFile=$SPXHOME/FI/DATA/DC-FILE
+ export OutputFile=$SPXHOME/FI/DATA/DC-FILE
-export IncludeShareHist=Y
+ export IncludeShareHist=Y
-export IncludeLoanHist=Y
+ export IncludeLoanHist=Y
   *** End of Prompts section ***

@@ Line 19: / Line 19: @@
 ===Editing the Job Parameters===
-The job contains a prompts section to customize the extract.  You may specify a date range, specific record types and the name of the final SD file that is created.  You can also specify whether or not to include share history and/or loan history.
+The job contains a prompts section to customize the extract.  You may specify a date range and the name of the final SD file that is created.  You can also specify whether or not to include share history and/or loan history.
   *** Start of Prompts Section ***
+# StartDate is the range start-date (YYYYMMDD format)
- * INCLUDE-SH-HIST is the flag to include SH-HISTORY ("Y" or "N")
+# EndDate is the range end-date (YYYYMMDD format)
- * INCLUDE-LN-HIST is the flag to include LN-HISTORY ("Y" or "N")
+# OutputFile is the fully qualified file name of the final SD file.
+# IncludeShareHist is the flag to include SH-HISTORY ("Y" or "N")
-By default, the extract will include both SH-HISTORY and LN-HISTORY.
+# IncludeLoanHist is the flag to include LN-HISTORY ("Y" or "N")
+export StartDate=20160101
- * VALID-TYPES is the list of the datachange HISTORY.TYPE values to look for.
+export EndDate=20160131
+export OutputFile=$SPXHOME/FI/DATA/DC-FILE
-Enter all valid types in a list.  Each line (except the last) must be terminated by a cat
+export IncludeShareHist=Y
- newreg #VALID-TYPES:x300
+export IncludeLoanHist=Y
   *** End of Prompts section ***

@@ Line 1: / Line 1: @@
 == 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/SUPRTOOL job is also available that extracts specific data change records based on their ENTRY-DATE and creates an SD file that can be used for reporting with AskPlus or Visimage3..
+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/SUPRTOOL job is available that extracts specific data change records based on their ENTRY-DATE and creates an SD file that can be used for reporting with AskPlus or Visimage3.
 ===Installing the Data Change Files===

@@ Line 1: / Line 1: @@
 == 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.
+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/SUPRTOOL job is also available that extracts specific data change records based on their ENTRY-DATE and creates an SD file that can be used for reporting with AskPlus or Visimage3..
 ===Installing the Data Change Files===

@@ Line 5: / Line 5: @@
 ===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 following commands to unzip the gzip file and extract the files from the tar file.
+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 following commands to unzip the gzip file and extract the files from the tar file.  You should be logged on as the ask plus user while installing these files.
 :gunzip datachange_pa32.tar.gz

@@ Line 15: / Line 15: @@
 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 a script.
-Download files [http://www.vital-soft.com/product-downloads/ here].
+Download data change files [http://www.vital-soft.com/product-downloads/ here].
 ===Editing the Job Parameters===

@@ Line 16: / Line 16: @@
   *** Start of Prompts Section ***
+  *
   * START-DATE is the range start-date (YYYYMMDD format)

@@ Line 83: / Line 83: @@
   open /ASKPLUS/visimage/DC-FILE;
   find primary=DC-FILE; outsel=(@)
-  DC-TYPE="Change" and DC-ITEM-NAME = "APR"
+  DC-TYPE = "Change" and DC-ITEM-NAME = "APR"