Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] TITLE attribute from an Oracle table?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] TITLE attribute from an Oracle table?
 Login/Join
 
Guru
posted
Hi,

If you have a table, in this case an Oracle table, and you create a synonym for it, you end up with:
  
<tablename>.acx
<tablename>.mas

In the .mas file, you will see each field listed this this:
  
FIELDNAME=EMPL_NM, ALIAS=EMPL_NM, USAGE=A100V, ACTUAL=A100V, MISSING=ON, $

If you write a fex like this:
  
TABLE FILE <tablename>
PRINT
  EMPL_NM
END

You will see something like:

EMPL_NM
Bob Smith
Sally Jones

Now I edit the .mas file, so the same line has a TITLE attribute, like so:
 
FIELDNAME=EMPL_NM, ALIAS=EMPL_NM, USAGE=A100V, ACTUAL=A100V, MISSING=ON, TITLE='Employee', $

I run the same fex and it shows something like this:

Employee
Bob Smith
Sally Jones

This is all pretty basic and simple. I'm hoping the answer to my question is similarly complex:

Is there a way to modify the Oracle table / view so that the TITLE attribute exists with the proper value as soon as I create the synonym?
In other words, can I store my TITLE values in the table itself, and if so, where?

Cheers,

Joey
WF 7.6.11

This message has been edited. Last edited by: Kerry,
 
Posts: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
I know that the comments in the column definition pass through to DESCRIPTION in the MAS file, not sure about anything populating TITLE


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Although it isn't Oracle, I found this info.

http://techsupport.information...utions/31002540.html

My guess is that it is the same for Oracle.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] TITLE attribute from an Oracle table?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.