- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the purpose and usage of ATOMIC and NON-ATOMIC clause in multi row insert?
The ATOMIC and NON ATOMIC clauses are used with the multi-row insert. ATOMIC is always processed by default if any of the options is not given. The ATOMIC clause states that if there is a failure while inserting any one row during multi-row insertion then the entire query will be failed and all the inserts will be rolled back.
The NON ATOMIC clause is just the opposite of the ATOMIC clause. It is used when we have to insert and process all the rows individually in a multi-row insert. For example, this option can be used like below.
MOVE 50 TO MAX-ROWS EXEC SQL INSERT INTO ORDERS (ORDER_ID, ORDER_DATE) VALUES(:ORDER-ID, :ORDER-DATE) FOR :MAX-ROWS ROWS NON ATOMIC END-EXEC
- Related Articles
- What is the purpose and usage of “WHERE CURRENT OF” clause in a COBOL-DB2 program?
- What is the purpose and usage of “FOR UPDATE OF” clause in a COBOL-DB2 program
- Purpose and usage of ROW-ID and SEQUENCE in a DB2
- What are the differences between atomic and relative atomic mass?
- What is the usage of host variables in case of multi row fetch?
- What is the purpose and usage of SCROLLABLE CURSOR in COBOLDB2 program?
- What is the Atomic Number?
- In what way is the Rutherford’s atomic model different from that of Thomson’s atomic model?
- What is the atomic number of argon?
- What is atomic mass?
- What is the usage and purpose of DCLGEN and host variables used in COBOL-DB2 program
- Atomic models have been improved over the years. Arrange the following atomic models in the order of their chronological orderRutherford’s atomic modelThomson’s atomic modelBohr’s atomic model(a) (i), (ii) and (iii)(b) (ii), (iii) and (i)(c) (ii), (i) and (iii)(d) (iii), (ii) and (i)
- What is meant by atomic mass, gram atomic mass of an element? Why is the mass have different expressions i.e., ‘u’ and ‘g’?
- The atomic numbers of three elements A, B, and C are given below:Element Atomic number
- What is Rutherford's atomic model?

Advertisements