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

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  


Which transaction use a command thread ?

1 Answers  


Compare a subselect to a join?

1 Answers  


Is db2 a mainframe database?

0 Answers  


What is the physical storage length of date data type?

0 Answers  


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,


What is scrollable cursor in db2?

0 Answers  


In terms of DB2 indexing, what is the root page?

1 Answers  


What is a cursor and what is its function?

2 Answers  


What is the difference between bind and rebind in db2?

0 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


Categories