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     [CLOSED] Date define not working properly since upgrade

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Date define not working properly since upgrade
 Login/Join
 
LAW
Member
posted
Recently upgraded (last week) from WF 7.6.4. to 7.6.8 - upgrade went extremely smooth. Windows Server 2003

Since then - I am finding defines that DO NOT work the way they did in previous versions of WF.

In the define below - if the AW_UNOFF_REVISED_DELIVERY_DT or the AW_OFFICIAL_REVISED_DLVRY_DT
are blank or missing this define thinks they are greater than the AW_ORIG_DELIVERY_DT and it uses a blank
for the DELIVERY_DT - this causing MAJOR problems. Is anyone else having the same problem?


DEFINE FILE AWHEADER
-* This algorithm will calculate the newest delivery date
DATE1/YMD = IF AW_ORIG_DELIVERY_DT GT AW_UNOFF_REVISED_DELIVERY_DT THEN
AW_ORIG_DELIVERY_DT ELSE AW_UNOFF_REVISED_DELIVERY_DT;
DELIVERY_DT/YMD = IF DATE1 GT AW_OFFICIAL_REVISED_DLVRY_DT THEN
DATE1 ELSE AW_OFFICIAL_REVISED_DLVRY_DT;
END

This message has been edited. Last edited by: Kerry,
 
Posts: 14 | Registered: November 05, 2008Report This Post
j.gross
Virtuoso
posted Hide Post
quote:
if the AW_UNOFF_REVISED_DELIVERY_DT or the AW_OFFICIAL_REVISED_DLVRY_DT are blank or missing...


AW_ORIG_DELIVERY_DT GT AW_UNOFF_REVISED_DELIVERY_DT
and
DATE1 GT AW_OFFICIAL_REVISED_DLVRY_DT
evaluate to False if either operand is MISSING.

If the _DT fields have MISSING ON, convert them first to /YYMD dates with MISSING OFF (which will effectively map Missing to low-values), than use MAX( , , ).
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
LAW
Member
posted Hide Post
quote:
AW_ORIG_DELIVERY_DT GT AW_UNOFF_REVISED_DELIVERY_DT
and
DATE1 GT AW_OFFICIAL_REVISED_DLVRY_DT



I was hoping there would be a GLOBAL fix - since I have a bazillion of these fexes!

Seems like this is a bug in 7.6.8.
 
Posts: 14 | Registered: November 05, 2008Report This Post
j.gross
Virtuoso
posted Hide Post
First you have to delineate the problem.

What are the Format and Missing attributes of the date fields?

How many such fields from how many masters are involved in the bazillion fexes?

You may be able to centralize the fixes to the MFD(s), or your service routines that supply standard Defines.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Darin Lee
Virtuoso
posted Hide Post
Interesting that this seems to be an upgrade issue for you. This is the way that WF has always worked, as jgross suggests. The DEFINE cannot evaluate an equality test if either field is missing, so it always returns false. Maybe some master files have been regenerated in the process of the upgrade and have lost their MISSING attribute or a DEFINE or something like that.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report 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     [CLOSED] Date define not working properly since upgrade

Copyright © 1996-2020 Information Builders