we can create SYNONYM use script like "CREATE SYNONYM path/name FOR owner.tablename" but,any one knows how to create business view using command with join other table? I search doc didn't find it thanks a lot ~This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
January 12, 2011, 10:29 PM
Waz
As far as I know, you have two choices.
1. Create a view and then create the synonym.
2. Create a multi segemtn master. Each segment point to a different table, and the relationship is defined in the ACX file.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 12, 2011, 10:49 PM
Cobain
Dear Waz, thanks for your reply,would you please give me a sample about how to defined relationship in the acx file?