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     Matching with Text Fields

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Matching with Text Fields
 Login/Join
 
gregson06
Platinum Member
posted
I'm trying to run a MATCH procedure on a report that includes a field that is a text field (SQL describes it as a size 4000 nvarchar). For some reason a join will still pull this field, but when I run a match I get "(FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS: fieldname"

I figured that it's the field that is creating this error, but is there another way of getting this to work? Is there a limit on how big a field is when using MATCH FILE?

BTW, I'm using Webfocus 5.3.

Thanks!

This message has been edited. Last edited by: gregson06,
 
Posts: 87 | Registered: August 03, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
quote:
(FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS:
The following options are not yet supported with text fields:
CRTFORM, TYPE, FSCAN, WHERE, HOLD FORMAT LOTUS, CALC, IFPS, and
DIF. Text fields are not currently supported in most non-FOCUS
files.


And probably MATCH.

You ought to generate a Master with the text field defined as an alpha field: A4000.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
gregson06
Platinum Member
posted Hide Post
Thanks Francis! This works great, I suppose that A4000 is different from "text", I wonder why the translated field errors out like that.

Thanks again!
 
Posts: 87 | Registered: August 03, 2006Report This Post
gregson06
Platinum Member
posted Hide Post
Okay, I've done this, but for some reason the field shows up blank. Is there a format that will retrieve large character fields like this one?

Thanks again!
 
Posts: 87 | Registered: August 03, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
I can't explain why the field shows up blank.

I have a DB2 table with a text field and the Master field attributes are generated like this:
FIELD=COMMENT_TXT, COMMENT_TXT, TX50, TX, MISSING=ON, $

When I change the option on the Server Console's Metadata Generation page to Alpha, the field attributes are generated like this:
FIELD=COMMENT_TXT, COMMENT_TXT, A500, A500, MISSING=ON, $


Did you change your Master accordingly?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
gregson06
Platinum Member
posted Hide Post
Francis,

I got it to work just like you mentioned here. I tried creating an alias master, but couldn't figure out how to get it to point to the same source. This works great, though! Thank you!
 
Posts: 87 | Registered: August 03, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
If you would like to have more than one Master for the same DBMS table, name the .mas whatever you want to. Then name the acx file exactly the same as the .mas file. In the .acx file, the TABLENAME clause points to the DBMS table. E.G.:
SEGNAME=BLAHBLAH,
TABLENAME=BASEL.AC_DELQ_STAT_C,
CONNECTION=BSL,
KEYS=1
,$
blahblah.mas, blahblah.acx point to table BASEL.AC_DELQ_STAT_C.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     Matching with Text Fields

Copyright © 1996-2020 Information Builders