HP 3000 Manuals HP 3000 Manuals
Table of Contents
HP ALLBASE/4GL Developer Reference Manual Vol. 1
HP ALLBASE/4GL Developer Reference Manual Vol. 1 : COPYRIGHT NOTICE
Ch 1. Overview
Introduction
HP ALLBASE/4GL System Architecture
The Operating System Interface
Data Manager
The Administrator
The Developer
End User Applications
Phases of Application Development
Planning Your Application
Data Definition
Field Specifications
Validation Items
Storage Items
Record Layouts
Database Items
Messages
Help Screens
Screen Development
Logic Definition
Processes and Functions
SQL Logic Blocks
Decision Tables
Report Definition
HP ALLBASE/SQL Interface
Dictionary Items
SQL Logic Blocks
HP TurboIMAGE/iX Interface
Application Generation
Application Documentation
Application Security
HP ALLBASE/4GL Files
System Files
Application Data Files
Program Files
Ch 2. Getting Started
MPE/iX Login
Running HP ALLBASE/4GL
Signing On to HP ALLBASE/4GL
The Sign On Screen
Bypassing the Sign On Screen
HP ALLBASE/4GL Terminals
HP ALLBASE/4GL Terminal Initialization
System Character Sets
Using a Touchscreen Terminal
Accessing HP ALLBASE/QUERY
Developer Main Menu
Selecting Menu Items
Executing Menu Items
Menu Bypass
Function Keys
Standard Function Keys
System Keys Function Key Set
Name Recall Function Key Set
More Keys Function Key Set
Entering and Editing Data
Editing a Field
Committing a Field Entry
Correcting Mistakes
Moving Between Data Fields
Using the Cursor Control Keys
HP Touchscreen Terminals
Committing Screens
Using the Name Recall Function
Using Name Completion
Using Catalog Display Function
Returning to Non-Search Mode
Using the Tab Key for Name Recall
Using On-Line Help
Printing Screen Images
Signing Off
Command Line Options
Sign On Screen Bypass
Customized Sign On
Ch 3. Referencing Rules
Introduction
Naming and Referencing Rules
Developer-Defined Elements
The Communication Area
Scratch-Pad Fields
HP ALLBASE/4GL Names
HP ALLBASE/SQL Names
HP TurboIMAGE/iX Names
Item and Field Referencing
Substring Referencing
Format
Parameters
Additional Information
Subscript Referencing
Format
Parameters
File Record Field Referencing
File Record Buffer Referencing
Screen Field Referencing
Reference by Name
Reference by Absolute Number
Reference by Relative Number
Work Area Field Referencing
Work Area Buffer Referencing
Scratch-Pad Field Referencing
Reference by Name
Reference by Number
Calculated Item Referencing
Constant Referencing
Literals
Numeric Constant Referencing
Master Title Referencing
Variable Referencing
Communication Area Field Referencing
HP ALLBASE/SQL Host Variable References
Format
Action Prefixes
Edit Codes
Storage Type Codes
Justification Codes
Ch 4. Communication Area and Switches
The Communication Area
Alterable Communication Fields
*COUNT(n)
*CROSS(n)
*ERROR
*ERRORDM
*FIELDNO
*FILENAME
Dynamic Serial File Naming
*FUNCTION
*IMSTAT
*INDEXNO
*IOSTATDM
*IOSTATUS
*LOCKWAIT
*LTRACE
*MSGDELAY
*NEWTIE
*PAGELINE
*PAGENO
*PASS
*PROCESS
*RECNO
*REPORT
*ROUTINE
*ROWCOUNT
*SCREEN
*TOTALS(n)
Read-Only Communication Fields
*DATE
*DBENAME
*KEYS
*PREVFLD
*SUITE
*TIME
*USER
*VERSION
Switches
User Switches
Fixed Function Switches
*BYPASS
*ENDFIELD
*ENDLINE
*ENTERED
*MOREREC
*SHOWING
Ch 5. Dictionary
Dictionary Menu Screens
Dictionary Menu
Screen Image
Menu Selections
Function Keys
Field Specifications Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Mapping to SQL Data Types
Mapping to HP TurboIMAGE/iX Data Types
Null Value Support
Data Manager Specific Field Attributes Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Validation Items Menu
Screen Image
Menu Selections
Function Keys
Validation Ranges Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Validation Tables Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Storage Items Menu
Screen Image
Menu Selections
Function Keys
Variables Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Calculated Items Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Generating Calculated Items
Using Calculated Items
Numeric Constants Screen
Screen Image
Field Descriptions
Function Keys
Alphanumeric Constants Screen
Screen Image
Field Descriptions
Function Keys
Scratch-Pad Fields Screen
Screen Image
Field Descriptions
Function Keys
Application Titles Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Work Areas Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Record Layout Menu
Screen Image
Menu Selections
Function Keys
Record Layout Details Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Record Layout Header Screen
Screen Image
Field Descriptions
Function Keys
Database Items Menu
Screen Image
Menu Selections
Function Keys
File/SQL Table Definition Screen
Screen Image
Field Descriptions
SQL Table Definition Window
Field Descriptions
HP TurboIMAGE/iX Data Set Definition Window
Field Descriptions
KSAM/Serial File Definition Window
Field Descriptions
Function Keys
Additional Information
Using Existing HP ALLBASE/SQL Tables
Using Existing HP TurboIMAGE/iX Data Set
HP TurboIMAGE/iX Data Set Types
Serial File Creation
Using File Equations
File/SQL Table Creation Screen
Screen Image
Field Description
Function Keys
Additional Information
HP ALLBASE/SQL Table Creation
KSAM Data File Creation
Data File Reformat Screen
Screen Image
Field Description
Function Keys
Additional Information
File Reformat Limitations
HP ALLBASE/SQL Table Reformatting
HP TurboIMAGE/iX Data Set Reformatting
Run-Time Environment Data File Reformatting
File/SQL Table Deletion Screen
Screen Image
Field Description
Function Keys
Additional Information
Select List Details Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
HP ALLBASE/SQL Host Variable References
Select List Generation
Select List Header Screen
Screen Image
Field Descriptions
Function Keys
Messages Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Message Display
Clearing the Message Display
Message Generation
Error Conditions
Help Screens Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
HP ALLBASE/4GL Help Display
Help Screen Function Keys
Ch 6. Screen Development
HP ALLBASE/4GL Screens
Menus
Data Screens
Windows
System Items
Function Keys
Creating Application Screens
Data Screen Processing Logic
Screen Buffers
Data Movement Fields
Primary Data Movement File
Default Data Movement Files
Other Data Movement Fields
Screen Field Functions
Switches and Communication Area Fields
Communication Area Fields
Switches
Screen Processing Sequence
Screen and Field Commit Actions
Field Display Logic
Input Field Logic
Error Processing
After Entry Functions
Data Validation Summary
Automatic Data Validation
Additional Validation
Automatic Data Movement
Commit Data Actions
SHOW Command Processing
SHOW Functions
Generating Screens
Screen Development Screens
Screen Development Menu
Screen Image
Menu Selections
Function Keys
Screen Header Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Screen Field Details Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Function Keys Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Function Key Display Logic
HP ALLBASE/4GL Internal Routines
Default Function Key Definitions
Using the Screen Painter
Screen Painter Function Keys
Cursor Movement
Screen Field and Item Types
Menus
Data Screens and Windows
Other Screen Items
Creating Screen Items
Literals
System Items
Action Items
Input Fields and Output Fields
Using Dictionary Fields
Converting Fields
Special Text Items
Using Colors
Editing Special Text Items
Converting Text Items
Line Drawing Character Set
Clashing Items
Display Highlighting
Available Space Keys
Layout Function Keys
Moving and Copying Fields
Block Move and Copy Functions
Deleting Items
Column Entry Mode
Sequence Numbers Keys
More Function Keys
Saving Screens
Leaving the Painter
Ch 7. Reports
HP ALLBASE/4GL Report Environment
Primary Report File
Report Output
Record Selection
Report Sorting and Control Breaks
Report Sorting
Control Breaks
Report Line Types
The PRINT Command
File Linkages
Switches and Communication Area Fields
Switches
Communication Area Fields
Report Functions
Totalling Facilities
Totalling Matrix
Accumulating Totals
Report Calculations
Reporting From an HP ALLBASE/SQL Database
File Linkages
Reporting From an HP TurboIMAGE/iX Database
Defining a Report
Report Processing Logic
Report Control Logic
Report Initialization
Report Record Processing Logic
Report Completion Logic
Report Line Group Logic
Line Printing Logic
Reports Menu Screens
Reports Menu
Screen Image
Menu Selections
Function Keys
Report Header Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Report Stationery
Report Sorting Screen
Screen Image
Field Descriptions
Function Keys
Selection Criteria Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Report Line Header Screen
Screen Image
Field Descriptions
Function Keys
File Linkages Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Critical Linkages
Non-Critical Linkages
Report Painter
Screen Image
Cursor Movement
Display Scrolling
Report Painter Function Keys
Main Function Key Set
Window Keys Function Key Set
Field Keys Function Key Set
More Keys Function Key Set
Painting Report Lines
Literal Fields
Output Fields
Dictionary Fields
Moving, Copying and Deleting Fields
Saving Reports
Screen Field Descriptions
Ch 8. Module Builder
Module Operation
Module Capabilities
Process
Data Screen
File Scanning
Keyed Access
Maintenance Modules
Files with Unique Keys
Files with Duplicate Keys
Serial Files
Secondary Files
Secondary File Functions
Additional Information Display
Data Validation
Limitations
Building a Module
Module Builder Screen
Screen Image
Field Descriptions
Function Keys
Additional Information
Module Details Screen
Screen Image
Field Descriptions
Function Keys
Module Construction and Templates
Module Construction
Template Type
Resultant Screen
Main Process
To Do List Processing
Item Generation
Template and Item Naming
Template Naming
Item Naming
Template Libraries
Current Application
Site Customizable Template Library
Native Language Template Library
Standard Template Library
Macro and Name Substitution
Processes and Functions
SQL Logic Blocks
Function Key Sets
Screen Titles
Templates
Screens
Function Key Sets
Processes and Functions
SQL Logic Blocks
Variables and Constants
Messages
Help Screens
Application Titles
Items Not Supported
Ch 9. HP ALLBASE/SQL Interface
Introduction
Database Environments
Multi-User Database Environments
SQL Logic Blocks
SQL Block Commands
Host Variable Referencing
The SELECT Command
Implicit SQL Commands
CONNECT and RELEASE
Cursor Commands
BEGIN WORK and COMMIT WORK
Using HP ALLBASE/SQL Data
Retrieving HP ALLBASE/SQL Data
Adding New Records
FILE *INSERT Command
SQL INSERT Command
Updating HP ALLBASE/SQL Data
Updating Via a Cursor
Updating Without a Cursor
Deleting Records
FILE *DELETE Command
Deleting via a Cursor
Deleting Without a Cursor
The SQLEXPLAIN Command
SQL Logic Block Generation
HP ALLBASE/SQL Transaction Management
TRANSACT Command
Table Locking
The Table Locking Mode
The LOCK TABLE Command
Ch 10. HP TurboIMAGE/iX Interface
Introduction
Databases
Uploading Definitions
Running HP4TUPLD
Command Line Parameters
Naming Conventions
An Example
The Upload Procedure
Upload Defaults
The Interface to HP TurboIMAGE/iX
Opening and Closing Databases
Database Access Modes
Opening and Closing Data Sets
HP ALLBASE/4GL FILE Logic Command
Transaction Management
INDEX
Index