How to stop using the qualifying statement 'IN' for Oracle db

[Whittall, Conrad]

Brett,

So long as you don't have a file in your dictionary by the same name as
the table in the Oracle database that you're trying to access, the
easiest way to accomplish what you are looking for is to start QUIZ with
the SUBDICT=SEARCH command line parameter.

Best regards,
Conrad

Conrad Whittall
Manager, Support Architecture, Global Customer Support
*******************************************************
Cognos Incorporated 
3755 Riverside Drive, PO Box 9707 Stn. T
Ottawa, ON K1G 4K9
Canada
*******************************************************



-----Original Message-----
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 Brett Greiner
Sent: Tuesday 16 May 2006 20:14
To: powerh-l at sowder.com
Subject: How to stop using the qualifying statement 'IN' for Oracle db

 
Hi 

Is there a command in the PDL we can set to make Oracle the default
dictionary rather than the PH Dictionary files?

I'm asking this question because when we access an Oracle file in QUIZ
we have to qualify the table each time by using the IN statement. Can we
get around using the IN statement???

I.e. 
> Access asset_category
*E* The file ASSET_CATEGORY wasn't found in the data dictionary.
> Access asset_category in afl
> show items

                                             INPUT OUTPUT
ASSET_CATEGORY                          TYPE SCALE SCALE  DEC PICTURE
* CATEGORY_CODE                         NUM     0     0    0   ^^,^^^
  DESCRIPTION                           CHAR                  X(30)


> access asset in afl &
>   link to asset_category in afl
Access ASSET_CATEGORY viaindex ASSET_CATEGORY_KEY.
> go


Thanks
Brett

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