HPlogo

Using KSAM XL: 900 Series HP 3000 Computer Systems

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

HP Part Number: 32650-90487

Edition: Third Edition

Published: Printed in: U.S.A. 1994


Table of Contents

Preface
In This Book
1 Introduction
KSAM XL File Format
Index Area
Data Area
Automatic Recovery
2 Creating a KSAM XL File
Creating the File With the BUILD Command
KSAM XL File Characteristics
Sample BUILD Command
Specifying an Indirect File
Loading Data to a KSAM XL File
Modifying Existing File Specifications While Copying
Building a KSAM XL File Programmatically
Language ID
Flag word
Number of Keys
Key Parameters
Using Related Commands
Deleting a KSAM XL File
Renaming a KSAM XL File
Modifying File Attributes
3 Obtaining File Information
Displaying File and Key Information
Accessing File Information from a Program
Accessing Key Information From a Program
Accessing User-Defined Labels
4 Opening and Closing the File
Opening an Existing KSAM XL File
Using the HPFOPEN Intrinsic
Using the FOPEN Intrinsic
Opening a New File
Closing a KSAM XL File
5 Reading File Data
Sequential Access by Primary Key
Sequential Access by Primary and Alternate Key
Specifying the Record Number
Specifying a Key Value
Sequential Access by Partial Key Value
Random Access of a Single Record
Using a Key Value
Using the Relative Record Number
Using a Physical Record Number
Sequential Access in Physical Record Order
Shared File Access
6 Writing and Updating Record Data
Writing New Records
Updating Existing Records
Deleting a Record
Shared Access
7 Protecting the File and Its Data
Checking Error Information
Protecting Data When File Access is Shared
Writing Directly to Disk
Recovering from a System or Software Abort
Backing Up KSAM XL Files
Recovering from Index Corruption
8 Migration and Mixed Mode Processing
Similarities in KSAM File Features
Differences in KSAM File Features
Migrating KSAM Files
Mixed Mode Operation
9 KSAM XL Intrinsics
FCHECK
Syntax
Parameters
Operation Notes
Condition Codes
FCLOSE
Syntax
Parameters
Operation Notes
Condition Codes
FCONTROL
Syntax
Parameters
Condition Codes
FERRMSG
Syntax
Parameters
Condition Codes
FFILEINFO
Syntax
Parameters
Condition Codes
FFINDBYKEY
Syntax
Parameters
Operation Notes
Condition Codes
FFINDN
Syntax
Parameters
Operation Notes
Condition Codes
FGETINFO
Syntax
Parameters
Operation Notes
Condition Codes
FGETKEYINFO
Syntax
Parameters
Operation Notes
Condition Codes
FLABELINFO
Syntax
Parameters
Condition Codes
FLOCK
Syntax
Parameters
Condition Codes
FOPEN
Syntax
Functional Return
Parameters
Operation Notes
Condition Codes
FPOINT
Syntax
Parameters
Operation Notes
Condition Codes
FREAD
Syntax
Functional Return
Parameters
Operation Notes
Condition Codes
FREADBYKEY
Syntax
Functional Return
Parameters
Operation Notes
Condition Codes
FREADC
Syntax
Functional Return
Parameters
Operation Notes
Condition Codes
FREADDIR
Syntax
Parameters
Operation Notes
Condition Codes
FREADLABEL
Syntax
Parameters
Operation Notes
Condition Codes
FREMOVE
Syntax
Parameters
Operation Notes
Condition Codes
FRENAME
Syntax
Parameters
Operation Notes
Condition Codes
FSPACE
Syntax
Parameters
Operation Notes
Condition Codes
FUNLOCK
Syntax
Parameters
Condition Codes
FUPDATE
Syntax
Parameters
Operation Notes
Condition Codes
FWRITE
Syntax
Parameters
Operation Notes
Condition Codes
FWRITELABEL
Syntax
Parameters
Operation Notes
Condition Codes
HPFOPEN
Syntax
Parameters
Operation Notes
A COBOL Intrinsics
Calling a KSAM Procedure
Filetable Parameter
Status Parameter
KSAM Logical Record Pointer
Shared Access
Sample KSAM File
CKCLOSE
Parameters
Operation Notes
CKDELETE
Parameters
Operation Notes
CKERROR
Parameters
Operation Notes
CKLOCK
Parameters
Operation Notes
CKOPEN
Parameters
Operation Notes
CKOPENSHR
Parameters
Operation Notes
CKREAD
Parameters
Operation Notes
CKREADBYKEY
Parameters
Operation Notes
CKREWRITE
Parameters
Operation Notes
CKSTART
Parameters
Operation Notes
CKUNLOCK
Parameters
Operation Notes
CKWRITE
Parameters
Operation Notes
Examples of KSAM File Access
Sequential Write
Sequential Read
Random Update
B BASIC/V Intrinsics
Overview
Calling a KSAM Procedure
Optional Parameters
Status Parameter
KSAM Logical Record Pointer
Shared Access
BKCLOSE
Parameters
Operation Notes
BKDELETE
Parameters
Operation Notes
BKERROR
Parameters
Operation Notes
BKLOCK
Parameters
Operation Notes
BKOPEN
Parameters
Operation Notes
BKREAD
Parameters
Operation Notes
BKREADBYKEY
Parameters
Operation Notes
BKREWRITE
Parameters
Operation Notes
BKSTART
Parameters
Operation Notes
BKUNLOCK
Parameters
Operation Notes
BKWRITE
Parameters
Operation Notes
C HP C/iX Example Program
Index

List of Figures

1-1 General Representation of the KSAM XL Format
1-2 A Simplified View of the KSAM File Structure
1-3 Simple Index Tree Structure
2-1 Creating a KSAM XL file using the OPTMBLK parameter
2-2 Creating a KSAM XL file with the data block size set at 4K bytes (default)
2-3 Building the AR Master File
2-4 Using a Key Data File
2-5 KSAM XL Parameter Format
2-6 KSAM Parameter Settings
2-7 KSAM Parameter Settings (continued)
3-1 File Type Display
3-2 File Information Display
3-3 Key Information Display
4-1 Opening an Existing KSAM XL File with HPFOPEN
4-2 Opening a New KSAM XL File with HPFOPEN
4-3 Opening a New KSAM XL File with FOPEN
5-1 FFINDN Intrinsic Sample
5-2 FFINDBYKEY Intrinsic Sample
5-3 Partial Key Search Sample
5-4 Accessing a Record by Key Value
7-1 Index Corruption Recovery
9-1 Foption Bit Summary
9-2 Aoption Bit Summary
9-3 FGETKEYINFO Parameter Format
9-4 FGETKEYINFO Control Parameter Format
9-5 FGETKEYINFO Control Parameter Format (continued)
9-6 Foption Bit Summary
9-7 FOPEN KSAM XL Parameter Format
9-8 HPFOPEN KSAM XL Parameter Format
A-1 Filetable Structure
A-2 Representation of KSAMFILE Used in COBOL Examples
A-3 Procedures Allowed for Input/Output Type/Access Mode Combinations
A-4 Sequential Write Using COBOL
A-5 Sequential Read Using COBOL
A-6 Random Update with COBOL
B-1 Closing a KSAM File with BKCLOSE
B-2 Deleting a Record With BKDELETE
B-3 Dynamically Locking a KSAM File with BKLOCK
B-4 Opening KSAM File with BKOPEN
B-5 Reading From a KSAM File with BKREAD
B-6 Reading a Record Located by Key Value with BKREADBYKEY
B-7 Title not available (Operation Notes)
B-8 Title not available (Operation Notes)
B-9 Rewriting Record in KSAM File with BKREWRITE
B-10 Positioning Pointer to Least-Valued Record with BKSTART
B-11 Positioning Pointer to Particular Record with BKSTART
B-12 Dynamically Unlocking a KSAM File
B-13 Writing to a KSAM File with BKWRITE
Feedback to webmaster