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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]-Field existence with Table file request

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved]-Field existence with Table file request
 Login/Join
 
Platinum Member
posted
Hi,

Is there any way to check for the column existence within table file request.

For example, within the table file request,
if a certain field exists then display some values or else display as blank.

Thanks
Hari

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


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
Member
posted Hide Post
Hi,
do you want to check if this field has a value or if this field exists (in other words, if the name of the field is in the Master)?

In the first case you can use IS MISSING (when MIISSING is a possible value) or you can use FIELD EQ ''.
In the second case, I don't know. But if you have Master file, you should already know if the name of the field exists.

bye

P.S.: did you post this thread some days ago?



FOCUS 7.2.0S1
Mainframe - MVS 390
Excel, Flat file

Italy
 
Posts: 25 | Registered: June 23, 2009Report This Post
Platinum Member
posted Hide Post
Yes, you are right.
but in my case, i want to find if a field exists in a hold which gets dynamic data.

So, in my compute statement, if a field exists then i want to display its values else just show as blank.

I did not post this earlier. I looked at other threads but couldn;t get any answer.

-Hari


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
Member
posted Hide Post
Dynamic data....
May be in a ACROSS statement.
In this example you don't know the possible values of FIELD1 and so you don't know how may fields has file X2 and the names.
Is it your case?

TABLE FILE X1
SUM TOTAL1  AS ''             
BY KEY              
ACROSS FIELD1
ON TABLE HOLD AS 'X2'     
END                             



FOCUS 7.2.0S1
Mainframe - MVS 390
Excel, Flat file

Italy
 
Posts: 25 | Registered: June 23, 2009Report This Post
Platinum Member
posted Hide Post
Yes absolutely.

By default, i want some 10 columns to be displayed in my request.
So, if the across field has got only 5 values then i want only the 5 columns to be displayed with Across field value and others as blank.

Also, in my case, i want to position the coulmn according to the across field value.
if the across field value is CAR8, then i want CAR8 values to be displayed in 8th column. If it is CAR3 then in 3rd column.

I tried something as follows,
COMPUTE P1/A20 = HoldField1;
COMPUTE P2/A20 = HoldField2;

It fails when there is no value for across field or no filed in the hold file.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
Member
posted Hide Post
Have you already tried to create a file guide and then match (or join) with across file?
In this way all the fields of across file will be display.
I don't know other ways

MATCH FILE Z1
PRINT *
BY KEY
RUN                      
FILE X2
SUM   *                  
BY KEY NOPRINT
AFTER MATCH HOLD AS 'Z2' OLD 
END



FOCUS 7.2.0S1
Mainframe - MVS 390
Excel, Flat file

Italy
 
Posts: 25 | Registered: June 23, 2009Report This Post
Member
posted Hide Post
Try to see this:

http://forums.informationbuild...71057331/m/495103261



FOCUS 7.2.0S1
Mainframe - MVS 390
Excel, Flat file

Italy
 
Posts: 25 | Registered: June 23, 2009Report This Post
Platinum Member
posted Hide Post
yes..in the above thread, we can only check the field existence outside the table file request..i want it to be checked within table file request


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
Expert
posted Hide Post
Use COLUMN syntax -

ACROSS field_name
COLUMNS 'CAR1' AND 'CAR2' AND 'CAR3' etc.

The advantage of doing this is that if CAR6 never appears in the data it will still appear in your report.

This has been covered many times in previous posts but you have to be non-restrictive in your search and try several different key words with similar meaning.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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]-Field existence with Table file request

Copyright © 1996-2020 Information Builders