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

[Ken Langendock]

If I remember right (it's been a few years) you also need the NODELAY on
that command to make your compiles go faster.
As in
 
quiz subdict='(search,nodelay)' procloc=$SRC

I think every time you hit a File statement without it, there is a delay
in the compile process while it tries to figure out where the file comes
from.

Ken

-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Brett Greiner
Sent: May 17, 2006 12:24 AM
To: Whittall, Conrad; powerh-l at sowder.com
Subject: RE: How to stop using the qualifying statement 'IN' for Oracle
db


 
Hi Conrad

Works a treat. This will save us using the "IN" statement when we do our
database conversion.

Thanks
Brett.

-----Original Message-----
From: powerh-l-bounces+brett.greiner=synoptix.co.nz at lists.sowder.com
[mailto:powerh-l-bounces+brett.greiner=synoptix.co.nz at lists.sowder.com]
On Behalf Of Whittall, Conrad
Sent: Wednesday, 17 May 2006 14:54
To: powerh-l at sowder.com
Subject: RE: How to stop using the qualifying statement 'IN' for Oracle
db

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.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.