Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is the SQL Communications Area and what are some of
its key fields?



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

Post New Answer

More DB2 Interview Questions

what types of copies can be made with the COPY Utility ?

1 Answers  


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


What is the use of dclgen in db2?

0 Answers  


My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,


when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,


What is the latest version of ibm db2?

0 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,


Which transaction use a command thread ?

1 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


What is db2 bind?

0 Answers  


Categories