Related information for Database file management

Product manuals, Web sites, and other information center topic collections contain information that relates to the Database file management topic collection. You can view or print any of the PDF files.

Planning, installation, and migration

  • i5/OS globalization provides information that is required to understand and use the national language support function on the IBM® i operating system to the following audience:
    • Data processing manager
    • System operator and manager
    • Application programmer
    • End user
    • IBM marketing representative
    • System engineer

    This topic prepares the user for planning, installing, configuring, and using national language support (NLS) and multilingual support. It also provides an explanation of the database management of multilingual data and application considerations for a multilingual system.

  • Local Device Configuration, SC41-5121, Link to PDF provides the system operator or system administrator with information about how to do an initial local hardware configuration and how to change that configuration. It also contains conceptual information for device configuration, and planning information for device configuration on the 9406, 9404, and 9402 system units.

Application development

  • ADTS/400: Character Generator Utility provides the application programmer or system programmer with information about using the Application Development Tools character generator utility (CGU) to create and maintain a double-byte character set (DBCS) on the system.

System management

  • Backup and recovery provides the system programmer with information to plan a backup and recovery strategy. Also included are procedures to implement your backup and recovery strategy, how to recover from disk unit failures, and how to recover from a site loss.
  • Work management provides information about how to create and change a work management environment.
  • Security reference provides the system programmer with information about planning, designing, and auditing security. It includes information about security system values, user profiles, and resource security.

Communications and connectivity

  • ICF programming, SC41-5442, Link to PDF provides the application programmer with the information needed to write application programs that use System i® communications and ICF files. It also contains information about data description specifications (DDS) keywords, system-supplied formats, return codes, file transfer support, and programming examples.

Program enablers

  • Application display programming, SC41-5715, Link to PDF provides information about creating and maintaining screens for applications, creating online help information, and working with display files on the IBM i operating system.
  • CL programming provides a wide-ranging discussion of programming topics, including a general discussion of objects and libraries, control language (CL) programming, controlling flow and communicating between programs, working with objects in CL programs, and creating CL programs. Other topics include predefined and immediate messages and message handling, defining and creating user-defined commands and menus, and application testing, including debug mode, breakpoints, traces, and display functions.
  • Control language provides a description of the control language (CL) and its commands. Each command is defined including its syntax diagram, parameters, default values, and keywords.
  • Database programming provides the application programmer or system programmer with a detailed discussion of the IBM i database organization, including information about how to create, describe, and manipulate database files on the system.
  • DDS concepts provides the application programmer with detailed descriptions of the entries and keywords needed to describe database files (both logical and physical) and certain device files (for displays, printers, and ICF) external to the user's programs.
  • Printing provides information about how to understand and control printing: printing elements and concepts, printer file support, print spooling support, printer connectivity, advanced function printing, and printing with personal computers.
  • Tape files provides information about creating and maintaining tape device files.

System management

  • Distributed database programming provides the application programmer or system programmer with information about remote file processing. It describes how to define a remote file to IBM i distributed data management (DDM), how to create a DDM file, which file utilities are supported through DDM, and the requirements of IBM i DDM as related to other systems.