systemidotnet mailing list

Re: ASNA Visual RPG

jlowary@xxxxxxxx (Lowary, Jim) — Mon, 19 Dec 2011 14:05:53 GMT

Mark, We've been using AVR for a little over a year now. What our .Net people do is pass me a C# (.Net) object, as you can tell I lean more to the RPG side of things. From that object I add/update the date on the iSeries. I have several methods that the .Net folks call for different functions, get specific data, add records, etc. I basically either use their object for my input or I return a predefined object or one they use in their system, filled out with the iSeries data. Only problems I have run across ...

Re: ASNA Visual RPG

mwalter@xxxxxxxxxxxxxxx (Mark Walter) — Mon, 19 Dec 2011 01:39:10 GMT

Re: ASNA Visual RPG

mike@xxxxxxxxxxxx (Mike Wills) — Sun, 18 Dec 2011 03:21:52 GMT

Re: Memory file

richard@xxxxxxxxxxxxxxx (Richard Schoen) — Sat, 17 Dec 2011 18:27:29 GMT

Michael, Would be interested in seeing a small code snippet of how that works. Regards, Richard Schoen RJS Software Systems Inc. Where Information Meets Innovation Document Management, Workflow, Report Delivery, Forms and Business Intelligence Email: richard@xxxxxxxxxxxxxxx Web Site: http://www.rjssoftware.com Tel: (952) 736-5800 Fax: (952) 736-5801 Toll Free: (888) RJSSOFT -----Original Message----- Another way to handle this is with a memory file. These are specific to ASNA, and similar to a Dataset/Datat...

Re: ASNA Visual RPG

richard@xxxxxxxxxxxxxxx (Richard Schoen) — Sat, 17 Dec 2011 18:25:00 GMT

Mark, My understanding is that the VRPG software has its own data layer. Are you planning to use the ASNA's RPG or write something custom in VB.Net/C# ? If they are using full-on VRPG I would see what they offer in their stuff first. Also, what type of app ? In .Net you would typically use SQL to update records in the database in .Net depending on your apps functionality. VRPG probably has some functionality similar to CHAIN/READ/WRITE/UPDATE already built in to its language. Where it probably gets a little...

Memory File

snyirm@xxxxxxxxxx (snyirm) — Fri, 16 Dec 2011 19:57:15 GMT

Another way to handle this is with a memory file. These are specific to ASNA, and similar to a Dataset/Datatable with one exception. You can handle them just like any other DB2 or SQL file using opcodes of read, setll or chaining for instance. Michael J. Snyir System Analyst Toledo Molding & Die, Inc. 1429 Coining Toledo, Ohio 43612 419-470-3975 419-470-3950 ext. 3975

ASNA Visual RPG

mwalter@xxxxxxxxxxxxxxx (Mark Walter) — Fri, 16 Dec 2011 19:37:08 GMT

Hello all, I'm at a client that is using ASNA VRPG for .Net. I have been tasked to create a data access layer over their database in order to streamline some of their web development. My question to you is how would you implement the Add/Update functions of a data class. I thought about passing a .Net datatable back to the procedure and write/update from that, but I was wondering if anyone has any more elegant solutions. Thanks, Mark Mark Walter Business to Business Data Integration Specialist Certified IBM...

I have created an IBM i to C# Database Class

mike@xxxxxxxxxxxx (Mike Wills) — Fri, 09 Dec 2011 20:24:44 GMT

I got sick and tired of typing (or copy-pasting) the following code for every data access method: public Customer GetUtilityBillCustomer(int id) { #region SQL Statement StringBuilder sb = new StringBuilder(); sb.Append("SELECT ACUSTN, AWEBPN, ANAME, AADD1, AADD2, ACITY, ASTATE, AZIP5, AZIP4, AEMADR, ALOCAT, "); sb.Append("(TRIM(WTMETER.MADRSN) || ' ' || TRIM(WTMETER.MADRSA) || ' ' sb.Append("(AARR1 + AARR2 + AARR3) AS BALANCE "); sb.Append("FROM WTCUST, WTMETER "); sb.Append("WHERE ALOCAT = MLOCAT AND ACUST...