MVSFORUMS.com

[Rama_Prayaga]

Hello,

I have unique Index in a table, build in set of 7 coulumns.Primary key is not the part of the this unique index.

I have to insert a new row.

The the following is the steps I follow.

[SureshKumar]

Rama_Prayaga,
Why would you have two sets of 'Unique' index ? A table is normally associated with only one unique index 7 that may or may not be a primary key. A primary key in itself is unique. Though things can be manipulated technically, I would suggest a second look at the table structure - all index(s) and how they are defined. If still needed, check the SQLCA/SQLDA, the voilation on which index happened is also provided, you may interpret it know where the failure was. Thanks

[Rama_Prayaga]

Hi Suresh,

Thanks for your reply,I think I should elobrate my requirement a bit.

See, Primary key is build in the program by giving Max rows + 1,Since this key is build in another online program as well in similar fashion. There can be a dupicate error.

Now if the problem is with the Primary-key, I can create a new key by giving Max rows +1 again and insert the row.

But if it is the duplicate problem with Unique index (its is created on a set of seven columns) , then I cannot insert that (i dont have to).

I hope i put my problem cleary this time

Regards

[kolusu]

Rama_Prayaga,


The simplest way to handle such scenario's is to select before you insert a row.

1. select to see if it is a duplicate key
2. Select to see if it is the unique index defined on the seven columns.

[Rama_Prayaga]

kolusu,

Thank you for your suggestion. I have adapted you suggestion in the program.

I was thinking if SQLSTATE could help me.But I was not sure of it.

What is use of SQLSTATE .I thought it will sub classify the the SQLCODE.Please correct me I am wrong

Rama

[kolusu]

Rama_Prayaga,

Check this link for a detailed explanation of SQLSTATE

SQLSTATE

Using SQLSTATE values

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu