Work with Net.Data tables in RPG

Work with Net.Data tables in RPG

Terms of Use
	1.	You may freely download this file or set of files for use within your site or at your client sites.
	2.	You must keep all of the original copyrights and other notifications with all copies of the file(s) that you download from this site.
	3.	You may use any of the code or techniques described in your own programs.
	4.	You may not develop any article, publication, Web page or other document that is based entirely or substantially on any of the information or code that you download.
	5.	You may link directly to www.web400.com from any of your Web sites. Please do not link directly to internal pages on this site.
	6.	Use of any materials, files, descriptions, code, procedures, etc., that you obtain from this Web site is AT YOUR OWN RISK. DO NOT USE any of the materials, files, descriptions, code, procedures, etc., if you are uncertain what the effect might be, and if you do not have adequate backup and recovery to correct any possible problems.
	7.	I do not offer "free" support for any of the material available on this site. Consulting services are available by request for a fee.

File name: Work with Net.Data tables in RPG

Environment: Any supported Net.Data environment. AS/400: IBM HTTP Server for AS/400 (5769-DG1), V3R2, V3R7, V4Rx+.

ILE-RPG compiler (5769-RG1).

Date Posted: February 10, 2001

About this document:

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.

Link to the article:

NDTables_RPG.htm - Web page that describes how to work with Net.Data tables in an ILE-RPG program, using the functions provided in service program QHTTPSVR/QTMJLE.

Download Files:

Note: you can view the files in your browser by clicking the link. To save the file, right-click and select the "Save Target As..." option.

TBTEST.ndm - Net.Data macro code to display the table returned from the ILE-RPG program.

TBTEST.rpg - ILE-RPG program that uses functions in service program QHTTPSVR/QTMJLE to manipulate and return a Net.Data table variable.

NDLE_RPG.rpg - ILE-RPG function prototypes for the Net.Data Language Environment (LE) APIs in the QHTTPSVR/QTMJLE service program.

ErrorMsg_Block.ndm - Net.Data error message utility function.

ErrorMsg_Table.ndm - Net.Data error message utility function.

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

File name:	Work with Net.Data tables in RPG
Environment:	Any supported Net.Data environment. AS/400: IBM HTTP Server for AS/400 (5769-DG1), V3R2, V3R7, V4Rx+. ILE-RPG compiler (5769-RG1).
Date Posted:	February 10, 2001