uncommited read

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

uncommited read

Rate Topic

Display Mode

Topic Options

Author

Message

mahabunta

Posted 8/22/2008 1:20:28 AM

Forum Newbie

Group: Forum Members
Last Login: 8/22/2008 4:17:06 AM
Posts: 3, Visits: 4

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

Post #12680

Adeel.Chaudhry

Posted 8/22/2008 1:37:14 AM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 7:30:07 AM
Posts: 197, Visits: 611

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

Post #12681

mahabunta

Posted 8/22/2008 1:56:51 AM

Forum Newbie

Group: Forum Members
Last Login: 8/22/2008 4:17:06 AM
Posts: 3, Visits: 4

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

Post #12683

Fred Pluebell

Posted 8/22/2008 10:15:46 AM

Supreme Being

Group: PAC and SFT Members
Last Login: Yesterday @ 6:11:07 PM
Posts: 331, Visits: 533

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.

Post #12699

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 3 ( 3 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 12:34am