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

Brett Greiner Brett.Greiner at synoptix.co.nz
Tue May 16 19:14:26 CDT 2006


 
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



More information about the powerh-l mailing list