CHECKSUM function in PowerHouse

[Tim Cummings]

The reason I'm wanting to use Cobol is for performance.  I will typically be
processing 2 million to 9 million records.
 
 
-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison at mcbrideelectric.com]
Sent: Monday, December 12, 2005 3:36 PM
To: Tim Cummings; Cognos Powerhouse List (E-mail)
Subject: RE: CHECKSUM function in PowerHouse



Tim,

 

Your COBOL program could call a simple QUICK or QTP program that calculates
the CHECKSUM of a passed-in value.  If you have a lot of data, this would be
a slow performer, though, as you'd be loading the PH program once per
record.  If that were a problem, you'd want to look at processing the flat
file directly, or a file created from it.

 

Cordially,

 

David Morrison

McBride Electric

 

  _____  

From: powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com
[mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com] On
Behalf Of Tim Cummings
Sent: Monday, December 12, 2005 12:17 PM
To: Cognos Powerhouse List (E-mail)
Subject: CHECKSUM function in PowerHouse

 

Is the formula for the CHECKSUM function published anywhere?

 

I want to create a Cobol program to do some work on a dataset.  The dataset
has a field that was populated in a QTP program that contains the results of
a CHECKSUM.  I want the Cobol program to read some source data from a flat
file, calculate a checksum for the same fields and compare the results to
the checksum stored in the dataset.  If they are different, It will trigger
a series of updates to happen in the Cobol program.

 

If the formula is not published, is there a way to call the PH function?

Timothy J Cummings 
Milford, Ohio  45150 
< mailto:Tim.Cummings at Frequencymarketing.Com
<mailto:Tim.Cummings at Frequencymarketing.Com> > 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051212/0dbc5ecc/attachment.htm