what are the SQL codes u freequently got?
Answers were Sorted based on User's Feedback
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 |
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 |
What is cloudant database?
wht displays the number of times a query modified ?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is the SQL Communications Area and what are some of its key fields?
How would the varchar column remarks defined?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is a DBRM, PLAN ?
What does sqlcabc has?
How does DB2 determine what lock-size to use?
What are the various isolation levels possible?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Explain in detail about buffer manager and its functionalities?