All Forums Database
mahabunta 3 posts Joined 08/08
22 Aug 2008
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...Thankssandeep

Adeel Chaudhry 773 posts Joined 04/08
22 Aug 2008

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 ACCESSSELECT * FROM Table1;Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

mahabunta 3 posts Joined 08/08
22 Aug 2008

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

Fred 1096 posts Joined 08/04
22 Aug 2008

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.

You must sign in to leave a comment.