Net.Data Power (Audio Training)

Course Description:
Net.Data Power is a self-paced audiocassette course designed to provide AS/400 Web site designers and programmers with essential skills for using Net.Data. Course software includes all example HTML, Net.Data macros, database files, and OS/400 program source and a ready-to-go guest book application with native interface.

Time required: Approximately 12 hours

When you have completed of this course, you will be able to:
   • Configure Net.Data to run under the IBM and I/NET servers
   • Configure the Net.Data Initialization (.INI) file
   • Code static and dynamic HTML macros
   • Customize 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

Audience: Web Designers and Programmers

Prerequisites: Some HTML experience Some SQL programming experience Client Access/400 (Windows or OS/2) experience IC/400 or I/NET Server configuration and operations experience

Course Outline:
   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

Course Details:

Level:	Advanced
Subject:	WebSphere
Length:	12 hrs.
Materials:	Seven audiocassettes; Student text; Workbook; Interactive media
Publisher:	ATS
Publish Date:	June 1998