Interested to Buy Any Domain ? << Click Here >> for more details...
How to relege locks in fastload and multiload? example?
- 4 Answers
- 22983 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
What tools would you use for that?
What are different table types used in teradata?
What are the different table types supported by teradata?
What does sleep function does in fast load?
What are the things to be considered while creating secondary index?
Difference between star and snowflake schemas?
What is the difference between teradata and oracle?
What are the commands to make a new table, change a table and remove a table in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How to find duplicates in a table?
What is oltp?
What do you mean by ttu in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Is multi insert ansi standard?
What is the basic syntax for teradata select statement?
