Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9499 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivasa yadav
DML STANDS FOR DATA MANIPULATION LANGUAGE
THE COMMANDS IN DML ARE SELECT, INSERT, DELETE, UPDATE
EX:-SELECT
1) SELECT * FROM TABLENAME;
IT WILL RETRIVE ALL THE COLUMNS.
2) SELECT EMP_ID,EMP_HLDR_NAME,EMP_AMT FROM TABLENAME;
IT WILL RETRIVE ONLY PARTICULAR ROWS.
INSERT : - IT IS USED TO INSERT THE VALUES.
DELETE : - IT IS USED TO DELETE THE ROW.
UPDATE : - IT IS USED TO UPDATE THE ROW.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the maximum size of varchar data type in db2?
What is access path in db2?
Is db2 a database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
When reorg is used?
What do you mean by storage group (stogroup)?
What is reorg and runstats in db2?
Describe major components of db2?
what is diffrence b/w file-aid tool and file-aid utility???
Mention the location where the output received from explain statement is stored.
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?
What happens in bind step in a db2 program?
What are the uses of db2 optimizer?
What is clone table?
Explain correlated sub-queries.
