Microsoft .NET, IBM WebSphere Application Server, SQL CLI, ILE RPG, HTTP Server for AS/400, RPG CGI

Available Downloads

Date Posted	Title	Description
Training Courses from Lab400.com
Microsoft .NET for RPG Programmers (Visual Basic Version)		Learn how to work with Microsoft Visual Studio 2005 to develop Visual Basic .NET applications that access your System i database. You don't need any previous experience with Visual Studio or Visual Basic, this course leads you step-by-step through a series of practical examples that work with your database.
Microsoft .NET for RPG Programmers (C# Version)		Learn how to work with Microsoft Visual Studio 2005 to develop C# applications that access your System i database. You don't need any previous experience with Visual Studio or C#, this course leads you step-by-step through a series of practical examples that work with your database.
Subprocedures for RPG Programmers		Your RPG code can now be simpler to write, easier to maintain, readily reused in new applications and truly modular with Subprocedures for RPG Programmers. This training course makes using powerful ILE RPG subprocedures easy. Using this step-by-step course, you'll learn important techniques that you'll use over and over as you create your own subprocedures.
Microsoft .NET and the System i
Nov. 2006	iSeries Access for Windows configuration for .NET development	This document shows how to install, configure and verify that you have IBM iSeries Access for Windows on your PC and ready to use for Microsoft .NET development. If you want to use the IBM iSeries Access for Windows OLE DB or .NET Data Providers with .NET applications, you can use this document to help get your PC development environment configured correctly.
ILE RPG
Sept. 2005	Practical Techniques for ILE RPG module construction	This series of articles describes some of the techniques you may want to consider when you create ILE RPG modules. The articles show how to create subprocedures that work together in a module. These techniques will help you create subprocedures and modules that can be reused in multiple projects.
WebSphere and VisualAge for Java
Oct. 2001	Using the VAJ WebSphere Test Environment	VisualAge for Java includes an optional component called the WebSphere Test Environment (WTE). Using the WTE, you can test servlets and JavaServer Pages (JSP) at your workstation, without needing to export your code to WebSphere Application Server. While running the servlet or JSP, you can step through your code.
Oct. 2001	Using the WebSphere JSP Tag Library	The JavaServer Pages (JSP) specification describes how vendors can provide "tag libraries" to extend the capabilities of JSPs hosted on their application servers. JSP tags are embedded in the source code of a JSP, and by design, look very much like HTML or XML tags. This article describes how to use the IBM WebSphere JSP tags, which let you easily access and use a database file with SQL. If you are just getting started with Java, WebSphere, or JavaServer Pages, you should start with these JSP tags. Using the JSP tags is probably the least difficult way to get dynamic web pages up and running with WebSphere.
Oct. 2001	Create Web Applications with JavaServer Pages	Seminar handout that describes how JavaServer Pages work in the WebSphere Application Server environment. This document is PowerPoint slides, so there is not a lot of writing in it, but there are some samples of JSP code to get you started.
Oct. 2001	Using JDBC with iSeries WebSphere Applications	Seminar handout that describes how to use JDBC on the iSeries 400. The document describes the two JDBC drivers provided with the iSeries 400, when and how to use each driver, how to configure WebSphere Application Server for connection pooling. Includes code samples to show how to prototype a JDBC application in VisualAge for Java, then convert the prototype to a servlet.
SQL
Sept. 2005	RPG CLI: Using SQL (ODBC) with RPG	Call Level Interface (CLI) lets you call ODBC APIs from RPG. Using CLI, you can run SQL statements and work with result sets in your RPG programs. You do not need the DB2 Query Manager and SQL Developer Kit (5722-ST1) installed on your iSeries to use CLI.
Oct. 2001	Using SQL with the iSeries 400 (lab)	This is a "hands-on" lab that shows how to use several features of the AS/400 Operations Navigator SQL support. Includes extensive review of the new Database Navigator tool and how to create various SQL related objects on the iSeries 400. Also includes examples of the various types of joins and how you can create them using the "New View" option of Operations Navigator (also includes a practical example of a "cross join", which I am indebted to a seminar attendee for pointing out to me). Note: this lab requires the V5R1 version of AS/400 Operations Navigator, OS/400 V5R1, and the SQL Developer's Kit (5722-ST1).
Net.Data articles
April 2000	How to Get AS/400 Net.Data Up and Running	Document that describes how to configure IBM HTTP Server for AS/400 (OS/400 V4R3 and higher) to provide an environment for AS/400 Net.Data. Use this as a "first step" if you do not already have IBM HTTP Server for AS/400 configured.
April 2000	Net.Data Table Functions	Document that shows and describes how to work with Net.Data table functions. Use the Net.Data table functions to improve the appearance of HTML tables generated by Net.Data. Also shows how to create a clickable link from a table item to a detail Web page.
Sept. 2000	Using Stored Procedures with Net.Data	As an alternative to coding SQL statements directly in your Net.Data macros, you can call AS/400 stored procedures. Using stored procedures, you can access secured AS/400 resources, modularize your Net.Data applications, and use traditional AS/400 programming resources effectively with your Web applications. Includes sample Net.Data macro and RPG code.
Sept. 2000	Using "subfiles" with Net.Data	One of the most frequently asked questions about Net.Data is, how do I generate a multiple page listing, so that I can control the number of items displayed per Web page? This article shows how to use Net.Data functions to specify the number of items displayed per page, how to navigate forward or backward in the display, and a sample navigation scheme to help your users. Includes Net.Data macro code.
Feb. 2001	How to update files using Net.Data	Although it is very easy to write Net.Data macros to for database inserts and inquiries, updating through Net.Data requires some additional code. This article shows an example of how to retrieve a record from a database file, present the record for update, then perform an update of the record. Includes Net.Data macro code.
Feb. 2001	Work with Net.Data tables in RPG	One of the features that makes Net.Data easy to work with is that it automatically creates and processes a table (result set) when you run an SQL SELECT statement. In some cases, it may be difficult to get the data you want with SQL and format it with Net.Data. Using a Net.Data table variable, you can fill the table in your RPG program with data and return it for processing to your Net.Data macro.
Feb. 2001	Create dynamic Web graphics with SVG	This is very hot stuff! Scalable Vector Graphics (SVG) is a new graphics markup language implemented using XML. Using SVG, you can create dynamic, data-driven graphics, rather than try to display data using other types of Web graphics files. This article shows how to generate SVG from a Net.Data macro. The technique can be applied to any Web programming language.
April 2001	Handling errors in Net.Data macros	If you don't provide your own error handling in Net.Data macros, Net.Data will simply display its own message and end your macro. Use the techniques described in this article to create your own error handlers, and download and use the ErrorMsg_Table.ndm file to provide complete error information for your macros.
Oct 2001	"You've got mail" with Net.Data	The @dtw_sendmail Net.Data function provides an easy to use technique to send e-mail messages from a Net.Data macro. The function uses the AS/400 SMTP server to send the e-mail message.
Oct 2001	Net.Data seminar materials	Collection of Net.Data seminar handouts. Most are collations of other materials on this site, but are good overview material if you just want to get a quick idea of some of the features of Net.Data. The lab handout is especially good, and is a good "hands-on" introduction to getting Net.Data configured and working on your iSeries 400.
RPG CGI programming
Feb. 2001	Using RPG-CGI for Web Enablement	If you use RPG as your programming language for the AS/400 system, you can create CGI programs to work with Web forms. This article, adapted from seminar materials, describes the basic concepts of CGI processing and includes ILE RPG code samples of a complete, working RPG-CGI program. The code sample shows how to use the QzhbCgiParse API, which is a more powerful API than the obsolete QtmhRdStin and QtmhCvtDb APIs.
Web server & development
April 2000	HTML for DDS Programmers	If you want to create usable and useful Web based forms to take the place of your DDS Display File applications, you will need to know how to work with HTML form elements. This document describes the commonly used HTML form elements you will use to create Web based data entry forms.
April 2000	JavaScript for DDS Programmers	If you want to create Web forms that edit data fields at the browser, you will need to use a scripting language with your HTML. This document and sample code shows how to attach field-level edits to browser fields and display error messages to the user.
April 2000	Six Cool Things you can do with IBM HTTP Server for AS/400	Alright, so the title's lame, but here is a description of six configuration options you can use with IBM HTTP Server for AS/400 that will add to its functionality.
Nov. 1997	WRKHTTP	Command to edit, print, and backup the AS/400 HTTP server configuration file.
AS/400 TCP/IP
June 1998	TCP400	Document describing configuration of TCP/IP on AS/400 (through V4R1). Also includes information on Windows NT Server DNS, DHCP and WINS servers.
March 1998	FTPEXIT	Exit Point program for FTP and FTP Server Logon. Can be used to secure FTP Server, FTP Client, REXEC Server, TFTP Server, FTP Server Logon and REXEC Server Logon. All accept/reject options are set externally to the program.
Windows NT Server & AS/400
April 2000	Using MQSeries for AS/400 to NT Server Applications	Document that describes the basics of IBM MQSeries and how the product can be used for server-to-server applications with an AS/400 system and a Windows NT Server. If you are developing cross-platform Web applications using the AS/400 system and Windows NT Server, MQSeries should be one of the products you consider for your application infrastructure.
June 1998 Updated April 2000	ASP400	Example of Windows NT Server Internet Information Server (IIS) Active Server Page (ASP) to AS/400. Requires Client Access V3R1M3 (or V3R2M0 or Client Access Express), Windows NT Server 4.0, Microsoft Internet Information Server 3.0, 4.0 or 5.0. Also includes a document describing the source code and configuration steps.


	Craig Pelkie Bits & Bytes Programming, Inc. craig@web400.com