One Star

how to call a sql inside java routine

I am writing a java function that computes 4 business days from current date but excludes holidays and weekends.
My date_dim table stores holidays and weekend information. I have sql's to check if it's holiday or if it's
weekend. How to use date_dim information inside my java routine?
One Star

Re: how to call a sql inside java routine

You might get the holidays and weekend information by using DB components. Then save them into an java Array or some other data pattern in tJava and pass them into this java function.
It shouldn't be hard if you are familiar with Java programming.