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] Need to read the CRJOINTYPE metrics from Master File.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Need to read the CRJOINTYPE metrics from Master File.
 Login/Join
 
Member
posted
Hi ALL,

I want to read the CRJOINTYPE(JOIN type) values from Master File.

please suggest.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: December 14, 2017Report This Post
Guru
posted Hide Post
Go to textview?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Expert
posted Hide Post
Is this for a Program or just to have a look ?


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: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
Hi Veeramani

First of all welcome to Focal Point. I think you will find it very useful for getting answers to your development questions.

If you want to read this information with a WF program there is a table called syscolumn which contains the information you are looking for. The master file can be found in the ibi\srv81\home\catalog directory. You can set a WHERE statement to select on TBNAME.

Hope this helps.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Dear All,

Thanks for your reply.

For Example: Master File Contents are below like as,

car.mas:

FILENAME=TABLE_CURR, SUFFIX=SQLDBC , $
SEGMENT=2020_CURR, SEGTYPE=S0, $
FIELDNAME=MO_NB, ALIAS=MO_NB, USAGE=I6, ACTUAL=I4, MISSING=ON, $
DEFINE COM_IND/A1=IF FIELD_SK EQ 2 THEN 'Y' ELSE 'N'; $
SEGMENT=2020_AGNT, SEGTYPE=U, SEGSUF=SQLDBC , PARENT=2020_CURR, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=GRP_SK EQ 2020_AGNT.GRP_SK;, $
FIELDNAME=USER_ID_CD, ALIAS=USER_ID_CD, USAGE=A9, ACTUAL=A9, $
SEGMENT=ACCT_CURR, SEGTYPE=U, SEGSUF=SQLDBC , PARENT=2020_CURR, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=2020_CURR.ACCT_NB EQ ACCT_CURR.ACCT_NB;, $

Question:
I want to read all the FILENAME, SEGMENT, PARENT, CRJOINTYPE and JOIN_WHERE metric values through fex code.
please suggest.


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: December 14, 2017Report This Post
Virtuoso
posted Hide Post
I'm not sure it will contain the CRJOINTYPE data, but you can probably get a lot of that info from:
CHECK FILE TABLE_CURR HOLD

TABLE FILE HOLD
PRINT *
END


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Member
posted Hide Post
quote:
CHECK FILE TABLE_CURR HOLD

TABLE FILE HOLD
PRINT *
END



Already, I tried with the above mentioned code. For CRJOINTYPE and JOIN_WHERE columns are blank. Any other way to retrieve this values?.


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: December 14, 2017Report This Post
Expert
posted Hide Post
I suggest that you read the response from Chuck - FP Mod Chuck - above.

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
Member
posted Hide Post
quote:
Originally posted by FP Mod Chuck:
Hi Veeramani

First of all welcome to Focal Point. I think you will find it very useful for getting answers to your development questions.

If you want to read this information with a WF program there is a table called syscolumn which contains the information you are looking for. The master file can be found in the ibi\srv81\home\catalog directory. You can set a WHERE statement to select on TBNAME.

Hope this helps.


please share the sample code. it's helps to resolve the issue.


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: December 14, 2017Report This Post
Virtuoso
posted Hide Post
Hi Veeramani

Here is some sample code.


DEFINE FILE SYSCOLUM
JOIN_TYPE/A20=
IF SYSCOLUM.SYSSEG.JOINTYPE EQ 'L' THEN 'Left Outer' ELSE
IF SYSCOLUM.SYSSEG.JOINTYPE EQ 'I' THEN 'Inner' ELSE 'No Join Type';
END
TABLE FILE SYSCOLUM
BY SYSCOLUM.SYSCOLUM.TBNAME
BY SYSCOLUM.SYSSEG.SEGNAME
BY SYSCOLUM.SYSSEG.JOIN_TYPE
WHERE SYSCOLUM.SYSCOLUM.TBNAME EQ '&TBNAME.(FIND SYSCOLUM.SYSCOLUM.TBNAME IN SYSCOLUM).TBNAME:.';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Expert
posted Hide Post
Well done Chuck.....


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: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
Hi Chuck,

Great work. Thanks a lot. I also want the field (JOIN_WHERE) which is used to join two tables.

Thanks,Veeramani


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: December 14, 2017Report This Post
Virtuoso
posted Hide Post
I am working on that hope to have it to you later today. It must be in a different table and I haven't located it yet


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Hey Veeramani,

I think you're looking for JOIN_EXPR

TABLE FILE SYSCOLUM
BY SYSCOLUM.SYSSEG.JOIN_EXPR
END

You probably also want PARENT to show the table that originates the join.

Hope that helps.

Dan


Dan B.
WebFocus 8205M
 
Posts: 25 | Registered: May 18, 2017Report This Post
Virtuoso
posted Hide Post
So here is the updated code but it only works in WF 8.2 the JOIN_EXPR field does not exist in SYSCOLUMN prior to that. Thanks Dan for your input on including PARENT and finding JOIN_EXPR!


DEFINE FILE SYSCOLUM
JOIN_TYPE/A20=
IF SYSCOLUM.SYSSEG.JOINTYPE EQ 'L' THEN 'Left Outer' ELSE
IF SYSCOLUM.SYSSEG.JOINTYPE EQ 'I' THEN 'Inner' ELSE 'No Join Type';
END
TABLE FILE SYSCOLUM
BY SYSCOLUM.SYSCOLUM.TBNAME
BY SYSCOLUM.SYSSEG.SEGNAME
BY SYSCOLUM.SYSSEG.PARENT
BY SYSCOLUM.SYSSEG.JOIN_TYPE
BY SYSCOLUM.SYSSEG.JOIN_EXPR
WHERE SYSCOLUM.SYSCOLUM.TBNAME EQ '&TBNAME.(FIND SYSCOLUM.SYSCOLUM.TBNAME IN SYSCOLUM).TBNAME:.';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Hi Chuck,

Thanks for your help. Currently, We are using WebFOCUS 8.1.05 version. Let me check in WF8.2


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: December 14, 2017Report 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] Need to read the CRJOINTYPE metrics from Master File.

Copyright © 1996-2020 Information Builders