What do the initials DDL and DML stand for and what is
their meaning?
Answers were Sorted based on User's Feedback
Answer / s
Data Definition Language CREATE, ALTER, DROP
Data Manipulation Language SELECT, INSERT, UPDATE, DELETE
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / komal riaz
DDL(Data Definition Language) is used for the manipulation
of Tables in SQL. This involves three functions CREATE,ALTER
and DROP.
Whereas DML(Data Manipulation Language) is used for the
manipulation of data in the tables. This involves four basic
functions SELECT,INSERT,UPDATE,DELETE.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is host variable?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
how to resolve -811 error. give clear explination
i want to maintain uniqueness on pdf without make lf??????????
What is a NULL value? What are the pros and cons of using NULLS?
I use CS and update a page. Will the lock be released after I am done with that page?
What can the Locate option of the Repair Utility accomplish?
What is with ur in db2?
Explain in brief how does db2 determine what lock-size to use?
Define declaration generator (dclgen).
What is UNION,UNION ALL?