CHOOSE and SELECT vs SQL

[Deskin, Bob]

Neither the CHOOSE nor the SELECT are converted to JOINs. The only way you can get an actual JOIN in QUIZ or QTP is to code one yourself in a DECLARE CURSOR statement. If you want to talk philosophically about what you would use to do the equivalent to QUIZ/QTP in SQL, then a straight LINK TO is an inner join. An optional LINK is an outer join. You can't specify a SELECT file IF directly, so a SELECT IF, SELECT file IF, and a CHOOSE are all basically WHERE clauses.

As for parallel linkage, there was a technique written up in SupportLink a while back. There are still things that QUIZ/QTP retrieval does quite easily that aren't simple in relational.

Bob

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com]On
Behalf Of fernando.olmos at hpa.com.au
Sent: April 5, 2006 12:46 AM
To: powerh-l at lists.sowder.com
Subject: CHOOSE and SELECT vs SQL


Is my statement below correct Joe, etc?

-----Original Message-----
From: Fernando Olmos 
Sent: Wednesday, 5 April 2006 2:45 PM
To: Peter Hofstaetter
Subject: RE: powerh-l Digest, Vol 11, Issue 8


I bet the CHOOSE statement equates to a INNER JOIN ON statement in SQL!
The SELECT RECORD IF equates to an INNER LEFT JOIN ON and the SELECT IF
does not use JOINS at all!

-----Original Message-----
From: Peter Hofstaetter 
Sent: Wednesday, 5 April 2006 2:42 PM
To: Fernando Olmos
Subject: FW: powerh-l Digest, Vol 11, Issue 8


Hi Fernando,

>From my experience, the choose on non index fields does get sent to
Oracle and there is a noticeable difference in speed to doing a choose
to using select table if, i.e. all chooses are converted to a where
clause sent to Oracle and all selects are done by Powerhouse after the
data has been sent back from Oracle.
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
 
     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.