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 can u retrieve the data from null values using applicaion program.
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What are catalog tables in db2?
what are the bind parameters?
define clustering index.
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Where could you look if you had a question about whether a column has been defined as an index?
how can u nderstand the sql stmts executed successfully or not ?
When is the results table for the query in a DECLARE CURSOR statement created?
what is the difference between where clause and having clause
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is an alias and how does it differ from a synonym?