File Manager - DB2 component
The DB2 component of File Manager (FM/DB2) provides a comprehensive, user-friendly set of tools for working with DB2 data. These tools include the familiar browse, edit, copy and print utilities found in ISPF, enhanced to meet the needs of application developers.
FM/DB2 is a powerful set of utility functions for editing, browsing, printing, copying, and maintaining DB2 data. It also provides utilities for listing DB2 objects, managing DB2 privileges, generating JCL to run DB2 standalone utilities, exporting and importing DB2 tables to or from QSAM or VSAM data sets, creating data to populate DB2 tables, and prototyping SQL SELECT statements.
FM/DB2 is an ISPF application program. It uses panels that you can use to select options and to specify parameters, commands and program function (F) keys to simplify requests for common functions, and full-screen format for information display and editing. If data does not fit on the screen, ISPF provides scrolling in all four directions.
The File Manager for DB2 component in V8.1 has several new functions and enhancements, including:
- File Manager DB2 is enhanced to support the following new features in DB2 V9:
- Roles, by which a DB2 user can be authorized to perform a task only in a particular "trusted context". To enable support for roles and trusted contexts, File Manager DB2 is enhanced to support the DB2 Resource Recovery Services Attachment Facility (RRSAF).
- New data types that are introduced in DB2 V9: BINARY, VARBINARY, DECFLOAT, and BIGINT.
- The enhanced DB2 V9 SQL syntax, in File Manager DB2 Advanced SQL Prototyping, which is a syntax-directed interactive query building tool.
- New and changed DB2 V9 catalog tables.
- File Manager DB2 is enhanced to support SQL queries of up to 2 MB in length. SQL queries of up to 2 MB in length are supported by DB2 V8 or later.
- The File Manager DB2 editor related edit (REDIT) command previously could be used only in error situations to identify rows related by referential integrity constraints to a row being edited, and preventing the user from making an editor change. The REDIT command is extended in File Manager DB2 V8 to support non-error situations. REDIT can be used to work with tables related by referential integrity (RI) to a given table, or to work with other rows, usually in another table, that are related to an initial row by RI.
- File Manager DB2 interactive Edit and Browse are enhanced with an EXPORT command which exports to a file all rows currently in File Manager DB2 memory, or all rows in the current result set. In combination with the File Manager SQL prototyping tools, you can interactively export rows from an arbitrary SQL statement to a file.
- A limit on the number of rows to fetch is added to File Manager DB2 SQL options 4.3 and 4.4, having to do with entering and executing SQL statements.
- The File Manager DB2 Export utility's usability is enhanced by changing the task flow from the approach at the general availability of File Manager DB2 V7. Among other improvements, only the options applicable to a particular type of export are displayed to the user.
- File Manager DB2 is enhanced to support issuing DB2 commands and displaying DB2 command output.
- File Manager DB2 online help and documentation is enhanced with the following:
- Prefix commands available via the File Manager DB2 editor can be displayed by entering a "?" on the prefix command line.
- Field level help is provided throughout the File Manager DB2 component.