Author Topic: PowerHouse - report # of records , file limit etc.  (Read 6441 times)

Offline CHUCK_LOWE

  • Full Member
  • ***
  • Join Date: Jul 2005
  • Posts: 15
  • Forum Citizenship: +0/-0
PowerHouse - report # of records , file limit etc.
« on: 05 Sep 2007 12:12:16 pm »
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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,349
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
Re: PowerHouse - report # of records , file limit etc.
« Reply #1 on: 06 Sep 2007 03:51:13 am »
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.
Meep!

Offline CHUCK_LOWE

  • Full Member
  • ***
  • Join Date: Jul 2005
  • Posts: 15
  • Forum Citizenship: +0/-0
Re: PowerHouse - report # of records , file limit etc.
« Reply #2 on: 07 Sep 2007 11:07:12 am »
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!

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,349
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
Re: PowerHouse - report # of records , file limit etc.
« Reply #3 on: 17 Sep 2007 04:41:23 am »
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.
Meep!

Offline Blue

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Jul 2005
  • Posts: 281
  • Forum Citizenship: +15/-0
  • The earth is one country ... Baha'i Faith
Re: PowerHouse - report # of records , file limit etc.
« Reply #4 on: 12 Oct 2007 01:54:20 pm »
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
Robert Edis
Principal
Robert Edis Consulting
Wellington, New Zealand