System i DDS Files

Many thanks for the information from you guys.
Is there a difference in .NET between using an SQL view or a logical DDS file?

This may not be the right list to ask this question, but it does relate to my .NET project.
We always restrict the number of logicals over a physical file because it will effect the performance (index rebuilds). So, will an SQL View impact the performance of a physical file like a logical file does?

From: systemidotnet-request@xxxxxxxxxxxx> Subject: SystemiDotNet Digest, Vol 3, Issue 7> To: systemidotnet@xxxxxxxxxxxx> Date: Fri, 13 Feb 2009 12:00:02 -0600> > Send SystemiDotNet mailing list submissions to> systemidotnet@xxxxxxxxxxxx> > To subscribe or unsubscribe via the World Wide Web, visit> http://lists.midrange.com/mailman/listinfo/systemidotnet> or, via email, send a message with subject or body 'help' to> systemidotnet-request@xxxxxxxxxxxx> > You can reach the person managing the list at> systemidotnet-owner@xxxxxxxxxxxx> > When replying, please edit your Subject line so it is more specific> than "Re: Contents of SystemiDotNet digest..."> > > Today's Topics:> > 1. Re: System i DDS Files (Walden H. Leverich)> 2. Re: System i DDS Files (Elvis Budimlic)> > > ----------------------------------------------------------------------> > message: 1> date: Fri, 13 Feb 2009 12:26:00 -0500> from: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>> subject: Re: [SystemiDotNet] System i DDS Files> > 1) Use the V6R1 driver, much better.> 2) There must be some unique key, how will you know what row to update?> 3) Handle the updates yourself. The built in IO is nice the first few> times, then it tends to get in the way.> > -Walden> > -- > Walden H Leverich III> Tech Software> (516) 627-3800 x3051> WaldenL@xxxxxxxxxxxxxxx> http://www.TechSoftInc.com> > Quiquid latine dictum sit altum viditur.> (Whatever is said in Latin seems profound.)> > > > ------------------------------> > message: 2> date: Fri, 13 Feb 2009 11:26:47 -0600> from: "Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>> subject: Re: [SystemiDotNet] 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> > > > > > ------------------------------> > _______________________________________________> SystemiDotNet mailing list> SystemiDotNet@xxxxxxxxxxxx> http://lists.midrange.com/mailman/listinfo/systemidotnet> > > End of SystemiDotNet Digest, Vol 3, Issue 7> *******************************************

_________________________________________________________________
Express yourself with gadgets on Windows Live Spaces
http://discoverspaces.live.com?source=hmtag1&loc=us