After completing this course, the user should be able to:

 

	Explain how MAINTAIN is used for database maintenance
	Identify MAINTAIN language standards and concepts
	Develop a fully functional MAINTAIN procedure that performs maintenance functions for a database
	Modify a MAINTAIN procedure to include a grid so that multiple rows of data can be updated at once
	Identify additional commands that are useful when developing MAINTAIN procedures

Course Overview
Provides an introduction to the MAINTAIN facility. Explains the databases used in the course.
 

	What Is MAINTAIN? Purpose of the MAINTAIN facility. Similarities and differences between MAINTAIN and MODIFY.
	Course Databases and Conventions Databases referenced in the course. Course conventions.

Basic MAINTAIN Procedures
Provides information about basic MAINTAIN procedures.
 

	MAINTAIN Standards Language standards for coding MAINTAIN commands.
	Stack Concepts Purpose and use of the stack in MAINTAIN procedures.

Developing Screens
Discusses how to develop screens using the MAINTAIN facility.
 

	Initial Steps Initial steps in creating a MAINTAIN procedure, including starting MAINTAIN and completing dialog boxes. Purpose and functions of a Winform.
	Winform Properties Completing the Winform Properties dialog box.
	Create Field Completing the Create Field dialog box.
	Button Completing the Button dialog box.

Developing Cases
Covers how to develop Case code using the Cases dialog box.
 

	ADDPROD Creating the Case code for an Add button.
	CHGPROD and DELPROD Creating the Case code for a Change button and a Delete button.
	FWDPROD and BWDPROD Creating the Case code for a Forward button and a Backward button
	ENDPROD and TOP Creating the Case code for a Quit button and the TOP Case.

Using a Grid
Explains what a grid is and how a grid is used. Shows how to create a grid in a MAINTAIN procedure.
 

Stack Editor Completing the Grid dialog box.

Other Topics
Covers additional commands useful when coding MAINTAIN procedures.
 

Additional Commands Purpose and format of several other commands that can be used in MAINTAIN procedures: COMMIT, CALL, INFER and COMPUTE, STACK SORT, STACK CLEAR, COPY, NEXT, MATCH, REPOSITION, BEGIN and ENDBEGIN, and TYPE.