Development Tools and Distributed Computing

Creating, opening, and closing a file.

Specifying file designators and file domains.

Record selection and data transfer.

Writing to, reading from, updating, and sharing files.

Accessing a mapped file.

Getting started with ALLBASE/NET.

Setting up ALLBASE/NET on client and server systems.

Using ALLBASE/SQL through ALLBASE/NET.

NETUtil commands.

Using New Data Integrity Features.

Using Procedures in Application Programs.

Using Parameter Substitution in Dynamic Statements.

Preprocessing in Static Conversion Mode.

Transaction Management with Multiple DBEnvironment Connections.

COBOL Preprocessor Enhancements.

Programming with Indicator Variables in Expressions.

Tuning Performance with GENPLAN.

Using Procedure Cursors with Multiple Row Result Sets.

Flagging non-standard SQL with the FIPS Flagger.

POSIX preprocessor invocation (MPE/iX only).

Using the preprocessor to enable threaded applications (MPE/iX only).

Using the preprocessor to specify a DBEFileSet for section storage.

Understanding and using the HP SQL C preprocessor.

Embedding SQL commands.

Using and declaring host variables.

Run-time status checking and data manipulation.

Sequential and BULK table processing.

Dynamic operations.

Understanding and using the HP SQL COBOL preprocessor.

Embedding SQL commands.

Using and declaring host variables.

Run-time status checking and data manipulation.

Sequential and BULK table processing.

Dynamic operations.

Database administrator's tasks and tools.

Logical and physical design of databases.

DBEnvironment configuration and security.

Database creation and security.

Backup, recovery, and maintenance of databases.

Controlling performance of databases.

The ALLBASE/SQL system catalog.

SQLUtil, SQLGEN, SQLMigrate, and SQLAudit commands.

Understanding/using the HP SQL FORTRAN preprocessor and programs.

Embedding HP SQL commands.

Using and declaring host variables.

Run-time status checking and data manipulation.

Sequential table processing.

Dynamic operations.

Types of messages and how they are returned.

ALLBASE/SQL error messages.

Understanding and using the HP SQL Pascal preprocessor and programs.

Embedding HP SQL commands.

Using and declaring host variables.

Run-time status checking and data manipulation.

Sequential and BULK table processing.

Dynamic operations and programming for performance.

Improving performance through logical and physical data design.

Writing queries and transactions for best performance.

Administering the database for best performance.

Tuning your operating system for best performance with ALLBASE/SQL.

Troubleshooting performance problems with SQLMON, an online tool for monitoring the activity of a DBEnvironment.

Using the SQLMON screens and commands.

Understanding and using HP SQL.

ALLBASE/SQL queries.

ALLBASE/SQL names, data types, expressions, and search conditions.

ALLBASE/SQL commands.

Asynchronous serial communications and the distributed terminal subsystem.

Controlling asynchronous devices programmatically.

Input/output programming guidelines.

Calling intrinsics from a program.

Socket system calls.

File system intrinsics.

Name service routines.

Include files and references used.

Using commands programmatically.

Controlling variables.

Controlling job control words.

Identifying parameter input.

Mathematical functions and procedures.

Utility procedures.

Packed-decimal procedures.

Data types and character codes.

ASCII, EBCDIC, INTEGER, decimal, and real data types.

Using data type conversion intrinsics.

EDIT/3000 features, editing modes, and file definitions.

Initializing, running, and terminating EDIT/3000 in interactive sessions and batch jobs.

EDIT/3000 commands and their use.

Customizing EDIT/3000 on your system.

Introduction to IMAGE/SQL.

Basic concepts and tasks.

Transition from TurboIMAGE/XL to IMAGE/SQL.

Sample database.

Database setup using ISQL.

DBEnvironment configuration.

IMAGE/SQL environment restoring.

Available tools.

Understanding and using HP SRC.

Manipulating file sets.

Using HP SRC with COBOL.

Setting security.

Getting started with TRANSACT.

Using character mode I/O and IMAGE.

Using VPLUS and IMAGE.

Using KSAM and MPE/iX.

Automatic error handling, prototyping, and data structures.

Using TRANSACT without Dictionary/3000.

Creating custom applications.

Using Hi-Li.

Screen management intrinsics.

Hi-Li intrinsics.

Data mapping methods.

HP ALLBASE/Query models.

Relational databases.

Structured Query languages.

Terms.

Starting up HP ALLBASE/Query.

Using ALLBASE/Query on HP/UX and on MPE/iX.

EZAccess tutorial.

SQLAccess tutorial.

EZReport tutorial.

EZCreate tutorial.

Commands syntax.

Error messages.

Overview of ALLBASE/BRW.

Communicating with BRW.

Report writing with BRW.

Defining data access.

Defining report layout, sorts, break, and pagination.

Defining data selection.

Saving and compiling a report.

Requesting reports.

Multi-pass reporting.

BRW-Desk/XL calculations

Screen descriptions.

Configuration and security.

Getting started.

Creating a simple report.

Refining the report.

Performance considerations.

Introducing HP Browse/XL.

Using HP Browse/XL.

Function keys.

Table of character key assignments.

Error and warning messages.

The program development environment for HP Business BASIC/XL.

HP Business BASIC/XL language elements, statements, and functions.

Using report writer block statements and built-in functions.

User-definable keys.

Using the compiler.

Introducing HP C.

HP C storage and alignment comparisons.

The optimizer.

Debugging HP C programs.

Programming for portability.

Migrating HP C programs.

Organization of, and use of the HP C/iX library.

Standard library functions.

Math library functions.

HP C/iX lexical elements, data types, and declarations.

HP C/iX type conversions, expressions, and statements.

HP C/iX preprocessor directives and library functions.

Compiling and running HP C/iX programs.

Implementing HP C/iX.

Using HP C/iX intrinsics and the listing facility.

ANSI 85 features.

Programming practices, subprograms, and intrinsics.

Manipulating files, file types, and file codes.

Compiling, linking, and executing programs.

Debugging a program.

Preprocessor commands and $CONTROL options.

COBOL II program format.

COBOL II procedure division statement formats.

COBOL reserved word list.

Program structure and elements.

Describing and referencing data.

IDENTIFICATION, ENVIRONMENT, DATA, and PROCEDURE DIVISION.

PROCEDURE DIVISION statements.

Interprogram communications and source text manipulation.

SORT/MERGE operations and debug operations.

Entering data with ENTRY.

Designing forms with FORMSPEC.

Advanced Forms Design

Reformatting specifications using REFSPEC.

VPLUS/iX intrinsics.

Using FORMSPEC in batch mode.

Native language support.

Sample Programs

VPLUS Error Messages

System management.

Cursors and windows.

Text entry and alteration.

Text formatting and text location.

Macros and the calculator.

Configuration and printing.

Getting started with HP EDIT.

Conducting an editing session.

Understanding the types of HP EDIT commands.

Using HP EDIT commands.

Using data storage and formatted input/output.

HP FORTRAN 77/iX file operations and subprograms.

Writing efficient programs and tuning performance.

Interfacing with other languages.

Using the compiler directives.

Debugging programs and using system intrinsics.

FORTRAN language elements and statements.

Input/output and file handling.

Compiling and running HP FORTRAN 77/iX programs.

Compiler directives.

Interfacing with non-FORTRAN subprograms.

Trapping run-time errors and data format in memory.

Administrative tasks with step-by-step directions.

Concepts and functionality.

Utility commands.

Locks and deadlocks.

Transactions, repeatable reads, and aborted transactions.

Error messages.

SQL statement restrictions with TurboIMAGE/XL datasets.

Using HP Link Editor/iX.

Linking relocatable object files and relocatable and executable libraries.

Using HP Link Editor/iX files and commands.

Creating executable programs.

Using and maintaining relocatable and executable libraries.

Program structure and input/output.

Predefined Pascal/iX constants, data types, and modules.

Program allocation and alignment.

Dynamic variables, parameters, and procedure options.

External routines, intrinsics, error recovery, and debugging.

The optimizer.

Language elements, data types, and expressions.

Declaration sections and statements.

Program structure, procedures, and functions.

Predefined routines.

Input/output and system programming extensions.

Installation of the HP Performance Collection Software.

Overview of the HP Performance Collection Software.

Details on data collection (SCOPE) and Data Management (UTILITY and EXTRACT)

Archiving Strategies and Perforance Alarms.

Creating RPG/iX programs.

Using disk files and a terminal in an RPG/iX program.

Processing data in RPG/iX programs.

Compiling and executing RPG/iX programs.

Communicating with MPE and other RPG programs.

Writing efficient RPG/iX programs.

Using RPG/iX.

RPG/iX specification fields.

The RPG/iX interface to VPLUS.

The RPG/iX screen interface.

The RPG/iX compiler.

Using the RPGINIT utility.

Using the SIGEDITOR utility, including the application help facility.

The application help facility.

RISE utility features, commands, and recovery procedures.

XSORT features, specifications, commands, and applications.

HP SRC implementation and configuration analysis.

Implementing HP SRC.

Additional HP SRC models.

The HP SRC environment.

Using HP SRC.

Branching and merging.

HP SRC commands.

Getting started and using the symbolic debugger/iX program.

Symbolic debugger/iX commands.

Symbolic debugger/iX quick reference guide.

Using the COBOL definition extractor.

Running the SDCDE program.

SDCDE commands.

Generating source definitions.

Record layout and generating data definition clauses and comments.

Data dictionaries, operating environment, language, and subsystem support.

Dictionary concepts and architecture.

Dictionary domains and versions.

Dictionary security and dictionary core set.

TurboIMAGE, HP IMAGE, and HP SQL subsystem support.

Using the SDINIT program and how to run it.

Using the SDUPGRAD program and how to run it.

Using the SDCONV program, its commands, and how to run it.

Using the SDUTIL program, its commands, and how to run it.

System dictionary operating environment, and language and subsystem support.

Programming considerations.

Parameter descriptions for Pascal, COBOL, and FORTRAN.

Dictionary intrinsic descriptions.

Understanding and running the SDMAIN program.

Using the system dictionary command language.

System dictionary commands.

Running the SDDBD program, its commands, and loading process.

Running the SDDBC program, its commands, and creation process.

Running the SDVPD program, its commands, and loading process.

The TRANSACT language.

TRANSACT programs.

TRANSACT data storage registers.

Running TRANSACT.

TRANSACT verbs.

TRANSACT test facility.

TRANSACT/XL debug facility, TRANDEBUG.

Using interprocess communications.

Using job control words and other variables with IPC.

Using file system intrinsics with IPC.

NOWAIT I/O.

Software interrupts.

Interprocess communications using the mail facility.

Users and elements of ISQL and native language support.

Using ISQL.

Managing ISQL transactions, files, and modules.

ISQL commands.

KSAM/3000 features and using KSAM files.

KSAMUTIL and FCOPY utilities.

KSAM files in COBOL, SPL, FORTRAN, and BASIC programs.

Calling KSAM procedures.

Calling file system intrinsics.

Getting started with HP EDIT.

Creating, modifying, and keeping text using HP EDIT.

Positioning the cursor in HP EDIT.

Modifying text and undoing input within HP EDIT.

Searching and replacing text using HP EDIT.

Copying and moving text blocks using HP EDIT.