Name some fields from SQLCA.
Answers were Sorted based on User's Feedback
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
can any body explain about plan and pakage in detail....
When is the results table for the query in a DECLARE CURSOR statement created?
what is the maximum number of tables that can be joined ?
Explain in detail about buffer manager and its functionalities?
What is netezza database?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is meant by concurrency?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is null in db2?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?