When you have trouble connecting with DataGate for IBM i (especially for new or upgraded installations) the first thing you check is the IP address and the TCP/IP port. This article shows a good way to do that. DataGate for IBM i needs a TCP/IP port to work. By default, DataGate uses port 5042, but […]
The ASNA WebPak is the DataGate client for Windows Servers. It is to Windows servers what the Client Deployment binary is to Windows clients. The WebPak should be installed on any Web server on which you’ve deployed an AVR ASP.NET Website/Web services or Monarch migrations. Installing WebPak is very simple; you just run the WebPak’s […]
Finding records where a field contains a given value is an awkward thing to do with RPG’s record-level access. In either green-screen RPG or ASNA Visual RPG (AVR), the ugly solution is simple, loop over every record in the file checking each field as you go. This works, but have something nearby to keep you occupied while you wait. This article provides an alterative to that record level access using AVR for .NET’s Open Query File.
Please read these instructions completely to ensure a successful co-existing install of ASNA DataGate for IBM i. If you have any questions, please contact us at firstname.lastname@example.org or give us a call before you start your installation. You can install DataGate while another instance is running, but if possible, we recommend the orderly shutdown of existing […]
This article provides a potential way to identify orphan IBM i jobs as a result of Database connection leaks in ASP.NET Web applications. We’ve written before about the perils of orphan IBM i jobs before. This article and video discusses a potential way to identify orphan IBM i jobs and this older article also discusses techniques for avoiding […]
This article explains how to change the TCP/IP port that DataGate uses. See this article for a list of other articles that may be helpful for this task Why would you ever want to change the TCP/IP port? In normal circumstances, you’d generally not ever need to do this. However, consider the scenario of updating […]
This newsletter features a Web site that every IBM i manager should read, an upcoming Webcast, some programming tips, a cool new Windows utility, and a great book deal. Happy Holidays All of us at ASNA wish you and yours the happiest of holidays and a very good new year! Take your RPG programs from green […]
Issue: #3/2021 A tip for changing your application’s database name at runtime and a refreshed version of DataGate for IBM i 16.x are featured in this issue of the ASNA Pipeline. Change an app’s DB name at runtime — without recompiling This article shows how to change a Web or Windows application’s database name at runtime, […]
I’ve seen some crazy code lately that enables the ability to change an application’s database name at runtime. Much of the code I’ve seen makes this way harder than it needs to be. This article provides a simple way to be able to dynamically change your Web or Windows application’s runtime database name without recompiling […]
This article shows how to start and stop ASNA DataGate on the IBM i.