|
![]() |
Congratulations to you on a job well done! Here's to you...
The Heroes of Y2K
The official Sybase Y2K fixes are downloadable for (only) PFC versions 5.0.04 & 6.5.1 at
http://download.sybase.com/esd/pbuilder_Y2K_win.html PFC 6.5.1/5.0.04 Y2K Special Release Notes (Below) | Official place for PFC 6.5.1/5.0.04 Y2K Special Release Notes: pfcy2k.txt from PFC Y2K Download
Notes:
Be sure to get the PBDJ Feb'99 issue! - It covers Y2K, totally, including PFC... This PBDJ February 1999 issue (Volume 6, Issue 2) contains an excellent article specifically on the PFC (complete with downloadable code), written by Brian Grimm. The changes that Brian goes over are the very same fixes that Sybase made to the PFC 6.5.1/5.0.04 Special Releases (above). In addition, Brian will explain to you how just making the PFC fixes is not enough. You also need to check your application's specific date processing as well. (See What is the problem with using the Windows Short Date Format? below.)
If you want to code the PFC Y2K fixes yourself, you can download the PBDJ source code listings (all fixes) from here http://www.sys-con.com/pbdj/source/2-99/index.html
If for some reason (people have told me), you are unable to receive PBDJ, *maybe* you can get an access code for a free digital copy from here http://www.sys-con.com/pbdj/pdf/intro2.htm
Where is the official PB Y2K Info?
The official Sybase Y2K info (including a letter, whitepapers, FAQs, the matrix and more) can be found at
Letter and Main http://my.sybase.com/detail?id=20358 Matrix http://my.sybase.com/detail?id=1003355
Within the official Sybase Matrix there, these are the versions deemed "Certified compliant"
PowerBuilder 5 (for Windows) (the point product) 5.0.04 with EBF* PowerBuilder 6 (for Windows) (the point product) 6.5.1 with EBF* PowerBuilder 7 (for Windows) (the point product) 7.0.1 with EBF* PowerBuilder 6 (for UNIX) (the point product) 6.5 with EBF* PowerBuilder (for Unicode) 6.5 Unicode with EBF* PowerBuilder (Chinese & Korean) 6.5CK with EBF* PowerBuilder (Japanese) 6.5J with EBF* Legal century range product operates within: 1000-3000 Implied century rule: <50 = 2000, >49 = 1900 Note: Official place for this Matrix (It is subject to changes): Year 2000 Matrix (PDF file - 77KB)
* And these are the appropriate needed EBFs (Engineering Bug Fixes)
NT 386 HP 800 IBM RS6000 AIX Sun Solaris PowerBuilder 5 5004pfcy2k.zip AND 504ebf04.zip
n/a
n/a
n/a
PowerBuilder 6 pb651mnt.zip +
651pfcy2k.zip + pb6511137.zippb65hp1146.tar.Z +
651pfcy2k.tar.Zpb65aix1146.tar.Z +
651pfcy2k.tar.Zpb65solaris1146.tar.Z +
651pfcy2k.tar.ZPowerBuilder 7 pb7017023.zip n/a n/a n/a PowerBuilder (for Unicode) pb651unicode1145.zip n/a n/a n/a PowerBuilder (Chinese & Korean) pb65cky2k.zip n/a n/a n/a PowerBuilder (Japanese) See Year 2000 EBF Matrix n/a n/a n/a Note: Official place for this Matrix (It is subject to changes): Year 2000 EBF (Engineering Bug Fix) Matrix (PDF file - 11KB)
Does that mean PB and PFC 5.0.04 also need Y2K patches?
Yes, both PowerBuilder and PFC 5.0.04 need the
5.0.04 Y2K fixes. That means the PowerBuilder 5.0.04 EBF#4, plus
the special PFC 5.0.04 Y2K fixes.
Technically (at least for NT 386), PFC 5.0.03(and lower) & 6.0 &
6.5 are not totally Y2K compliant ~ and even PFC 5.0.04 has at least one glitch. The PFC
Y2K fixes were not discovered and corrected until PFC 7.0. And that is why the official,
special 5.0.04/6.5.1 PFC Y2K PBLs were created. See? Note that in the above
matrixes, PowerBuilder 5.0.04 with EBFs (pb)504ebf04.zip + 5004pfcy2k.zip
are needed.
Does that mean PB and PFC 6.5 also need Y2K patches?
Yes, both
PowerBuilder and PFC 6.5 need the 6.5.1 Y2K fixes. That means the PowerBuilder 6.5.1
Maintenance Release, plus the PowerBuilder 6.5.1 EBF (Build #1137), plus the special PFC 6.5.1 Y2K fixes.
Technically (at least for NT 386), PFC 5.0.03(and lower) & 6.0 &
6.5 are not totally Y2K compliant ~ and even PFC 5.0.04 has at least one glitch.
The PFC
Y2K fixes were not discovered and corrected until PFC 7.0. And that is why the official,
special 5.0.04/6.5.1 PFC Y2K PBLs were created. So you will notice that in the above
matrixes, PowerBuilder 6.5.1 with EBFs pb651mnt.zip + pb6511137.zip
+ 651pfcy2k.zip
are needed. There was a special PFC 6.5.1 Y2K release, separate from the PB 6.5.1 Maintenance release and the later Build #1137 EBF.
So you might have 1 or 2, but not all 3. Therefore, check to see if you
hare running PB 6.5.1 Build 1137, plus check to see if you have the special PFC
Y2K updates by searching for 6.5.1a in pfc_n_cst_datetime and pfc_u_calendar.
Does that mean PB 7.0 also needs Y2K patches?
Yes, you need to upgrade to PB 7.0.1 EBF Build #7023to be Y2K Certified
Compliant.
Can you still use the PFC 6.5.1 Special Y2K Maintenance Release without going to PowerBuilder 6.5.1?
Yes, I do believe that you can use PFC 6.5.1 with PB 6.5.0... In general, you can use any future "point" PFC release with a given PB release - http://www.pfcguide.com/faq/faq_misc.asp#compatible
However, check the above EBF chart, because you probably need to go to PowerBuilder 6.5.1 anyway in order to be deemed "certified compliant".
Why is PowerBuilder's Describe returning a Two-Digit Date?
Title: "Two-Digit Dates and PowerBuilder's
Describe"
Author: Ted Zimmerman
Occasionally developers using Windows 95 or 98 run into a situation in which
PowerBuilder's Describe returns two-digit dates. As a result, years before 1950 are
displayed as 20xx. In this online article, you'll find some tips and the workaround if
this happens to you: http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001547
What is the problem with using the Windows Short Date Format?
Title: "The Windows Short Date Revisited"
Author: Hoyt Nelson
The PBDJ June 1999 issue (Volume 6, Issue 6) contains an
excellent article which provides simple solutions to help you avoid a potential source of
bugs. Check back here soon for the online link to this article if you do not have
access to PBDJ.
PowerBuilding for the Year 2000 - It's you vs the millennium - Who's gonna win?
Title: "PowerBuilding for the Year 2000 0
It's you vs the millennium - who's gonna win?"
Author: Peter Vassilatos
The PBDJ February 1999 issue (Volume 6, Issue 2) contains an
excellent comprehensive article on Y2K. This article is available online
at http://www.sys-con.com/pbdj/feature/6-2/PowerBuildingForTheYear2000/index_a.htm
.
I have discovered a new PFC Y2K problem... What should I do?
If you know of any Y2K issues with the PFC - other than those listed in Brian Grimm's excellent PBDJ February 1999 PFC Y2K article, please either...
Post a note to the Sybase PFC Newsgroup at
news://forums.powersoft.com/powersoft.public.powerbuilder.pfc
(with a subject preferably beginning with: Y2K)or File an Electronic Case Management (ECM) at
http://support.sybase.com/cm_choice.htmlor Call Technical Support at
1-800-8SYBASEor Email a note to a PFC Mail List such as
mailto:pfcsig@rssi.com
(again, with a subject preferably beginning with: Y2K)or Feel free to write me at
mailto:"Sharon Weinstrom Buntz" <sbuntz@texas.net>Your help is greatly appreciated.
Are there any PB/PFC Y2K Tools available?
Y2K Code Analysis, That's just ONE of
the many amazing things that this slick product has to offer. Download a free trial copy today! PB Code
Analyzer http://www.AscensionLabs.com/pbcodeanalyzer.htm
. Also check out their Y2K page at http://www.AscensionLabs.com/pbt_pby2k.htm
.
PB/2000, Worried about The Year to
come? Check out this PowerBuilder Year 2000 analysis software today! John Olson
rates it the most sophisticated tool for PB Y2K preparation [PBDJ Feb,1999].
Work smarter, not harder... http://www.consultforte.com/pb2000.htm .
Year 2000 Live Training, Check out
Developower's Year 2000 live training at http://www.developower.com ... Are You Prepared for
Y2K?
Migration Assistant, free, Don't forget about this super-search tool that you already have at your fingertips. (Included with PowerBuilder 6.0) If you are not willing to spend any extra money, at least take a few hours to scan your application with the Migration Assistant. As John Olson says, "Those few hours might open your eyes to problems you didn't think you had."
The official Y2K Toons can be found at <g>
http://www.glasbergen.com/y2k.html
And the official Philosopher of the New Millennium can be found at
<s>
http://www.glasbergen.com/images/2000n.gif
<JOKE> Programmer A to Programmer B: "Why 2K? Don't worry, technically that means that we have 48 more years until we have to have our code fixed." </JOKE>
|
...PFC 7 Release Notes:
PB 7.0.2
| PB 7.0.1
| PFC 7.0 + PB 7.0
...PFC 6 Release Notes: PFC 6.5.1 +
PFC 6.5.1 Y2K + PB 6.5.1 | PFC 6.5 + PB 6.5
| PFC 6.0 + PB 6.0
...PFC 5 Release Notes: PFC 5.0.04 +
PFC
5.0.04 Y2K + PB 5.0.04 EBF#3 (includes Y2K fixes) + PB 5.0.04
...PFC 5 Release Notes: PFC 5.0.03 + PB 5.0.03 | PFC 5.0.02 | PFC
5.0.01
...PFC/PB Release Downloads: Maintenance Downloads
...PFC Upgrade Check List: Cheat Sheet Upgrade
Check List | PFCGuide
Migration Check List | Faxback #44505
...PFC/PB
Y2K FAQ
PowerBuilder Foundation Class (PFC) Y2K 5.0.04\6.5.1
Fixes
==========================================================
The Y2K patches are delivered as a complete set of PFC libraries (including extensions).
If you are already using PFC you should replace only your main PFC libraries and not your
extension libraries.
For example:
Version 5.0.04:
Replace pfcapsrv.pbl, pfcdwsrv.pbl, pfcmain.pbl, pfcwnsrv.pbl
Version 6.5.1:
Replace pfcapsrv.pbl, pfcdwsrv.pbl, pfcmain.pbl, pfcwnsrv.pbl, pfcutil.pbl
If an attempt to fix these Y2K issues has been made by overriding these PFC functions in
your own customized extension layer, first compare the official fixes with your own
changes. Remove the overriding functions in your customized extension layer only if they
address the fixes included in this set of Y2K patches.
For example: a Y2K issue is addressed by modifiying n_cst_datetime and overriding the
function of_lastdayofmonth. After the patches are applied,
pfc_n_cst_datetime::of_lastdayofmonth now includes these changes, therefore
of_lastdayofmonth in n_cst_datetime should be removed from your customized extension
layer.
After applying the Y2K patches, it is advised to perform a Full Rebuild of the
application.
-----------------------------------------------------------
Object: pfc_n_cst_datetime DateTime Service
CR169790
Method: of_lastdayofmonth
Fix: Removed a loop which relied on an invalid date.
Added an array containing the number of days in each month.
Fix Release: 7.0GA, 6.5.1(y2kpatch), 5.0.04(y2kpatch)
CR162134
Method: of_relativemonth
Fix: Removed a loop which determined the last day in month.
The loop was relying on the of_IsValid(date) function to find an invalid date. In PB
5.0.03+ a date variable can only contain a Null or a valid date.
Fix Release: 7.0GA, 6.5.1(y2kpatch), 5.0.04(y2kpatch)
CR188246
Method: of_relativeyear
Fix: Removed a loop which determined the last day in month.
The loop was relying on the of_IsValid(date) function to find an invalid date. In PB
5.0.03+ a date variable can only contain a Null or a valid date.
Fix Release: 7.0GA, 6.5.1(y2kpatch), 5.0.04(y2kpatch)
=========================================================
Object: pfc_u_calendar Drop Down Calendar
CRs 162134 and 184373
Method: of_drawmonth
Fix: Did not redraw date of 1/1/1900. Removed an invalid comparison to
date(50/50/1900)). The comparison is no longer needed. Post 5.0.03
PowerBuilder date type cannot contain an invalid date with an exception of a null value.
Fix Release: 7.0GA, 6.5.1(y2kpatch), n/a for 5.0
CRs 162134 and 184373
Method: of_setdate
Fix: Add code to always redraw for date matching 1/1/1900 to allow date display for
January 1900. Previously the calendar did not redraw since the initial value of the
previous date was also 1/1/1900.
Fix Release: 7.0GA, 6.5.1(y2kpatch), n/a for 5.0
CRs 162134 and 184373
Method: of_reset
Fix: If the date is invalid set the calendar date to today's date.
Fix Release: 7.0GA, 6.5.1(y2kpatch), n/a for 5.0
8-) ~~ Special thanks to John Olson, Brian Grimm, Yogesh Thakare, Tamara Loose, Sheldon Funk, Soundararajan Nandini and Babu Vijaya for inspiring this write-up
8-) ~~ And thanks to Daniel Griffith for helping to keep it updated
Someone please correct me if you think I could be wrong on any of these, or if you have any new PB/PFC Y2K information. Appreciate it... mailto:"Sharon Weinstrom Buntz" <sbuntz@texas.net> Thanks!
|