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     Problem with DB_LOOKUP

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem with DB_LOOKUP
 Login/Join
 
Håkan
Guru
posted
Hi all,

I'm having a problem with DB_LOOKUP, getting the message "This report is invalid because the data retrieval has been killed or the job has been stopped".

The request is like this:

DEFINE FILE CAR
YEAR_A/A4 = '2008';
D_VALUE/I9 = DB_LOOKUP(DEFHOLD,YEAR_A,YEAR_A,DEFVAL);
END
TABLE FILE CAR
SUM DC RC D_VALUE
BY COUNTRY BY YEAR_A
IF RECORDLIMIT EQ 1
END

The DEFHOLD file is a single-segment file holding year and a value.

Any ideas, anyone?

Tia
Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
GamP
Virtuoso
posted Hide Post
Hakan,

I have taken your example, and ran it on my environment.
No problem, everything works fine.
I even played around with changing formats and sort orders and such, but it never gave me the error you got.
Are you running this from within MRE/BID or not?


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Håkan
Guru
posted Hide Post
Gerard,

this is self-service. I've tried it both in DS 7.6.6 and WF 7.6.4. Same result in both environments.

Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
Tom Flynn
Expert
posted Hide Post
Håkan

Is the DEFHOLD file being held in an APP folder??
Is that APP folder on the APP PATH??

APP HOLD foldername
APP PREPENDPATH foldername
APP FILEDEF DEFHOLD DISK etc...

Just throwing out some ideas...

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
<Dane>
posted
Try this;
APP HOLD Give it a projectname
SET ASNAMES =ON
TABLE FILE TRAINING
SUM COURSECODE AS 'COURSE'
BY PIN AS 'SSN'
ON TABLE HOLD AS DOG FORMAT ALPHA
END
DEFINE FILE EMPDATA
YEAR_A/YY='2008';
D_VALUE/A7 = DB_LOOKUP(DOG,PIN,SSN,COURSE );
END
TABLE FILE EMPDATA
PRINT SALARY D_VALUE
BY YEAR_A
BY PIN
-*IF RECORDLIMIT EQ 1
END
DEFINE FILE EMPDATA CLEAR
END
 
Report 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     Problem with DB_LOOKUP

Copyright © 1996-2020 Information Builders