what are the SQL codes u freequently got?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are foreign keys in db2?

616


What types of tables are there in the db2 database?

559


What is meant by union and union all?

591


Can you use max on a char column?

640


What is runstats utility in db2?

569






What is plan in cobol db2?

595


Before you give the explain statement, what are the prerogatives?

581


What is a storage group (stogroup)?

778


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1238


What is the maximum size of a char data type in db2?

588


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

646


Explain what are the various isolation levels possible?

610


What are packages in db2?

599


What is commit in db2?

596


What is a collection in db2?

584