What is the SQL Communications Area and what are some of
its key fields?
Answer / s
SQLCA is a collection of variables that is updated after
the execution of the SQL statment.
The values in these variables tells if the SQL completed
successfully or not and for testing specific error
conditions.
SQLCODE, SQLSTATE, SQLERRD(3)
| Is This Answer Correct ? | 1 Yes | 0 No |
what's the error code for Unique Index Violation?
what is a trigger and types of triggers
Explain various types of locks in db2?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What are concurrency issues?
what is the Foreign key? explain?
What is a collection in db2?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is the difference between primary key & unique index ?
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
What is rct?
What is a page?