IBM AS400 Message Errors to show them in .NET appl
I am doing a .NET Windows application.
I am working against a DB2 AS/400 database.
I have some tables where i have put some key restrictions.
I mean, for example i have 2 fiels in a table: name and address. The name i want to be unique. This restriction has a name, for example: "Name restriction".
The problem is that when I insert a row with a name, for example "Peter" and then I try to insert another row with the same name, "Peter", the IBM database says that exists a row with the same information. This is what i want and it is okey, But the problem is that i want to capture the restriction name: "Name restriction", to show it in the .NET application.
How can I do it? Any ideas?