AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage


FREE AS/400, iSeries, and System i / iSeries Downloads
HOME >> FREE AS/400, iSeries, and System i / iSeries Downloads >> Working with Net.Data Table Functions



Working with Net.Data Table Functions
Author: Craig Pelkie


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

About this Document:

Although Net.Data will automatically generate an HTML table to display the results of an SQL SELECT statement, the default table may not have as refined a look as you want for your application. Using Net.Data table handling functions, you can access the data returned in a result set and apply your own HTML table formatting to the data.

This article describes several techniques you can use to generate your own HTML tables in Net.Data macros. Sample code is also included that you can download and work with on your system.

Download Files:

Note: The following files can be viewed in the browser by clicking the link.

Table1 - Net.Data macro code to produce a simple (unformatted) HTML table.

Table2 - Net.Data macro code to produce an HTML table using Net.Data %report block.

Table3 - Net.Data macro code to produce an HTML table using Net.Data @dtw_tb functions.

Table4 - Net.Data macro code to produce an HTML table using Net.Data @dtw_tb functions, also includes clickable link and detail Web page.

NDTableFunctions.pdf - PDF file that describes the use of the functions. (Same as the html file above.)

Note: To download these files, left-click on the link and use the browser's "file/save" menu option or right-click on the link and choose "save link as".