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     Determine if a Hold file Contains a column[Solved]

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Determine if a Hold file Contains a column[Solved]
 Login/Join
 
joyesiji
Member
posted
Lets say i have this


DEFINE FILE CAR
ABBEY/A15 ='JUBRIL'
END

TABLE FILE CAR
PRINT ABBEY CAR MODEL WHERE COUNTRY EQ 'ENGLANDS'
ON TABLE HOLD AS SALES
END


I am storing all the values in an hold file ,given that hold file how do i determine somewhere else in the report if the sales hold file contains column ABBEY

is there a statement like
IF FILE SALES CONTAINS COLUMN ABBEY

This message has been edited. Last edited by: joyesiji,


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 20 | Registered: July 06, 2010Report This Post
Waz
Expert
posted Hide Post
There are two ways to do this.

1. CHECK FILE HOLD

2. TABLE FILE SYSCOLUM

If you filter on the column name, and master name with SYSCOLUM, and get a record the column exists.


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
Danny-SRL
Virtuoso
posted Hide Post
Following up on Waz:
  
DEFINE FILE CAR
ABBEY/A15 ='JUBRIL'
END

TABLE FILE CAR
PRINT ABBEY CAR MODEL WHERE COUNTRY EQ 'ENGLANDS'
ON TABLE HOLD AS SALES
END

Add the following:
  
CHECK FILE SALES HOLD
TABLE FILE HOLD
PRINT FIELDNAME
IF FIELDNAME EQ 'ABBEY'
ON TABLE SAVE
END
-RUN
-SET &ISABBEY=&RECORDS;

Then you can check whether &ISABBEY equals 0 or not. If it is 0 no ABBEY!


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Waz
Expert
posted Hide Post
Following up on myself...

DEFINE FILE CAR
ABBEY/A15 ='JUBRIL'
END

TABLE FILE CAR
PRINT ABBEY CAR MODEL WHERE COUNTRY EQ 'ENGLANDS'
ON TABLE HOLD AS SALES
END

TABLE FILE SYSCOLUM
PRINT NAME
WHERE TBNAME EQ 'sales'
AND NAME EQ 'ABBEY'
ON TABLE SAVE
END
-RUN
-SET &ISABBEY=&RECORDS;


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
<JG>
posted
I have got to be very dense but the fact that you coded the extract to contain a column named
ABBEY means that the hold file will contain a column named ABBEY.

The only reason it would not later in a procedure is because you used the same hold file name
for a subsequent extract that did not contain it.

If bad coding practice is your issue then change your technique.
 
Report This Post
Waz
Expert
posted Hide Post
One case that would cause a column to be different is if you use ACROSS and HOLD.
TABLE FILE CAR
SUM SALES
BY COUNTRY
ACROSS CAR
ON TABLE HOLD AS HLD_CAR
ON TABLE SET ASNAMES ON
END
TABLE FILE SYSCOLUM
PRINT TBNAME NAME
WHERE TBNAME EQ 'HLD_CAR'
END


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
Dan Satchell
Virtuoso
posted Hide Post
You could also use Dialogue Manager to read through the master for the hold file and search for the value. Here's an example using the CAR master:

FILEDEF CARMAS DISK IBISAMP/CAR.MAS
-RUN
-*
-SET &IORETURN = 0 ;
-*
-REPEAT ENDREPEAT1 WHILE &IORETURN EQ 0 ;
-READ CARMAS &TEXT.80.
-SET &TEXT_FOUND = IF (&TEXT CONTAINS 'ABBEY') THEN 'Y' ELSE 'N';
-IF (&TEXT_FOUND EQ 'Y') GOTO EXITREPEAT1 ;
-ENDREPEAT1
-EXITREPEAT1
-*
-TYPE TEXT_FOUND=&TEXT_FOUND

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Waz
Expert
posted Hide Post
Well thats three ways...

If we make it to five can we go to Milliways. Big Grin


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
Dan Satchell
Virtuoso
posted Hide Post
The best alternative would be -READFILE, but that's not available until 7.7.01 (according to the docs).


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Waz
Expert
posted Hide Post
Thats Four !


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     Determine if a Hold file Contains a column[Solved]

Copyright © 1996-2020 Information Builders