Answer Posted / deepak dada
check pending is the state in which load utility does not
check the constraint of the table
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
what is the role of the cursor in db2?
What is rct?
What is release/acquire in bind?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Explain how can you do the explain of a dynamic sql statement?
What is db2 purescale?
can all users have the privilage to use the sql statement select * (dml)?
What is the difference between cursor stability and repeatable read isolation levels?
What types of tables are there in the db2 database?
How is a typical db2 batch pgm executed?
What is the role of schema in the db2 database?