Interested to Buy Any Domain ? << Click Here >> for more details...
What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 4948 Views
- I also Faced
- E-Mail Answers
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 |
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What are the various locking levels available?
What are the various locks available?
Write a query to extract first 5 characters of a name in the column Stud_Name?
Which transaction use a command thread ?
Give some example of statistics collected during RUNSTATS?
Define predicate?
What is the STOSPACE Utility used for?
When is the skeleton cursor table created?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
How do you retrieve the data from a nullable column?
COBOL 
