Xenobiologist Posted June 21, 2011 Share Posted June 21, 2011 (edited) I 've got the following question: How to build an UDF in DB2 (e.g. 9.7 on AIX) which is able to return the working days between two dates. Somthing like this (pseudo code) float countWorkingDays(fromDate, toDate, GermanFederalState) I've got a lookup table for all the relevant holidays per state. Plus, in Autoit I can calculate all the holidays. So all I want to do is, a ) calculate the days between date a and date b b ) subtract saturdays and sundays c ) subtract all the holidays of the given state, between date a and date b d ) return the number of working days Any idea how to achieve the goal? Wrting an UDF in Java? SQL-PL? Which way would you go? Thanks in advance Mega Edited June 21, 2011 by Xenobiologist Scripts & functions Organize Includes Let Scite organize the include files Yahtzee The game "Yahtzee" (Kniffel, DiceLion) LoginWrapper Secure scripts by adding a query (authentication) _RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...) Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc. MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now