Linux and Windows, current version: 5.1.25 (June 2020)
with v.5.1.19, the DB2 CAE-based plugin for PMF will require
DB2 v9 and higher. If you want PMF to work with older DB2 versions,
drop me a mail.
What it's all about
Very short description: PMF (Poor Man's Flight) is an OpenSource
table-editor/visualizer for IBM's DB2 database and Microsoft Sql
Server. Main feature is viewing and editing any table in the database,
but PMF has some other useful functions, too (see below). Useful
for developers and database admins. PMF is available for Linux and
Windows (and, for DB2 only, OS2).
What it does
- PMF shows you all the tables in your database. Simply click on a
table and PMF will display the table's contents.
- You can easily edit (update, delete and insert) data in any table
without having to issue tedious SQL-commands.
- Generate and run your own SQL-Commands by simple mouse-clicks.
- PMF uses SqlCLI (for SQL Server) and both SqlCLI and DB2's native APIs
- Handles XML and LOBs (LargeObjects)
- Works with IBM DB2 and Microsoft Sql Server
- Direct editing: Edit cells in the table directly, save all
changes with a single click
- Tabs: Open multiple tables in tabs, just as in a browser.
- Filter: Right-click any cell to use the cell's contents as filter
- Textcompletion in EXTSQL and SQL CMD: Start typing and PMF will
- Creates DDLs (Table descritption)
- Copy & paste multipe rows between tables and instances of PMF
- Integrated help
- Update rows with CURRENT CURSOR (when 'Single Row' is
- LOBs (LargeObjects): Right-click a LOB to display it, i.e., open
images in a viewer, texts in an editor etc.
- XMLs: Right-click an XML to display, edit and save it
- LOBs and XMLs: Drag and drop files into LOB or XML columns to
INSERT or UPDATE data
- Upload and retrieve LOBs (BLOBs, CLOBS, ...). Either read/write
LOBs from/to specified files, or export/import a whole table,
includingLOBs, in a single session.
- Read uncommitted rows: By default, PMF will read uncommitted
rows. This can be changed in the menu.
- History: Toggle through command history
- Bookmarks: Save complex or regularly used SQL in bookmarks, again
just like in a browser.
- Connection profiles: Store connection info (database/user/passwd)
for each database individually and connect in an instant.
- Create, store and load multi-lined SQL statements.
- Find and delete identical lines in any or all tables.
- Easy Export and Import/Load of IXF, WSF, DEL (for DB2) and plain-text
files (both DB2 and Sql Server).
- Drop tables and create tables from IXF sources (DB2 only)
- Reorganisation, Runstats and Rebind (DB2 only)
- Index administration
- Detailed Information on tables: Index, Creator, SQL-Types etc.
- Security: Changes to tables can be automatically documented in a
- Alter table (add, rename and remove columns)
- Tablespace information and table sizes (DB2 only)
- Basic snapshot/monitoring (DB2 only)
- Scriptable actions when right-clicking a cell
A little history
PMF (Poor Man's Flight) is a comfortable and rather powerful
editor/visualizer for the tables of a DB2 Database. With DB2 v.2 IBM
shipped a very useful program called "(Visualizer) Flight", which
(among other things) allowed DB2 users to view and change the contents
In 1997 I started to write a program for my company which should do
much the same (hence the name), for two reasons: First, we needed a
trace-function: Changes to tables had to be documented. Second and most
important, IBM's "Flight" was only available for OS/2 and we were using
DB2 on both OS/2 and Windows. Since 1997 PMF has improved of course, it
became faster and some useful functions have been added. Originally
intended for inhouse use only, PMF soon became a "Don't leave home
without it"-tool and even found some fans outside the company.
Being a Linux fan, I wanted to rewrite PMF for this platform and this
is what I have been doing for the last couple of years. With TrollTech
releasing a non-commercial edition of their librabry, I was able to
port the Linux version to Windows and provide PMF as Free Software.
For nearly 5 years I didn't change much if anything, but with Trolltech
releasing QT4 it became obvious that the times are indeed a-changing
and that a complete rewrite of the GUI was necessary. I started around
christmas 2010 and spent nearly a year fixing bugs and adding new
features (I'm doing this in my spare time).
The latest iteration handles Sql Server as well, which required a
redesign of the invisible parts. Busy times.
So, whether you are a database administrator or a software-developer or
just curious to take a look into your database without view-blocking
heavy interfaces, you might find PMF very useful.
Trademarks: Windows NT, Windows 2000, Windows XP, Sql Server
trademarks of Microsoft Corporation; IBM, OS/2 and DB2 trademarks of
International Business Machines Corporation; Linux is a trademark of
Linus Torvalds. All other trademarks are trademarks of their respective
Author: Gregor Leipelt