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     SOUNDEX fnct in 5.2.5.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
SOUNDEX fnct in 5.2.5.
 Login/Join
 
<schulzhj>
posted
Hey,

does anyone know, if SOUNDEX is supported in 5.2.5. ?

I just migrated from 4.3.6. to 5.2.5.
and it seems, that SOUNDEX is not found or has changed !!!!!!!!!!!

I now get an error message
(FOC36355) UNZUL�SSIGER ARGUMENTTYP #1 F�R BENUTZER FUNKTION SOUNDEX

but I didn't change anything !

Here's an example with the CAR file

DEFINE FILE CAR
PHON_1/A4 = SOUNDEX(5, MODEL, PHON_1);
END

TABLE FILE CAR
PRINT
MODEL
PHON_1
BY CAR
END

Thx Achim
 
Report This Post
vaayu
Guru
posted Hide Post
here's an example

DEFINE FILE EMPLOYEE
PHON_NAME/A4 = SOUNDEX('15', LAST_NAME,PHON_NAME);
PHON_COY/A4 WITH LAST_NAME = SOUNDEX('15', 'MICOY', PHON_COY);
PHON_MATCH/A3 = IF PHON_NAME IS PHON_COY THEN 'YES' ELSE 'NO';
END

TABLE FILE EMPLOYEE
PRINT LAST_NAME
IF PHON_MATCH IS 'YES'
END


hope this helps
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
vaayu
Guru
posted Hide Post
and the output is


LAST_NAME

MCCOY
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Roland
Gold member
posted Hide Post
Achim,

WF gets more tough in controlling our syntax. So some syntax errors may have passed the parser and be executed correctly in the past. But they will fail now. In WF525 they especially enhanced the checking for parameters to UWS. You have to be strict in format and sometimes even with values for those parameters (like SUBSTR may not be LE 0).
I recall having seen a SET parameter in the Summary of New Features, that disables this strict behaviour. But I don't remember its name nor the possible values and their meanings.

But maybe its better anyway to recheck all those calls in your code and to correct where necessary.
 
Posts: 54 | Location: Switzerland | Registered: May 13, 2003Report This Post
<ineuxf>
posted
The SET command is SET USERFCHK = OFF (default is ON)
 
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     SOUNDEX fnct in 5.2.5.

Copyright © 1996-2020 Information Builders