× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. SYSTEMIDOTNET
  3. February 2009

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
From: systemidotnet-request@xxxxxxxxxxxx> Subject: SystemiDotNet Digest, Vol 3, Issue 3> To: systemidotnet@xxxxxxxxxxxx> Date: Wed, 11 Feb 2009 10:10:45 -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. System i DDS files (Kenneth Sanders)> 2. Re: System i DDS files (Mike)> 3. Re: System i DDS files (Mira, Antonio)> 4. Re: System i DDS files (Mike Cunningham)> 5. Re: System i DDS files (Maurice O'Prey)> 6. Re: System i DDS files (Mike)> 7. Calling an ServiceProgram with a returnvalue (Walter Hesius)> 8. Re: Calling an ServiceProgram with a returnvalue> (Walden H. Leverich)> 9. Re: Calling an ServiceProgram with a returnvalue (Maurice O'Prey)> > > ----------------------------------------------------------------------> > message: 1> date: Tue, 10 Feb 2009 20:37:27 +0000> from: Kenneth Sanders <duanes@xxxxxxxxxxxx>> subject: [SystemiDotNet] System i DDS files> > > Hello,> > I am working on a new project to convert business applications from green screen to .NET.> My problem is with DDS files. Has anyone crossed the path of converting their DDS files to SQL tables?> It would seem much easier to write .NET apps with SQL tables.> Are any of you using the DDS files for your .NET apps?> > Thanks,> Duane> _________________________________________________________________> Express yourself with gadgets on Windows Live Spaces> http://discoverspaces.live.com?source=hmtag1&loc=us> > ------------------------------> > message: 2> date: Tue, 10 Feb 2009 14:40:26 -0600> from: Mike <koldark@xxxxxxxxx>> subject: Re: [SystemiDotNet] System i DDS files> > Most of the apps we are writing use the DDS version of files. What kind of> problems are you having?> > -- > Mike Wills> Midrange Programmer/Analyst> http://mikewills.info> http://www.linkedin.com/in/mikewills> > > On Tue, Feb 10, 2009 at 2:37 PM, Kenneth Sanders <duanes@xxxxxxxxxxxx>wrote:> > >> > Hello,> >> > I am working on a new project to convert business applications from green> > screen to .NET.> > My problem is with DDS files. Has anyone crossed the path of converting> > their DDS files to SQL tables?> > It would seem much easier to write .NET apps with SQL tables.> > Are any of you using the DDS files for your .NET apps?> >> > Thanks,> > Duane> > _________________________________________________________________> > Express yourself with gadgets on Windows Live Spaces> > http://discoverspaces.live.com?source=hmtag1&loc=us> > --> > This is the .net use with the System i (SystemiDotNet) mailing list> > To post a message email: SystemiDotNet@xxxxxxxxxxxx> > To subscribe, unsubscribe, or change list options,> > visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> > or email: SystemiDotNet-request@xxxxxxxxxxxx> > Before posting, please take a moment to review the archives> > at http://archive.midrange.com/systemidotnet.> >> > > ------------------------------> > message: 3> date: Tue, 10 Feb 2009 15:47:04 -0500> from: "Mira, Antonio" <antonio.mira@xxxxxxxxxxx>> subject: Re: [SystemiDotNet] System i DDS files> > Duane,> > I have used .NET with AS400 files without any conversion using SQL statements in .NET. Unless there is some other advantage that you are looking for by converting DDS files to SQL tables, I am not sure I understand your question.> > Thank you,> > Antonio Mira> > > > > P Go Green! Print this email only when necessary. Thank you for helping Time Warner Cable be environmentally responsible.> > > -----Original Message-----> From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Kenneth Sanders> Sent: Tuesday, February 10, 2009 3:37 PM> To: systemidotnet@xxxxxxxxxxxx> Subject: [SystemiDotNet] System i DDS files> > > Hello,> > I am working on a new project to convert business applications from green screen to .NET.> My problem is with DDS files. Has anyone crossed the path of converting their DDS files to SQL tables?> It would seem much easier to write .NET apps with SQL tables.> Are any of you using the DDS files for your .NET apps?> > Thanks,> Duane> _________________________________________________________________> Express yourself with gadgets on Windows Live Spaces> http://discoverspaces.live.com?source=hmtag1&loc=us> -- > This is the .net use with the System i (SystemiDotNet) mailing list> To post a message email: SystemiDotNet@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,> visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> or email: SystemiDotNet-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives> at http://archive.midrange.com/systemidotnet.> This E-mail and any of its attachments may contain Time Warner> Cable proprietary information, which is privileged, confidential,> or subject to copyright belonging to Time Warner Cable. This E-mail> is intended solely for the use of the individual or entity to which> it is addressed. If you are not the intended recipient of this> E-mail, you are hereby notified that any dissemination,> distribution, copying, or action taken in relation to the contents> of and attachments to this E-mail is strictly prohibited and may be> unlawful. If you have received this E-mail in error, please notify> the sender immediately and permanently delete the original and any> copy of this E-mail and any printout.> > ------------------------------> > message: 4> date: Tue, 10 Feb 2009 15:52:41 -0500> from: Mike Cunningham <mcunning@xxxxxxx>> subject: Re: [SystemiDotNet] System i DDS files> > >From a .net perspective there is no difference. .net can use DDS created tables or SQL created tables > > -----Original Message-----> From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Kenneth Sanders> Sent: Tuesday, February 10, 2009 3:37 PM> To: systemidotnet@xxxxxxxxxxxx> Subject: [SystemiDotNet] System i DDS files> > > Hello,> > I am working on a new project to convert business applications from green screen to .NET.> My problem is with DDS files. Has anyone crossed the path of converting their DDS files to SQL tables?> It would seem much easier to write .NET apps with SQL tables.> Are any of you using the DDS files for your .NET apps?> > Thanks,> Duane> _________________________________________________________________> Express yourself with gadgets on Windows Live Spaces> http://discoverspaces.live.com?source=hmtag1&loc=us> -- > This is the .net use with the System i (SystemiDotNet) mailing list> To post a message email: SystemiDotNet@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,> visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> or email: SystemiDotNet-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives> at http://archive.midrange.com/systemidotnet.> > > ------------------------------> > message: 5> date: Tue, 10 Feb 2009 21:15:22 -0000> from: "Maurice O'Prey" <maurice.oprey@xxxxxxxxx>> subject: Re: [SystemiDotNet] System i DDS files> > Hi Duane> > As others have said there is no difference from a .NET perspective in using> DDS tables and SQL created tables (well none that anyone would really> notice, some believe SQL tables are marginally faster to access?). We have> been using DDS created tables for many years without problem.> > Possibly there is a misunderstanding in your question? If not don't worry> about converting your tables from DDS created to SQL created.> > Maurice O'Prey> > > -----Original Message-----> From: systemidotnet-bounces@xxxxxxxxxxxx> [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Kenneth Sanders> Sent: 10 February 2009 20:37> To: systemidotnet@xxxxxxxxxxxx> Subject: [SystemiDotNet] System i DDS files> > > Hello,> > I am working on a new project to convert business applications from green> screen to .NET.> My problem is with DDS files. Has anyone crossed the path of converting> their DDS files to SQL tables?> It would seem much easier to write .NET apps with SQL tables.> Are any of you using the DDS files for your .NET apps?> > Thanks,> Duane> _________________________________________________________________> Express yourself with gadgets on Windows Live Spaces> http://discoverspaces.live.com?source=hmtag1&loc=us> -- > This is the .net use with the System i (SystemiDotNet) mailing list> To post a message email: SystemiDotNet@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,> visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> or email: SystemiDotNet-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives> at http://archive.midrange.com/systemidotnet.> > > > ------------------------------> > message: 6> date: Tue, 10 Feb 2009 15:17:47 -0600> from: Mike <koldark@xxxxxxxxx>> subject: Re: [SystemiDotNet] System i DDS files> > The only place I could see where there might be confusion is that most> decimal fields in .NET is defined as decimal not int or something else. Then> you have the commonly used decimal dates... but a simple conversion method> could fix that.> > -- > Mike Wills> Midrange Programmer/Analyst> http://mikewills.info> http://www.linkedin.com/in/mikewills> > > On Tue, Feb 10, 2009 at 2:52 PM, Mike Cunningham <mcunning@xxxxxxx> wrote:> > > >From a .net perspective there is no difference. .net can use DDS created> > tables or SQL created tables> >> > -----Original Message-----> > From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:> > systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Kenneth Sanders> > Sent: Tuesday, February 10, 2009 3:37 PM> > To: systemidotnet@xxxxxxxxxxxx> > Subject: [SystemiDotNet] System i DDS files> >> >> > Hello,> >> > I am working on a new project to convert business applications from green> > screen to .NET.> > My problem is with DDS files. Has anyone crossed the path of converting> > their DDS files to SQL tables?> > It would seem much easier to write .NET apps with SQL tables.> > Are any of you using the DDS files for your .NET apps?> >> > Thanks,> > Duane> > _________________________________________________________________> > Express yourself with gadgets on Windows Live Spaces> > http://discoverspaces.live.com?source=hmtag1&loc=us> > --> > This is the .net use with the System i (SystemiDotNet) mailing list> > To post a message email: SystemiDotNet@xxxxxxxxxxxx> > To subscribe, unsubscribe, or change list options,> > visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> > or email: SystemiDotNet-request@xxxxxxxxxxxx> > Before posting, please take a moment to review the archives> > at http://archive.midrange.com/systemidotnet.> > --> > This is the .net use with the System i (SystemiDotNet) mailing list> > To post a message email: SystemiDotNet@xxxxxxxxxxxx> > To subscribe, unsubscribe, or change list options,> > visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> > or email: SystemiDotNet-request@xxxxxxxxxxxx> > Before posting, please take a moment to review the archives> > at http://archive.midrange.com/systemidotnet.> >> > > ------------------------------> > message: 7> date: Wed, 11 Feb 2009 14:34:13 +0100> from: "Walter Hesius" <walter@xxxxxxxxxx>> subject: [SystemiDotNet] Calling an ServiceProgram with a returnvalue> > Hi all,> > To call an iseries program or serviceprogram from .net, i wrap the call inside a storedprocedure, and then use that storedprocedure from my .net application.> Works like a charm, except, i can't figure out how to call a serviceprogram that has a return value.> something like this:> d DayOfWeek PR 1 0 > d InputDate D DatFmt(*iso) > For any given date, it returns the day of week as a number;> > I thought about wrapping it in a function, but i couldn't make that work.> I could of course, wrap such a function inside another storedprocedure, and add the returnvalue as an extra parameter, but i was wandering if somebody knew> howto do this.> > I find it a bit strange that it is possible to call a subprocedure inside a serviceprogram directly, but that you cannot get at the returnvalue.> Perhaps there is some way to define this in the storedprocedure, but there is so little documentation about this.> > I'm on a V5R3 machine, and i use IBM.Data.DB2.iSeries assembly.> > thanks for all replies.> > walter.hesius@xxxxxxxxx> +32 497 252 749> +32 2 335 2335> www.inxin.com> > ------------------------------> > message: 8> date: Wed, 11 Feb 2009 10:38:10 -0500> from: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>> subject: Re: [SystemiDotNet] Calling an ServiceProgram with a> returnvalue> > > I could of course, wrap such a function inside another> storedprocedure, and add the > >returnvalue as an extra parameter, but i was wandering if somebody knew> howto do this.> > That's how you do it. There is no facility to return a value from a proc> call except via an output parameter. > > Technically I guess you could also return the value as a scalar (single> row single column result set) and do an ExecuteScalar() on it, but> that's downright silly, especially considering the code the provider> goes through to handle that. ExecuteScalar does the entire proc call> including processing output parms and then goes on to open a cursor on> the result set and process the first row/column. Not the end of the> world, but silly since you're doing the output parm processing anyway.> > -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: 9> date: Wed, 11 Feb 2009 16:03:33 +0000> from: "Maurice O'Prey" <maurice.oprey@xxxxxxxxx>> subject: Re: [SystemiDotNet] Calling an ServiceProgram with a> returnvalue> > A completley silly reply ( since it doesn't answer the how to > question ) and no doubt your example is a puesdo example.> > But you can derive the week day number in .Net using something like > the thisdate.dayofweek method> > Sorry I'm on a mobile so I'm not sure of the exact syntax!> > As I said not a lot of use :-) but an interesting question you have > posed anyhow> > Maurice O'prey> > Sent from my iPhone> > On 11 Feb 2009, at 13:34, "Walter Hesius" <walter@xxxxxxxxxx> wrote:> > > Hi all,> >> > To call an iseries program or serviceprogram from .net, i wrap the > > call inside a storedprocedure, and then use that storedprocedure > > from my .net application.> > Works like a charm, except, i can't figure out how to call a > > serviceprogram that has a return value.> > something like this:> > d DayOfWeek PR 1 0> > d InputDate D DatFmt(*iso)> > For any given date, it returns the day of week as a number;> >> > I thought about wrapping it in a function, but i couldn't make that > > work.> > I could of course, wrap such a function inside another > > storedprocedure, and add the returnvalue as an extra parameter, but > > i was wandering if somebody knew> > howto do this.> >> > I find it a bit strange that it is possible to call a subprocedure > > inside a serviceprogram directly, but that you cannot get at the > > returnvalue.> > Perhaps there is some way to define this in the storedprocedure, but > > there is so little documentation about this.> >> > I'm on a V5R3 machine, and i use IBM.Data.DB2.iSeries assembly.> >> > thanks for all replies.> >> > walter.hesius@xxxxxxxxx> > +32 497 252 749> > +32 2 335 2335> > www.inxin.com> > -- > > This is the .net use with the System i (SystemiDotNet) mailing list> > To post a message email: SystemiDotNet@xxxxxxxxxxxx> > To subscribe, unsubscribe, or change list options,> > visit: http://lists.midrange.com/mailman/listinfo/systemidotnet> > or email: SystemiDotNet-request@xxxxxxxxxxxx> > Before posting, please take a moment to review the archives> > at http://archive.midrange.com/systemidotnet.> > > ------------------------------> > _______________________________________________> SystemiDotNet mailing list> SystemiDotNet@xxxxxxxxxxxx> http://lists.midrange.com/mailman/listinfo/systemidotnet> > > End of SystemiDotNet Digest, Vol 3, Issue 3> *******************************************
_________________________________________________________________
Express yourself with gadgets on Windows Live Spaces
http://discoverspaces.live.com?source=hmtag1&loc=us

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.