Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: Anyone know of a 'holiday library' in db2?


    I was wondering if there's any DB2 library out there that can be used to check if the current day is a certain holiday? For example, a stored procedure / program will get a list of holidays to check for from a db table.. and return true as soon as the current day matches one of the holidays. If it gets to the end of the list and the current day is not a holiday, then it returns false. Also, Thanksgiving will be read as the 4th thurs in Nov... and needs to be read like this in the library. Someone recommended using this java library --

    Do any of you have any experience working with holidays in DB2? How would you implement this?


  2. #2
    Join Date
    Jan 2009
    Zoetermeer, Holland
    Quote Originally Posted by db2user24 View Post
    How would you implement this?Thanks!!
    Just implement that piece of java-code as a stored-procedure and/or function. See Solve common problems with DB2 UDB Java stored procedures

  3. #3
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    Another solution that has been implemented in many locations I have been is your own calendar table. This was done, because there are so many holidays and not all companies celebrate them all.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts