|
iSeries (AS/400) Net.Data Power
Course Code: ACG3
Description
iSeries (AS/400) Net.Data Power is a self-paced, audio driven course designed
to provide AS/400 web site designers and programmers with essential skills for
using Net.Data (which comes FREE with OS/400). Using an example web site scenario,
participants will configure Net.Data, code HTML sections, present the results
of SQL queries in web pages, update database files with HTML input, call OS/400
programs, run built-in functions, and debug Net.Data applications. The course
software includes all example HTML, Net.Data macros, database files, OS/400
program source, and a ready-to-go guest book application with a native interface.
Upon completion you'll be able to:
 Configure Net.Data
to run under the IBM HTTP server.
Configure the Net.Data
Initialization (INI) file.
Code static and
dynamic HTML macros.
Customize the results
of SQL queries in web pages.
Construct complex
SQL SELECT statements dynamically.
Update DB2/400
database files with web page input.
Call OS/400 programs
and commands, and pass parameters.
Use built-in math,
substring, and other functions.
Access environment
variables.
Debug Net.Data
macros and SQL access plans.
|
Configuration
Net.Data for the IBM Server
Net.Data for the I/NET Server
The Initialization (INI) File
Net.Data Macro Structure
Comment Blocks
%HTML Blocks
%FUNCTION Blocks
%DEFINE Blocks
%REPORT and %ROW Blocks
Local and Global %MESSAGE Blocks
If-Then-Else Logic
|
Net.Data Variables
SQL Variables
Implicit Variables
Predefined Variables
Conditional Variables
List Variables
Environment Variables
User-Defined Variables
Database Access
SQL Queries
Default and Custom Reports/Tables
Commitment Control Levels
Defining HTML Input
Using the Get and Post Methods
Updating Files |
Net.Data Functions
Language Environments
Calling OS/400 Programs
Passing Parameters
Built-In Functions
Troubleshooting
SQL Codes
Server Jobs and Job Logs
Debugging a Macro
Optimizing Access Paths
|
|
|
Audience
Experienced programmers or web site developers who need or want to develop
WWW-based applications.
Reccomended Prerequisites
Some HTML experience
Some SQL programming experience
Client Access/400 (Windows) experience
HTTP Server configuration and operations experience
|
Format
Self Study Interactive
Materials
13 Audio CD's
Student Text
Workbook
Interactive Software |
Time Required
Approximately 8 Hours
Price
£ 595
|
back
|
