Archives of the TeradataForum
Message Posted: Tue, 15 Apr 2003 @ 01:29:47 GMT
A common approach is to create a views database. The views database has 1:1 views onto tables in another database. Each view contains a locking for access clause.
For example datbase pdata contains a table t1. The following will create a view (in a database named pdata) onto that table which enforces the locking for access.
Replace view pview.t1
These create views could be automatically generated from the dbc.tables table
Select 'Replace view pview.' || trim (both from tablename) || ' locking pdata.' || trim (both from tablename) || ' for access select * from pdata.' || trim (both from tablename) || ';' From dbc.tables Where databasename = 'pdata' and tablekind = 't';
Then point all your users at the pview database and everything should work just fine.
I hope this helps
BTW. If the loads you are talking about require exclusive access to a table then even the locking for access might cause the load task to be blocked.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|