Doug Doole wrote:
> This sort of function has been a popular request and we're adding it
in
> a future version of DB2. For now, Serge's SQL function is the easiest
> thing to do.
> --
> __________________________________________________ ___________________
> Doug Doole
> DB2 Universal Database Development
> IBM Toronto Labs
>
> Visit the DB2 UDB and DB2 Connect Online Support site at:
> http://www.ibm.com/software/data/db2...s2unix/support

that was 3 (three) years ago. i've run into some old VSAM->DB2
converted data (& ass. COBOL programs) which store dates this way.
this functionality in DB2/SQL would be welcome, since these guys
don't like functions or triggers (too much to remember in
managing DDL).

any time soon?? i'm on 390/V7 & UDB/v8.2

gnuoytr@rcn.com wrote:
> Doug Doole wrote:
>
>>This sort of function has been a popular request and we're adding it
>
> in
>
>>a future version of DB2. For now, Serge's SQL function is the easiest
>>thing to do.
>>--
>>________________________________________________ _____________________
>> Doug Doole
>> DB2 Universal Database Development
>> IBM Toronto Labs
>>
>>Visit the DB2 UDB and DB2 Connect Online Support site at:
>>http://www.ibm.com/software/data/db2...s2unix/support
>
>
> that was 3 (three) years ago. i've run into some old VSAM->DB2
> converted data (& ass. COBOL programs) which store dates this way.
> this functionality in DB2/SQL would be welcome, since these guys
> don't like functions or triggers (too much to remember in
> managing DDL).
>
> any time soon?? i'm on 390/V7 & UDB/v8.2
>
Is that what you're looking for?

VALUES INTEGER(CURRENT DATE);

The function was added in V8.1 GA mostly for MDC.

Cheers
Serge

Serge Rielau wrote:
> gnuoytr@rcn.com wrote:
> > Doug Doole wrote:
> >
> >>This sort of function has been a popular request and we're adding
it
> >
> > in
> >
> >>a future version of DB2. For now, Serge's SQL function is the
easiest
> >>thing to do.
> >>--
>
>>________________________________________________ _____________________
> >> Doug Doole
> >> DB2 Universal Database Development
> >> IBM Toronto Labs
> >>
> >>Visit the DB2 UDB and DB2 Connect Online Support site at:
> >>http://www.ibm.com/software/data/db2...s2unix/support
> >
> >
> > that was 3 (three) years ago. i've run into some old VSAM->DB2
> > converted data (& ass. COBOL programs) which store dates this way.
> > this functionality in DB2/SQL would be welcome, since these guys
> > don't like functions or triggers (too much to remember in
> > managing DDL).
> >
> > any time soon?? i'm on 390/V7 & UDB/v8.2
> >
> Is that what you're looking for?
>
> VALUES INTEGER(CURRENT DATE);
>
> The function was added in V8.1 GA mostly for MDC.
>
> Cheers
> Serge

if only it were on the 390.

(and if you've any pull at all with Google, get rid of the new
Groups page. pitiful.)

gnuoytr@rcn.com wrote:
> (and if you've any pull at all with Google, get rid of the new
> Groups page. pitiful.)
>
No request for world peace?
You will never become Miss/Mr World that way....

Cheers
Serge

"Nobody likes a change, but a wet baby"

Even I have been facing problems with postings lately. But, then you
need to understand that nobody becomes a good manager the very moment
he gets out of mom's womb..... it takes him years. so relax and give
these google guys some space to breath, after all, they spent so much
resources, time, energy to reach here.

regards,
dotyet