Introduction to TPFDF Programming

Overview
The 5 day TPFDF Training class is designed to introduce TPFDF to staff who will be writing TPF Application Programs using this Data Base Management tool. The course includes a brief introduction to Data Base Structures, Components and Terminology and is followed by a more in depth study of the frequently used TPFDF Macros and their associated parameters. The class includes frequent exercises to reinforce knowledge gained during the lecture sessions.

Pre-requisites
The students should be comfortable coding assembler programs in the TPF or ALCS environment.  The class can be based around programs structured using SPMs or normal BAL instructions. 

Audience
This class can be taught as part of the full TPF programmer training class or to experienced programmers who are moving into the TPFDF area.

Student Numbers
The maximum recommended student to instructor ratio is 12:1

Objectives
By the end of the course, the delegates will be able, with the aid of course notes to:

• Identify and describe the basic TPFDF Commands and the correct use of their parameters.

• List the functions of the Data Base Interface Block (SW00SR).

• Identify TPFDF information while tracing using ZUDFM entries

• Code and debug programs that use TPFDF macros.

Course Outline

Introduction	Why TPFDF? Data Management Data Structures
TPFDF	File Dsects and the LREC Central Data Base Descriptor Tables (DBDEF) ZUDFM Entries Database Design and File Algorithms The SW00SR
Command Structure	Search criteria - Introduction to Keys File Organisation SW00RTN
Commands	DBOPN DBRED DBADD DBDEL DBCLS DBREP DBMOD DBRET Selecting Lrecs by sequence number DBUKY DBIFB DBDSP Managing your subfiles to work with DBADR
File indexing	DBCRE DBIDX DBDIX
Miscellaneous	T-Types Suffix/Appendix DBSPA DBCKP

back to top