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.
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.
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!
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.
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