View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 04:14 AM
Carl Castrianni
 
Posts: n/a
Default Can CLP output be timestamped?

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!
Reply With Quote