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