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 db2 restart?
How would one remove old reorg information from the DB2 catalog?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is check constraint. Explain with example.
Which components manage deadlocks in db2?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is db2 stogroup?
Can we insert update delete in view?
What is ACQUIRE/RELEASE in BIND?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is normalization and what are the five normal forms?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.