Re: System i DDS Files

Duane, I don't know if this will help, but I recall as I've stumbled through
.NET initially I sometimes had to set the DataSet.EnforceConstraints to
False.
Again, I'm not sure if this has any relation to what you're describing, but
it might be worth a try.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com

-----Original Message-----
Subject: [SystemiDotNet] System i DDS Files


Thanks to all that replied,

I am currently using my DDS files in my test .NET app. I use the IBM .NET
provider to connect, build the commands and place the data in a grid.
One of the problems that I have encountered was with a DDS file that has no
key. It is a historical file and we have several of these. .NET has strict
constraints on data. It did not allow me to build commands to update files
without primary keys. I wanted to add an ID column to this DDS file, but
the file must be an SQL created file to add an ID column. So, I have added
a timestamp field in the DDS and recreated the file and this works for .NET.
But the problem with this solution is that my restore process does not like
the timestamp field. When I try to restore data to the file, DB2 tries to
put the same date in every row....and that creates a duplicate key error.
I have heard that the iSeries Access for Windows V6R1 has the new .NET
Provider and works much better than V5R3.
I really didn't want to tackle the DDS to SQL conversion if I don't have to.
But if it would make the .NET coding much easier....I would do it.

Duane