If we execute an query in MLOAD it's ran successfully,
my questions is after successfully ran MLOAD. In error
tables we can see anything there! is it possible than what
are they?

Answer Posted / dave bruce

These tables will be dropped automatically when the sql
statement is successful in MLOAD.. MLOAD internally runs a
row count on all the tables participated before it quits
the MLOAD session.. if it finds any it will return the
error code like 8 r 12 depends on the error type..

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

1663


What is difference between clustered, non-clustered and unique index?

607


What are the disadvantages of views in a database?

542


What do you mean by database?

592


How concurrency problems effect the database?

635






what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

1887


What is ole db provider for sql server?

554


What does currency type mean in database?

720


Explain natural key?

621


Is data lake a database?

567


What is the difference between primary key, foreign key and candidate key?

648


What is the difference between data source and database?

548


Explain various types of locks in a transaction? Which is better and why?

601


Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

590


What is the difference between primary and candidate key?

578