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 .... |