Price: $795.00 Availability: Ships within 72 hours SKU: 772
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
Net.Data Power Author: Multiple
Price: $795.00 Availability: Ships within 72 hours SKU: 772
Net.Data Power
