WRKDBF Features and Sample Panels!

The main WRKDBF panel

• Data fields are displayed in their "natural" way, meaning packed fields are displayed to you unpacked, binary fields are converted, etc.

• Multiple records are displayed allowing you to see up to 15 records at a time

• Multiple fields with column headings are displayed. Window Left and Right capability, as well as absolute field positioning, is available

• File positioning (or "read equal" restricting) is by full or partial Keys for indexed files, or in arrival sequence by Relative Record Number. "Top" and "Bottom" positioning is also provided

• File information includes:
  • Library, File, Member, and Format names
  • Object Text
  • Number of records
  • Object size in bytes
  • Maximum record length

• Database records can be:
  • Displayed
  • Changed
  • Copied
  • Deleted
  • Undeleted
  • Printed

• New database records can be Added

• Multiple format logical files are fully supported with proper column headings

• DDM files are fully supported

• ISO Date, Time, and Timestamp fields are fully supported

• Variable length fields are fully supported

• Floating point fields are fully supported

• A hexadecimal view is available so you can display and maintain records using the internal formats of the fields, if you wish

• Both 27x132 and 24x80 column displays are supported

• A "Find" function helps you find the records you wish to work with

• "Flat Files" (such as S/36 files and PC files) are fully supported including the ability to define the formats so that the file apears to be externally described

Select Field Sequence to Display

This panel is accessed by pressing "F14=Fields" on the main panel. This panel is used to:

• Display the File Field Descriptions (FFD's) and the Keys to the file

• Resequence the fields into any order you wish

• Hide any fields you do not want to display

• "Lock down" any fields that you always want to display. This is particularly useful for Keys (F15)

• You also have the ability to "Save" and "Restore" field sequences for later use. This is handy for working with the same database file over and over again

• A F16=Find function (by Field Name or Field Text) is provided to quickly take you to matching Fields you wish to work with

Executing SQL Commands

Pressing "F18=SQL Cmds" on the main panel allows you to execute SQL operations with your data base file. The SQL functionality is implemented via QMQRY (query management query) that is a normal part of OS/400. You are not required to purchase any additional SQL licensed product.

The SQL commands available are:

• Select
• Count
• Update
• Delete
• Label (change Field Text and/or Column Headings
• Insert

SQL operations can optionally be executed in batch. They can also be saved, then using a special command (WRKDBFSQL), they can be executed at a later date/time

The selected data can be saved to either an iSeries database *OUTFILE or to an IFS *STMF.

A global "undelete" command (WRKDBFUNDL) is provided should you need the ability to "undelete" every deleted record in a file

Written by: Bill Reger (breger1@wrkdbf.com)
WRKDBF Web Site URL: http://www.wrkdbf.com