what's the error code for Unique Index Violation?
- 2 Answers
- 7577 Views
- I also Faced
- E-Mail Answers
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 |
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Which one allows duplicate values Union or Union All ?
What is the difference between plan and package in db2?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
How to get the ddl of a table in db2?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is dynamic SQL?
what is static sql? what is dynamic sql? Give me details
What is meant by repeatable read?
how can u retrieve the data from null values using applicaion program.
COBOL 
