Re: Call iSeries program from C# program

["Bob O." <otis_the_cat@xxxxxxxxxxx>]

I checked out the article.  I successfully got his little program to work 
(using the system console like he did).  I added the code to my project (a 
windows application) and it would error out on calling the program.  I 
removed all the parameters since the program I'm trying to call doesn't have 
any.

OleDbCommand cmd = new OleDbCommand("{{call dortest.OR195}}", cn);

I got the error:  Value 'DORTES.OR' for PGM exceeds 10 characters.

If I add () to the command

OleDbCommand cmd = new OleDbCommand("{{call dortest.OR195()}}", cn);

I get the error:  Keyword 'DORTEST.OR' not valid for this command.


Now why would just taking out the console.write stuff and the un-needed 
parms cause such a problem?



> From: richard@xxxxxxxxxxx
> Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Call iSeries program from C# program
> Date: Tue, 20 Feb 2007 11:58:06 -0600
>
> Yeah, except managed code doesn't always mage itself appropriately :-)
>
> I wouldn't be afraid to use the OLEDB stuff.  It works just fine and if
> you abstract your driver calls you can theoretically switch back and forth
> between drivers if really needed.
>
> Check iSeries networks .Net tips.  Pelkie published an article on this
> technique today.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> "Providing Your....iNFORMATION NOW!"
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 898-3038
> Fax: (952) 898-1781
> Toll Free: (888) RJSSOFT
> ----------------------------------------------------------------------
>
> message: 1
> date: Mon, 19 Feb 2007 17:59:47 -0500
> from: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
> subject: RE: Call iSeries program from C# program
>
> Yes, OLE/DB supported the {{CALL PGM}} syntax to make direct calls to
> programs, and I really miss that in .NET. However, I'd rather stay in
> managed code so I stick w/the .NET provider.
>
> -Walden
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.

_________________________________________________________________
Refi Now: Rates near 39yr lows!  $430,000 Mortgage for $1,399/mo - Calculate 
new payment 
http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-17727&moid=7581