HP 3000 Manuals HP 3000 Manuals
Table of Contents
HP ALLBASE/4GL Developer Self-Paced Training Guide
HP ALLBASE/4GL Developer Self-Paced Training Guide : COPYRIGHT NOTICE
Ch 1. Getting Started
Training Overview
How Does HP ALLBASE/4GL Work?
HP ALLBASE/4GL System
The Operating System Interface
Data Manager
Administrator
End User Applications
Developer
How the HP ALLBASE/4GL Developer Works
The Application You Will Create
How the Application Will Work
Application Structure
Before You Begin
Choosing a Data Manager
Ch 2. Planning and Defining Your Application
Working with HP ALLBASE/4GL
Phase 1--Application Planning
Some Rules of Thumb for HP ALLBASE/4GL Names
Naming Rules
Case Sensitivity
Phase 2--Data Definition
Lesson 1 - Defining Field Specifications
Objectives
What is a Field Specification?
Signing On to HP ALLBASE/4GL Developer
Tips on Moving Around HP ALLBASE/4GL Screens
Menus
Data Screens
Creating Field Specifications
Using the Dictionary Field Specifications Screen
If You Make a Mistake ...
Entry Notes
HP TurboIMAGE/iX Field Specifications
Summary
Lesson 2 - Defining Record Layouts
Objectives
Record Layouts
Task 1 - Creating a Record Layout Header
Using the Record Layout Header Screen
Task 2 - Defining Record Layout Details
Using the Record Layout Details Screen
Completing the Record Layout Details
Entry Notes
Task 3 - Generating a Record Layout
Summary
Lesson 3--Defining Data Files
Objectives
KSAM Data File Definition and Creation
Task 1 - Defining a Data File
Using the Data File/SQL Table Definition Screen
Notes on Window Entries
Task 2 - Creating the Data File
Using the File/SQL Table Screen
Summary
What To Do Next
HP ALLBASE/SQL Table Definition and Creation
Task 1 - Defining an HP ALLBASE/SQL Table
Using the Data File/SQL Table Definition Screen
Task 2 - Creating an HP ALLBASE/SQL Table
Using the Create File/SQL Table Screen
Notes on SQL Tables
Summary
What To Do Next
HP TurboIMAGE/iX Data Set Definition
Task 1 - Defining an HP TurboIMAGE/iX Data Set
Using the File Definition Screen
Notes on Windows
Summary
Self Test Questions
Answers
Ch 3. Developing Screens
How HP ALLBASE/4GL Screens Work
Screen Types
Menus
Data Screens
Windows
Function Keys
System Items
Displaying Screens
Lesson 4 - Creating Menus
Objectives
Developing a Menu
Task 1 - Creating the the Menu Header
Task 2 - Painting the Menu Details
Using the Screen Painter to Paint a Menu
Step 1 - Creating the Screen Title
Some Useful Tips on Working with the Painter
Using Layout Keys
Using the Block Function
Step 2 - Defining System Items for a Menu Screen
Step 3 - Defining Actions for the Menu Screen
Task 3 - Saving the Menu Screen
Summary
Lesson 5 - Creating Data Screens
Objectives
Defining Data Screens
Task 1 - Defining the Screen Header
Task 2 - Painting the Data Screen Image
Step 1 - Entering Text Items
Tips On Entering Text
Step 2 - Entering the Screen Prompts
Step 3 - Defining Data Fields
Step 4 - Saving the Screen
Task 3 - Specifying Screen Field Details
Entry Notes
Task 4 - Generating the Data Screen
Summary
Ch 4. Defining Application Logic
Logic
What Are Processes and Functions?
What Are SQL Logic Blocks?
Defining the Logic for the Training Application
Lesson 6 - Developing a Process
Objectives
The Product Process
Task 1 - Defining the Process Header
Task 2 - Defining the Process Details
About the Process
Using Open Window Commands
Creating an SQL Process
Using Open Window Commands
Generating the Process
Notes on Entries
Creating an HP TurboIMAGE/iX Process
Using a Special Window Command
Generating the Process
Task 3 - Generating the Process
Summary
Lesson 7 - Developing a Function
Objectives
Functions
Task 1 - Defining the Function Header
Task 2 - Defining the Function Details
Developing a KSAM Function
Developing an SQL Function
Developing an HP TurboIMAGE/iX Function
Task 3 - Generating the Function
Summary
Lesson 8 - Creating an SQL Logic Block
Objectives
SQL Logic Blocks
Defining an SQL Logic Block
Defining the SQL Logic Block Details
The SELECT Command
Host Variables
Generating an SQL Logic Block
Generation Errors
SQL Logic Block Limitations
Another SQL Logic Block
Summary
Self Test Questions
Answers
Ch 5. Testing the Application
Lesson 9 - Testing the Training Application
Objectives
Application Testing
Any Problems?
Using Trace Mode
Handling Problems
Problem: Items Not Found
Problem: No Initial Action
Lesson 10 - Using Developer Utilities
Objectives
The Utilities Menu
Displaying the Catalog
Copying Catalog Items
Deleting Catalog Items
Printing Catalog Items
Generating Items
Summary
Understanding Screen Processing Logic
Full Data Screen Processing
Display Field Processing
Input Field Processing
Summary
Data Movement
Self Test Questions
Answers
Ch 6. HP ALLBASE/4GL Reports
What is an HP ALLBASE/4GL Report?
Format of a Report
Line Groups
Line Numbers
Totalling Facilities
The Product Report
Lesson 11 - Defining the Report
Objectives
Task 1 - Creating the Report Header
The Next Step for KSAM and TurboIMAGE/iX Applications
The Next Step for SQL Based Applications
Task 2--Creating the Report Line Header
Defining the Report Lines
Summary
Lesson 12 - The Report Painter
Objectives
Painting a Report
Using the Window Keys
Task 3 - Painting the Product Report
Step 1 - Entering Text Items
Step 2 - Defining Data Fields
In Summary
Creating Fields Using Dictionary Field Specifications
Step 3 - Saving the Report
Summary
Lesson 13 - Generating and Testing a Report
Objectives
Generating a Report
Testing a Report
Testing by Menu Bypass
Testing from a Menu
Summary
From Here On
Self Test Questions
Answers
Ch 7. Learning More Features
How Will the Modifications Look?
How Will the Modifications Look? (Continued)
The Application Screens
Application Structure
Lesson 13 - Creating Storage Items
Objectives
What Are Storage Items?
Defining Application Titles
Defining Variables
Defining the Mode Variable
Defining Numeric Constants
KSAM Based and HP TurboIMAGE/iX Based Applications
HP ALLBASE/SQL Based Applications
Defining Alphanumeric Constants
To complete the alphanumeric constants: (Continued)
Creating Additional Alphanumeric Constants
Summary
Lesson 14 - Modifying a Logic Block
Objectives
Modifying the product_proc Process
KSAM Based Applications
Modifying a Process
Step Number References
Using the IF Window
Continuing the Change
Deleting a Step
Modifying a Step
Adding Commands
Modifying HP ALLBASE/SQL Based Applications
Modifying a Process
Step Number References
Using the IF Window
Continuing the Change
Adding Commands
Deleting a Step
Modifying a Step
Modifying HP TurboIMAGE/iX Based Applications
Modifying Logic Blocks
Step Number References
Using the IF Window
Continuing the Change
Adding Commands
Deleting a Step
Modifying a Step
Summary
Lesson 15 - Creating New Logic Blocks
Objectives
The Mode Functions
Screen Field Logic
Modifying KSAM Based Functions
Modifying HP ALLBASE/SQL Based Functions
Modifying HP TurboIMAGE/iX Based Functions
File Manipulation Functions
KSAM Based and HP TurboIMAGE/iX Based File Manipulation Functions
The Add Function
The Modify Function
The Delete Function
HP ALLBASE/SQL Based File Manipulation Functions
The Add Function
The Modify Function
The Delete Function
The Next Step
Altering the Main Menu
Painting the Screen Again
Summary
Lesson 16 - Creating Messages
Objectives
Messages
Creating a Message
Summary
Lesson 17 - Validation Ranges
Objectives
Validation Range Definition
Summary
Self Test Questions
Answers
Ch 8. Learning to Use the Module Builder
Lesson 18 - The Module Builder
Objectives
Necessary Preparations
Necessary Preparations (Continued)
Defining the Field Specifications
Creating the Record Layout
Creating the File Specification
Using the Module Builder Screen
Using the Module Details Screen
Linking a Field to a Secondary File
Inserting a Display Field
Final Steps
Module Generation
The Module Building Process
Joining the Module to the Main Menu
Further Options
Running the Module
Using the Module
Retrieving an Existing Record
Summary
Summary (Continued)
Necessary Preparations
Module Building
Joining the Module to the Application
Running the Module
Conclusion
Self Test Questions
Answers
Ch 9. Learning Additional Screen Techniques
About the Enhanced Application
Product/Option Application
Function Keys
Scrolling Options
Reporting
Processing Rules
Application Structure
Product/Option Application
Lesson 19 - Adding Dictionary Items
Objectives
Dictionary Requirements
Task 1 - Creating Dictionary Field Specifications
Task 2 - Creating the Record Layout and File
Task 3 - Creating Variables
Task 4 - Creating Alphanumeric Constants
Task 5 - Creating Numeric Constants
Task 6 - Creating Validation Tables
Summary
Lesson 20 - More Screen Techniques
Objectives
Screens for the Enhanced Training Application
Task 1 - Altering the Product Data Screen
Task 2 - Creating the Option Window
Task 3 - Adding a new Option Window
Task 4 - Creating the The prod_wnd Window
Summary
Lesson 21 - Adding Function Keys
Objectives
Function Keys
Defining Function Keys
Defining a Second Function Key Set
Defining Function Key Logic
Summary
Lesson 22 - Scrolling Data on the Screen
Objectives
Understanding the Scrolling System
Task 1 - Creating Seconday File Record Layouts
Creating HP ALLBASE/SQL Select Lists
Defining a Select List
Generating a Select List
Task 2 - Creating The Scrolling Functions
Creating the Functions Called from the scroll_options function
Creating the last Function
Creating HP ALLBASE/SQL Functions
Creating HP TurboIMAGE/iX Functions
Summary
Lesson 23 - Creating User Help Screens
Objectives
Defining Help Screens
Creating Field Level Help
Creating Message Level Help
Creating Screen Level Help
Summary
Self Test Questions
Answers
Ch 10. Expanding Logic Blocks
Lesson 24 - Extending the Application Logic
Objectives
Modifying the product_proc Process
Understanding the Modifications to the Logic
Modifying the product_key_read Function
Creating the option_key_read Function
Creating Messages for the Logic Blocks
Summary
Lesson 25 - Using Decision Tables
Objectives
Defining the Decision Table Header
Decision Table Questions
Defining Decision Table Actions
Defining Decision Table Relationships
Testing the Modified Application
Summary
Lesson 26 - Creating the File Manipulation Functions
Objectives
Defining the Add Functions
Modifying the option_number Function
Creating the Appropriate Messages
Creating the modify_option Function
Creating the Delete Functions
Creating the Delete Functions for KSAM Based Applications
Modifying the delete_product function
Modifying the del_all_options function
Creating the del_corrupt_prod function
Deleting Options
Creating Functions for HP ALLBASE/SQL Based Applications
Deleting a Product
Modifying SQL Logic Blocks
Deleting Options
Creating the Functions for HP TurboIMAGE/iX Based Applications
Deleting Options
Summary
Self Test Questions
Answers
Ch 11. Developing Greater Reporting Capabilities
Lesson 27-Learning More Reporting Techniques
Objectives
Creating The Product/Option Report
Some Preparations
Creating the HP ALLBASE/SQL Based Applications Select List
Defining the Report Header
Creating the Screen
Creating the Function
Defining Report Sorting Levels
Defining Report Selection Criteria
Line Headers
KSAM Based and HP TurboIMAGE/iX Based Applications
HP ALLBASE/SQL Based Applications
Report File Linkages
Report File Linkages (Continued)
Defining the Functions
Painting the Report
KSAM Based and HP TurboIMAGE/iX Based Applications
Description of the Subtotal Lines
Creating the Final Total Group
HP ALLBASE/SQL Based Applications
Understanding Subtotal Lines
Summary
Lesson 28-Defining Calculated Items
Objectives
Calculated Items
Generating the Report
Altering the Main Menu
Running the Report
Summary
Where You Are Now
Self Test Questions
Answers
Ap A. Starting a New Application
Before You Start
The Sign-On Screen
Administrator Sign-On
Administrator Main Menu
Developer Validation
Training Application Definition
Training Application Definition (Continued)
Application Password Definition
Development Security Code
Other Fields
Users and Groups List
SQL Application Definition
SQL Database Definition
Database Access
HP TurboIMAGE/iX Database Creation
Defining the Database
The Parameters for Database Access Screen
Ap G. Developer Reference Chart
GLOSSARY
INDEX
Index