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 |
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can we read records for specific member in CL? AND rpg?
how can we retrieve the 100 records of the file ?
In which column of which DB2 catalog would you find the length of the rows for all tables?
select 100 records from million records ?
What will happen, while trying to close the closed cursor.
What technique is used to retrieve data from more than one table in a single SQL statement?
What is ALTER ?
What information is contained in a SYSCOPY entry?
How do we specify index to include or not during bind process.
How many buffer pools are there in DB2?
Name the different types of Table spaces.