PowerHouse - report # of records , file limit etc.

[CHUCK_LOWE]

I've been wondering this one for years.  Why do PowerHouse programs (Quick, Quick, QTP) not have a predefined field that returns the number of records currently in a dataset.  Or any of the counts associated with a dataset or even a file.  I have in the past wrote a Cobol XL that is called from withing Quick to do the DBOpens etc to get this info and retrieve it back to the process (Quick Screen) for further use.

[MFGF]

Hi,

Couldn't you just code a simple procedure with a while retrieving loop to count the number of records?  Or if you're pointing at a relational source, code an embedded 'Select count(*) from table'?

Just a thought,

MF.

[CHUCK_LOWE]

While retrieving could take a while depending on # of records.  We are using Turbo Image so it's not relational. 
This should be a simple task for Cognos Development!

[MFGF]

Hmmm - given you already have a mechanism to do this (albeit not as quickly as you would like), I'd be surprised if Cognos PowerHouse development would add this as a new feature.  Still, I guess it's always worth a try - you never know.  Try logging an enhancement request either on Cognos.com or via the PowerHouse List email server.

Best regards,

MF.

[Blue]

Given that each DBMS (and oftern each version) has a different way of collecting and storing statistics I could see that this may be problematic for PH designers.

Bluey