Robelle Supports Spectrum Credit Union Users

Configuring Suprtool for Spectrum Converting Jobs to Suprtool Tammy Roscoe: Your Spectrum Rep Our Products Suprtool Exporting to Excel Exporting to XML Jump on Ops Problems Better than Query Many more Suprtool tips Suprtool brochure Nine Suprtool tutorials Suprtool training classes Suprtool training workbooks Suprtool manuals Qedit Qedit manual Qedit Tips Qedit for Windows Qedit for Windows Manuals Test Suprtool Jobs with Qwin Boxes of Text Advanced Selection Methods Many more QWIN tips Qedit for Windows brochure About Robelle About the HP 9000 About the HP 3000

Welcome to Robelle's corner of the Web dedicated to users of SPECTRUM, the industry-leading application solution for credit unions from Fiserv. Suprtool 5.4.10 and Spectrum EOY 2011.2 Unfortunately, an issue has come up with Suprtool 5.4.10 Build 2, that did not come up in testing at either Robelle or Fiserv. As a result we paused handing out codes for any new installs of Suprtool 5.4.10 in order to investigate. This version is necessary for Supporting Spectrum Version 2011.2. The issue has only been on PA_RISC machines and only on some machines, but the issue was more prevalent on Eloquence 8.0 and was related to set fastread on. The issue was a heap space address incorrect allocation or corruption of the address, which manifested itself as and error in fwrite to the Sort Scratch file. What do We do now? Working with Fiserv we have a version that does not encounter the issue on the machines that reported the abort by making some changes to the amount of memory allocated and some other minor changes. These changes are in Suprtool 5.4.12 Build 2 and is currently available from our web site and will still support Spectrum EOY 2011.2 VUP. Even though the issue has not occurred on Itanium our preference is that Itanium users install the new version as well. If you have not installed Suprtool 5.4.10 or DO NOT HAVE CODES from the 5.4.10 install you can request them from here: Request Pre-Release Codes and Go to Download Page If you have codes from the Suprtool 5.4.10 install you can proceed directly to the download page found here: Download Suprtool 5.4.12 Directly (Only if you have codes for 5.4.10 still) I sincerely apologize for this issue and we continue to strive to make all Robelle software as high quality as possible. Suprtool is tested every evening on MPE, HP-UX (PA-RISC and Itanium), Linux x86, in both real and virtual environments against multiple flavours of Eloquence and versions of the operating system. We will continue to do so and continue to strengthen the amount of testing done, unfortunately this issue did not appear in tests as it was very specific. If you have any further questions or need further details I can always be reached at neil@robelle.com or my Office number at 408.200.4487. Sincerely, Neil Armstrong Robelle Questions and Solutions We often get questions from the Fiserv user base and we typically try to write an application note on major issues. We have a FAQ, but we also collect some of these application notes, which I have collected here: How Do I Import a CSV file? How Do I Solve Floating Point Exeption Errors? How Do I Control Where Temp Sort Space is Allocated? How Do I Fix my Zip Codes? Suprtool and UC4 Scripts Suprtool has a number of functions that require a "$" sign in front of them. This causes an issue with UC4 as it tries to resolve any variables. So if a script has a $lookup in it and $lookup is not a variable then the $lookup is removed, for example what would happen is: if $lookup(mytable,key) becomes: if (mytable,key) All that needs to happen is you "Escape Out" the Environment Variable from being resolved by changing the text to be: if \$lookup(mytable,key) When you do this UC4, (and HP-UX for that matter), now knows that the $lookup is not a token that needs to be resolved as an environment variable but the $lookup is a literal. This is one of the most frequently asked questions from our Fiserv customers! Direct Robelle Support As a Fiserv customer who is migrating, you receive copies of all the Robelle products: Qedit, Suprtool and Qedit for Windows. But your technical support is through Fiserv. To benefit fully from the Robelle products, you may want to deal directly with Robelle technical support. We welcome such inquiries and would be glad to answer all your questions. We have experience with many Spectrum sites who have exploited our software's power to get more out of their Spectrum system. For information about direct Robelle support, contact Tammy at at Robelle: New for Fiserv Our interaction with Fiserv customers over time have directly inspired enhancements to our products: When Neil Armstrong, the Suprtool Software Architect, travelled to Fiserv to do staff training, he came back with many excellent suggestions, which he quickly added to Suprtool: $split was added for Fiserv and came directly from their format for storing names, e.g. Smith / Bill. $subtotal to keep running totals on any numeric field and reset on sort breaks. $edit for COBOL type reformatting. Recently, we received a number of questions related to column operations in Qedit. Some Fiserv sites used Quad (a contributed library editor) on the HP 3000 and were transitioning to an HP 9000. They found themselves without their favorite editor, as Quad is not available on HP-UX. They turned to Qedit, but quickly discovered that Qedit missed some Quad features. We quickly added the most urgent of these: Colcopy and Colmove: More specifically, they were looking for an easy way to copy or move columns on a single line, so we just implemented the commands form Quad! The Merge-justified (MergeJ) command merges the content of a file with the current workfile horizontally, based on the line numbers by appending text of the external file to the corresponding line in the workfile. Configuring Suprtool for Spectrum Suprtool operates on the databases that contain your Spectrum application data. This allows it to know the names of your datasets and fields, the field data types and size. But it does not allow Suprtool to know everything that would be useful. For example, the database contains birth-date, name-chg-date, last-stmt-date, etc., but Suprtool doesn't know that these are dates, nor how the date is formatted. When Suprtool has that information, it can do things like this: >if birth-date >= $date(1980/06/20) You tell Suprtool that a field contains a date of a certain format using the Item command. >item BIRTH-DATE ,date, yyyymmdd >item LAST-CHG-DATE ,date, yyyymmdd As on can see, it is easy to configure Suprtool to operate intelligently with your Spectrum data.

Convert Spectrum Jobs to Use Suprtool

Here is the original Query section of the job:

!RUN QUERY.PUB.SYS
B=MEMBRS
LOOKUP
5
S=SHARE-FILE
ASSIGN LOCKOPTION=OFF
OUTPUT=LP
F ACCOUNT LT 999999000 AND REST-FLAG-11 LT 80 AND &
  REST-FLAG-12 LT 80 AND &
  DESC-ABRV="RSV","SSV","CSP","EST","GRD","REP","TST","UTM", &
            "NSV","IRA","IRO","IED","SEP","DCP","MTC"
REPORT
NOPAGE
D1,"DIVD",4
D1,ACCOUNT,13
D1,SUFFIX,15
S,SUFFIX
S,ACCOUNT
END
EXIT
!endif

Below is the equivalent Suprtool task, which executes much more quickly. The Define commands describe the format of the output file, which is with all fields in DISPLAY format (i.e., ASCII). The Extract commands move the field values from the database record to the new output file record. In this case there are no adjustments or changes to the data, just a simple extract. But with Suprtool there could be. Notice that we inserted a literal "DIVD" at the start of each output record. The Sort commands sort the records by the SUFFIX and ACCOUNT fields.

!run suprtool.pub.robelle
base membrs,5,LOOKUP
get share-file
if ACCOUNT < 999999000 and REST-FLAG-11 < 80 and &
  REST-FLAG-12 < 80 and &
  DESC-ABRV="RSV","SSV","CSP","EST","GRD","REP","TST","UTM", &
            "NSV","IRA","IRO","IED","SEP","DCP","MTC"
sort suffix
sort account
define fld1,1,9,display
define fld2,1,2,display
sort suffix
sort account
extract "DIVD"
extract fld1 = account
extract fld2 = suffix
output qslist
exit

Another Spectrum Example

Instead of doing this:

  !RUN PFASTTAG.PGMS.SPECTRUM;LIB=P
  B=MEMBRS
  *****pass********
  5
  S=SHARE-FILE
  F ACC <> 92,94,98,99
  O=LP
  REPORT
  NOPAGE
  D,ACCOUNT,13
  D,SUFFIX,15
  D,DESC-ABRV,20
  D,ACC,26
  D,ENTRY-DATE,34
  D,PERIOD-LOW-BAL,44
  D,LAST-CHG-DATE,52
  D,BALANCE,62
  D,REST-FLAG-11,66
  D,REST-FLAG-12,70
  END
  EXIT
  !EOD
  !RELEASE DRFEETG1
  !PURGE DRFEETG2
  !SORT
  INPUT DRFEETG1
  OUTPUT DRFEETG2
  KEY 1,13
  KEY 14,2,DESC
  END
  !EOD

  !run Suprtool.pub.robelle
  base MEMBRS,5,****password*****
  get SHARE-FILE
  if ACC <> 92,94,98,99
  define D-ACCOUNT,1,13,display
  define D-SUFFIX,1,2,display
  define D-DESC-ABRV,1,5,display
  define D-ACC,1,6,display
  define D-ENTRY-DATE,1,8,display
  define D-PERIOD-LOW-BAL,1,10,display
  define D-LAST-CHG-DATE,1,8,display
  define D-BALANCE,1,10,display
  define D-REST-FLAG-11,1,4,display
  define D-REST-FLAG-12,1,4,display
  sort ACCOUNT
  extract D-ACCOUNT = ACCOUNT
  extract D-SUFFIX = SUFFIX
  extract D-DESC-ABRV = DESC-ABRV
  extract D-ACC = ACC
  extract D-ENTRY-DATE = ENTRY-DATE
  extract D-PERIOD-LOW-BAL = PERIOD-LOW-BAL
  extract D-LAST-CHG-DATE = LAST-CHG-DATE
  extract D-BALANCE = BALANCE
  extract D-REST-FLAG-11 = REST-FLAG-11
  extract D-REST-FLAG-12 = REST-FLAG-12
  output DRFEETG2
  exit

The Extract commands move the field values from the database record to the new output file record. In this case there are no adjustments or changes to the data, just a simple extract. But with Suprtool there could be.

The Sort command sorts the records by the ACC field.

Note: Qedit and Suprtool are trademarks of Robelle Solutions Technology Inc. Spectrum is a trademark of Fiserv.