What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 4469 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 |
can we update the table by using cursors can anyone post the query?
How could one combine a set of incremental image copies into a single copy?
What is an asychronous write?
What is ibm db2 client?
How would one remove old reorg information from the DB2 catalog?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How can you do the explain of a dynamic sql statement?
What is the difference between SYNONYM and ALIAS?
Compare a subselect to a join?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
How to get Top 10 Salaries from a Table
COBOL 
