Title Bar Menu

"Cheat Sheet" for PowerBuilder/PFC "Help"

PFC/PB Y2K FAQ


Congratulations to you on a job well done!  Here's to you... The Heroes of Y2K


Table of Contents

  1. Where are the PFC Y2K Fixes?
  2. Where is the official PB Y2K Info?
  3. Does that mean PB and PFC 5.0.04 also need Y2K patches?
  4. Does that mean PB and PFC 6.5 also need Y2K patches?
  5. Does that mean PB 7.0 also needs Y2K patches?
  6. Can you still use the PFC 6.5.1 Special Y2K Maintenance Release without going to PowerBuilder 6.5.1?
  7. Why is PowerBuilder's Describe returning a Two-Digit Date?
  8. What is the problem with using the Windows Short Date Format?
  9. PowerBuilding for the Year 2000 - It's you vs the millennium - Who's gonna win?
  10. I have discovered a new PFC Y2K problem...   What should I do?
  11. Are there any PB/PFC Y2K Tools available?
  12. Y2K Fun
  13. PFC Y2K Special Release Notes

Where are the PFC Y2K Fixes?

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.)


[
Back to Top] [Sybase Downloads]

 

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.zip
pb65hp1146.tar.Z +
651pfcy2k.tar.Z
pb65aix1146.tar.Z +
651pfcy2k.tar.Z
pb65solaris1146.tar.Z +
651pfcy2k.tar.Z
PowerBuilder 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)

 

[Back to Top] [Sybase Downloads]

 

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.

[Back to Top] [Sybase Downloads]

 

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.

[Back to Top] [Sybase Downloads]

 

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.

 

[Back to Top] [Sybase Downloads]

 

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".

 

[Back to Top] [Sybase Downloads]

 

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

 

[Back to Top] [Sybase Downloads]

 

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.

 

[Back to Top] [Sybase Downloads]

 

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 .

 

[Back to Top] [Sybase Downloads]

 

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.html  

or Call Technical Support at
1-800-8SYBASE

or 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.

 

[Back to Top] [Sybase Downloads]

 

Are there any PB/PFC Y2K Tools available?


Click Here to visit our sponsor - PB Code Analyzer

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

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 .


Ad_Banner_Developower_Y2K_prev98.gif (2461 bytes)

Year 2000 Live Training, Check out Developower's Year 2000 live training at http://www.developower.com ...  Are You Prepared for Y2K?  Take the QUIZ!


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."

 

[Back to Top] Sybase Downloads]

 

Y2K Fun

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>

~ an sb original merci <sb>

dart.gif (863 bytes) More Y2K Fun here!

 

[Back to Top] [Sybase Downloads]

 

...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


PFC Y2K Special Release Notes

[Official place for PFC 6.5.1/5.0.04 Y2K Special Release Notes:  pfcy2k.txt from PFC Y2K Download]
[Sybase Downloads]

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

 

[Back to Top] [Sybase Downloads]

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!

 


 

Click Here to visit our sponsor - DW Book

Visit our sponsors

Click Here to visit our sponsor - XPEDITER/SQL

 

Go to Home Page Home

Where to Go Know where to go

Site Map Work smarter, not harder

Search Answers at your fingertips

   Turn Off MenuTurn On Menu  Contact WebmasterYour Comments   Your New Home

 

Cheat Sheet for PFC/PB Help Home  |  Top