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

[Joe Boyle]

I would suggest that you retain as much item/file qualification as possible, 
even including a table name acronym as the lead characters of file name 
aliases. You'll benefit in the long run - believe me.

----- Original Message ----- 
From: "Brett Greiner" <Brett.Greiner at synoptix.co.nz>
To: <powerh-l at sowder.com>
Sent: Wednesday, May 17, 2006 1:14 AM
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
>
> -- 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: &quot;subscribe&quot; in message body to 
> powerh-l-request at lists.sowder.com
> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.
>