what's the error code for Unique Index Violation?
Answers were Sorted based on User's Feedback
Answer / abhishek kumar
-803 is th error code for the Unique Index Violation
| Is This Answer Correct ? | 5 Yes | 2 No |
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
wht are the restrictions for union ?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is table space in db2?
Name some fields from SQLCA.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
what is differnece between DROP TABLE & DELETE TABLE .
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is the purpose of using commit?
What is tablespace?
what is parm utility
Define predicate?