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 |
i want to maintain uniqueness on pdf without make lf??????????
what is copy pending and check pending ?
How would one remove old reorg information from the DB2 catalog?
What are column-name qualifiers used?
What are some characteristics of columns that benefit from indexes?
what needs to be done if a table is in copy pending / check pending status?
What is coalesce in db2?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
Which component is responsible for db2 startup and shutdown?
Do we need cursor for Count(*)?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What parameters are used to control the free space in DB2?