uncommited read

Database

uncommited read

Hi .. i am very nre to teradata....

I want to know as in db2 we give "with UR" thing at end of select statement to read uncommited data..is there is simillar thing in teradata...

Thanks
sandeep
3 REPLIES
Teradata Employee

Re: uncommited read

Hello,

If the data is being loaded/inserted in Teradata Table, you can read it using ACCESS lock. Following is an example:

LOCKING TABLE Table1 FOR ACCESS
SELECT * FROM Table1;

Regards,

Adeel

Re: uncommited read

I do not know whether data will be inserted/loding at same time....
Teradata Employee

Re: uncommited read

Use LOCKING ROW FOR ACCESS prefix in Teradata to obtain essentially the same behavior as WITH UR suffix in DB2. Or for either database, you can set your driver/connection options.