Interested to Buy Any Domain ? << Click Here >> for more details...
How to relege locks in fastload and multiload? example?
- 4 Answers
- 23185 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
For mload,
release mload in apply can be used to forcefully remove the lock from the target table.
For fload,
Locks on target table will not be released until end loading statement completes. I hope fload should be run only with begin and end loading statements. Please add, if you find more....
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Highlight a few of the important components of Teradata?
In BTEQ, how are the session-mode parameters being set?
Where is teradata rdbms used?
Why is the case expression used in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What exactly do you know about catching in teradata?
What are the multiload utility limitations?
Explain and compare pros and cons of snow flake schemas?
Why does varchar occupy 2 extra bytes?
During the Display time, how is the sequence generated by Teradata?
What is the purpose of joins in teradata and what are the available join types?
What is primary index and secondary index?
What is a dimension table?
Did you write stored procedures in teradata?
How to view every column and the columns contained in indexes in teradata?
