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 are the SQL codes u freequently got?

Answers were Sorted based on User's Feedback



what are the SQL codes u freequently got?..

Answer / girish kumar

805- Token not found.
806- LOad module not found.
S013-18- Member not found.
502 - cursor not closed.
922- Authorization failed.
818 - Time stamp mismatch.
811 - Cursor not declared.
911- Dead lock
305 - Null indicator not defined.
311 - Length is not given for Var char.
S322 - Time out error.
S122 - Job canceled by the operator.
S222 - Operator cancel the job and doesn't request for dump
200 - Host variables not created.
204 - Table already crated.
551 - ID has no privileges to access the table.
803 - Index violation.

Is This Answer Correct ?    2 Yes 0 No

what are the SQL codes u freequently got?..

Answer / krishnan

-805 program is not present in the plan.
u need to compile,package and plan the program once

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


What is an asychronous write?

1 Answers  


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  


Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,


What is db2 command?

0 Answers  


How does DB2 use multiple table indexes?

1 Answers  


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


How does one remove entries from the SCT02 table?

1 Answers  


While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,


List out the buffer pools in db2

0 Answers  


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


Categories