Indexed or Seq?

[Whittall, Conrad]

Fernando,
 
I believe the answer to your questions is Yes and Yes...with PowerHouse
8 you can do either -- embed a declared cursor in your PH code, or
create a view or stored procedure in the database and have PH access
that. You can find all the details in the PowerHouse Series 8 Books,
available online from the PowerHouse site...
 
http://powerhouse.cognos.com/products/powerhouse/download.html
 
The one you really need to take a look at is the PowerHouse and
Relational Databases book...
 
http://powerhouse.cognos.com/products/powerhouse/downloads/PH_and_Relati
onal_Databases.pdf
 
Best regards,
Conrad 

Conrad Whittall
Senior Solutions Architect, Global Customer Services, Cognos
Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada


________________________________

From: powerh-l-bounces+conrad.whittall=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+conrad.whittall=cognos.com at lists.sowder.com] On
Behalf Of fernando.olmos at hpa.com.au
Sent: Thursday 11 August 2005 18:51
To: powerh-l at lists.sowder.com
Subject: RE: Indexed or Seq?


 

	-----Original Message-----
	From: Fernando Olmos 
	Sent: Friday, August 12, 2005 8:24 AM
	To: powerh-l at lists.sowder.com
	Subject: RE: Indexed or Seq?
	
	
	Bob and Joe,
	 
	Thank you both for the input. I fully understand what's going
on. Just one more question... Bob, are you saying to declare the cursor
using SQL or is there a way to do this in QUIZ and have it embedded into
the BUILD of the QUIZ program? OR can the cursor be declared at the
database level and accessed via QUIZ? A view? Sorry, but I am not that
familiar with Oracle. I know in Oracle RDB, from the VAX, we were able
to "stream-line" queries with cursors, but only using embedded SQL
within COBOL. I have never seen cursors been used from within
Powerhouse.
	 
	Cheers

		-----Original Message-----
		From: Bob.Deskin at Cognos.COM
[mailto:Bob.Deskin at Cognos.COM] 
		Sent: Friday, August 12, 2005 4:57 AM
		To: atla38 at dsl.pipex.com; Fernando Olmos;
powerh-l at lists.sowder.com
		Subject: RE: Indexed or Seq?
		
		
		[F.Olmos] <snip> 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you. 
        
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20050811/45764faf/attachment.html