Interested to Buy Any Domain ? << Click Here >> for more details...
what are the SQL codes u freequently got?
- 2 Answers
- 7517 Views
- Logica CMG, I also Faced
- E-Mail Answers
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 |
how to resolve -805. give clear explination for that
Outputs of explain are with matchcols = 0. What does this signify?
How many Buffer pools are there in DB2 and what are they?
Explain in brief how does db2 determine what lock-size to use?
What is bind in db2?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is a result table?
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?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the difference between db2 and oracle?
How do you define a correlated name?
What is database reorganization?
COBOL 
