What is the SQL Communications Area and what are some of
its key fields?
Answer / s
SQL CA is a collection of variables that is updated after
the execution of an SQL statement.
SQLCODE - SQL return code indicates if the execution was
successful or not and no data found conditions.
SQLSTATE - SQL return codes that can be used to test
specific error conditions.
SQLERRD(3)-Contains the no. of rows updated/inserted/deleted
| Is This Answer Correct ? | 2 Yes | 0 No |
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
Once you create a view, where would information about the view be stored?
What is lock escalation?
What is a result table?
If I have a view which is a join of two or more tables, can this view be updatable?
What is netezza database?
What is dynamic SQL?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Explain what are the various isolation levels possible?
What do you mean by NOT NULL? When will you use it?
How can you find out the # of rows updated after an update statement?
i want to maintain uniqueness on pdf without make lf??????????