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 |
On which levels locks can be applied?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is commit in db2?
What is a system catalog table in db2?
What are the full forms of spufi and dclgen and why are they used?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Are views updateable?
What is the maximum No of rows per page?
How do you insert a record with a nullable column?
How to handle null values in db2
Which component is responsible for processing sql statements and selecting access paths?