As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
I have the following code where I am joining address book master (F0101) to get the description for one field.
I have another field I need to get the description for..how can I do another lookup to F0101 to get a different row's ABALPH value? I need to do a lookup for TLAN8 = ABAN8.
JOIN TLURAB IN F554852 TO ABAN8 IN F0101 AS J1
TABLE FILE F554852
PRINT
TLDOCO
TLURRF
TLLITM
TLSHFT
TL$SGC
ABALPH AS 'Inspector ID'
TLDGL
TL$MCH
TLLOTS
TLRCD
TLTRQT
TLDOC
TLCRDJ
TLTDAY
BY TL$MCH NOPRINT
BY TLLOTS NOPRINT
BY TLDOCO NOPRINT
BY TLSHFT NOPRINT
WHERE....
This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)
JOIN TLURAB IN F554852 TO ABAN8 IN F0101 TAG IID AS J1
JOIN TLAN8 IN F554852 TO ABAN8 IN F0101 TAG TLN AS J1
TABLE FILE F554852
PRINT
IID.ABALPH AS 'Inspector ID'
TLN.ABALPH AS 'TLAN8'
I could never find a use for DB_LOOKUP and if you are processing thousands of record, seems it would be extremely slow. Also, just as a question, why can't FOCUS data sources be used? From the documentation, "The lookup file can be any non-FOCUS data source..."
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006
i use db_lookup all the time, everytime i need a field description for a field code. simplifies life. i never measured performance differences, never was an issue.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
Focal Point Forums 
