View Single Post

   
  #4 (permalink)  
Old 02-27-2008, 04:14 AM
Gert van der Kooij
 
Posts: n/a
Default Re: Can CLP output be timestamped?

In article <qj9pc1hn6h0qs6a7finea76hcihlp0lb28@4ax.com>, Carl
Castrianni (flatmountains@comcast.net) says...
> When running files containing many sql statements using the db2
> command line processor, I`d like to have the output show the time that
> each sql statement was executed (so I know when they ran).
>
> Something like:
> 10:05:00 Select count(*) from .....
> 10:05:30 Select count(*) from .....
>
> Is there a way to do this? I know db2batch can do this (with SET
> TIMESTAMP) but I`d rather use db2 clp.
> Thanks!
>


db2 select current time, count(*) from ....
Reply With Quote