now, I also have a question :
We are using db2 udb on windows and stored proc in sql language.
we can (in V8) call set_routine_opts to force a specific datetime setting at build of stored proc.
Is there any possibility, by mean of programming, to change the dateformat while executing the stored proc or do we have to use a function as to_date(.. ?
Anyone any hint for this ?
Best Regards, Guy Przytula

The datetime format is a 'property' of the associated package. So I very much doubt if this property can be changed at bind time ...

How you hadle will depend on the requirement .... See if the date time formats supported in CHAR and TO_CHAR functions is of any help

Sathyaram