Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Multiple lookups to address book master

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Multiple lookups to address book master
 Login/Join
 
Silver Member
posted
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)
 
Posts: 42 | Registered: April 29, 2010Report This Post
Expert
posted Hide Post
Use TAGs.

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'


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
Except that you need to name the joins differently. So:
JOIN TLURAB IN F554852 TO ABAN8 IN F0101 TAG IID AS J1
JOIN TLAN8  IN F554852 TO ABAN8 IN F0101 TAG TLN AS J2


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
Ooh,

Schoolboy error.

Eek, well spotted.

The perils of typing and not testing.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
or use the DB_LOOKUP function and go home early.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
Have you used DB_LOOKUP much ?

Hows the performance ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Master
posted Hide Post
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, 2006Report This Post
Expert
posted Hide Post
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, 2003Report This Post
Silver Member
posted Hide Post
Waz, thanks, it works!


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 42 | Registered: April 29, 2010Report This Post
Expert
posted Hide Post
Josh,

Please edit your first post in this thread and add [CLOSED] or [SOLVED] to the title


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Multiple lookups to address book master

Copyright © 1996-2020 Information Builders