How to retrieve register values?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rfoyle@gmail.com - 25 Feb 2005 18:20 GMT

I want to set the transaction lock timeout, i.e., 'set current lock
timeout X', but before that I want to see if it is already set and what
the value is.

How can I retrieve this from the CLP?

Thanks,

Rich

Reply to this Message

Serge Rielau - 25 Feb 2005 18:27 GMT

> I want to set the transaction lock timeout, i.e., 'set current lock
> timeout X', but before that I want to see if it is already set and what
[quoted text clipped - 5 lines]
>
> Rich

db2 => values current lock timeout;

1
-----------
-1

1 record(s) selected.

Special registers are just normal leafs elements of expressions...

Cheers
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

rfoyle@gmail.com - 25 Feb 2005 18:49 GMT

Thanks. It was what I needed.

-R

Reply to this Message

rfoyle@gmail.com - 25 Feb 2005 18:49 GMT

Thanks. It was what I needed.

-R

Reply to this Message