Tools
-
xmlspreadsax.p
by Tom Bergman 26 Nov 2007
xmlspreadsheet.p
by Tom Bergman 21 May 2006
- XMLSpreadSAX.p / XMLSpreadsheet.p is program that will create an Excel XML spreadsheet from a temp-table.
It works great for what I've used it for so far but like everything else, should probably be
considered a work in progress (no pun intended). It supports styles, hyperlinks, column
sizing and a bunch of other stuff documented in the comments at the top of the program.
XMLSpreadSAX.p requires the SAX writer, so it must be V10.1+. If you're on V9, or V10.0, use XMLSpreadsheet.p.
Of course, if you have a version of ABL with the SAXwriter object, it is much faster.
This will, of course, run on any OS as it does not use Excel at all.
-
Procedure Manager
by
Tim Kuehn, TDK Consulting Services
08 Feb 2007
-
The procedure manager was written to enable writing and controlling
- procedure's scoping configuration,
- when a new procedure instance is created,
- how long each procedure instance remains instantiated,
- which procedures are considered to be parents to other "child" procedures,
- when a procedure is no longer required and will be deleted.
-
Query Manager
by
Tim Kuehn, TDK Consulting Services
18 Sep 2006
-
The query manager was created to abstract commonly-performed life-cycle
management of static and dynamic queries, and browses into a standard block of 4GL / ABL code.
The query manager provides support for:
|
Query String Converstion |
|
Create / Import / Delete Queries and Browses |
|
Associate Queries & Browses in the manager |
|
Browse UI Control |
|
Query Control - Joins and Searchs |
|
Query Control - Range Value Searches |
|
Query Control - Single Value Searches |
|
Query / Search - Open, Refresh, Reposition, and Close Control |
|
Query Attribute Inquiry |
|
Query First/Last Break Condition Support |
|
Table Field Values |
-
Session Variable Manager
by
Tim Kuehn, TDK Consulting Services
20 Apr 2005
-
The variable manager is a super procedure which can replace the
functionality usually provided by SHARED and GLOBAL-SHARED variables,
as well as adding functionality such as access permissions.
-
Browser Builder
by
Stefan Houtzager
14 Mar 2005
-
This is a dynamic browserwindow, fed from a minimal repository to
get the UI and query. It should compile starting from 9.1D as it
makes use of the CALL object. The browser uses the famous
arrow-bitmaps to indicate asc and desc sorts, but contains more
suprises for keen eyes. ;-) You can easily maintain the repository
with the "browserbuilder" utility that I have put in this package also.
-
Directory Tools
by
Tim Kuehn
11 Jan 2005
-
dir-tools.p can be used to work with files and directories and:
- obtain file information for a specified directory level or for an entire directory tree.
- compile programs and saving r-code to a target directory tree
- copying files and directories
- merge multiple directory trees to a target directory path
- delete files, directories, and directory trees
- show a status to the user as it works
A sample program is included to demonstrate how to use the toolset.
-
ProgressDynamics21PCaseXML.zip
by Veli-Matti Korhonen
10 Apr 2004
-
ProgressDynamics21PCaseXML.zip contains an XML file
which can be imported to a new PCase project.
It includes Dynamics 2.10A01 Database definitions, relations and
sub-views similar to the views in Dynamics Repository Reference.
Please notice that this version of XML does not inclulde
field r-positions. As you import this XML to PCase the
r-positions will not have same values as the ones in Dynamics
repository (ICFDB). IAP has a procedure available where you can
fix update r-positions by connecting to Dynamics repository
(ICFDB) after importing the project.
Normally developers should not make changes to the Dynamics repository,
so this should not be a problem.
There is also a style sheet for the XML so it can be directly viewed
as a report without PCase (only XML and stylesheet is needed).
You can also
view the XML directtly from the PEG website.
-
becom.zip
by Yuriy Setko
13 Nov 2003
-
BECOM - BEtter COde Maker - is a group of programs written
on P4GL and available in source-codes, which suppose to make
your P4GL code looking better, more clear, readable and
understandable. View the
readme file .
-
ZXdb8to9
by John Heggie
14 Sep 2001
-
For Progress users that are in the process of
migrating their existing version 8 database to version
9, ZXdb8to9 can take the guess work out of defining
storage areas, area names, area numbers, records per
block and extent sizes. Creates the database
structure and data definition files automatically for
your new version 9 database.
-
Linux xterm PROTERMCAP entry
by Dave Records
17 jan 2001
-
This is a setup for protermcap that works well. Only problem
has been the Delete key, for some reason I can't seem to get it
to recognize it. You could put this in your home directory,
just point PROTERMCAP to this file if you can't add it to the
$DLC/protermcap file. TERM should be set to xterm, and there
may be an existing xterm in the protermcap file that
you should rename.
-
Database Blocksize Optimization Spreadsheet
by Bill Landin
27 apr 2000
-
Prior to version 8, you didn't have any choice in selecting
the database record blocking. Version 8 allowed 4 choices:
1K, 2K, 4K, and 8K and version 9 allows 35 combinations of
blocksize and numbers of records per block.
Since Progress uses variable size records, it was thought that
trying to calculate the "best" blocking for a specific database
was too difficult. The best advice was to try d&l into each then
select the best or since the database overhead was about the same
for each blocksize, to use the 8K blocksize. (I fell for this one
and have regretted it ever since.)
After a lot of research and experimentation, I've developed a
spreadsheet that will help you determine the optimum blocksize for
your specific database. It's really easy to use, just
plug-in the numbers from a "tabanalys" and examine the "best"
choices (both for V8 and V9). It is limited in scope -- it can't
tell you how big your database will be after the d&l, it doesn't
predict the space required for the index blocks, and it can't
tell you what the best size will be in 6 months. You will still
need your own judgment and experience for selecting the final
choice, but it sure beats spending days doing d&l
(especially with V9).
-
ProBuddy
by ZX Systems, Inc.
-
ProBuddy is a tool that displays the Progress database layout
in a more robust presentation. All your databases along with
it's tables, fields, indexes and data content are easily
accessible. Use ProBuddy to help your developers better
understand the database and data content they are developing
the programs for. A helpful 'where used' utility to show all
the tables and indexes using a specific field in all the databases.
Instant sorting of fields by field name, data type , format, order,
description, label, help description and extent. A useful scratch
pad to paste in field names, tables, indexes, and custom find
statements. Download a trial version today.
-
Adam Backman's UNIX DBA Scripts
by Adam Backman
-
Adam has made his unix DB Mgmt scripts available. There is a
README
file and a
README.registery which you should read and understand
before moving forward on the scripts. The programs gunzip into
a backman.tar file, which untars into a scripts directory. There
is also an on-line
script browser for the curious.
If you need some format other than gnu zip, let
me know.
-
JProgress
by Brad Long
-
JProgress allows connectivity from Java to a Progress DB
(versions 7 or above). It runs on any platform with a
JVM (NT, UNIX etc.).
JProgress is a middleware software solution written 100% in Java.
This means that it will run on any platform running a JVM.
It allows Java code to connect to a Progress DB. Progress
database versions 7 and above are supported. The Java code
can be an applet, application, or servlet. JProgress provides
an n-tier software architecture which is excellent
for running software over a LAN, WAN, and Internet. JProgress
can run in standard mode or blast mode. Blast mode is a new
operating mode that provides fast connection management for
Progress DBs. Blast mode options are a superset of standard
mode options (standard mode exists for ease of use and
backward compatibiem). The unregistered version of
JProgress is free. The current version is an alpha version of a new
release.
-
PPlist
by
Koen.Dejonghe@origin-it.com
-
Here's a program that might make your programming life a little
easier. Pplist is a tool that scans a Progress source code for
all subprograms/includes and does this recursively until the bottom
line has been reached. It searches for programs in all directories
declared in $PROPATH. For more information see the
HTML help file.
-
Tom Bascom's Profiliing Utility
by Tom Bascom
- Tom Bascom's Profiling Utilities
-
ScanDB
by Peter de Jong
- Scandb will scan any Progress V6, V7 and V8 database,
calculate the dbkey and compare this dbkey with the one
found in each database block.
Can be run while database is online.
- cmtzap.c
- A utility written in C to remove comments from
PROGRESS source code. Useful for Y2K investigations.
-
Inc
by Brad Long
- inc scans Progress files for included files and programs.
The current version is 4.0 which was released May 27, 1999. The
prior version was inc.c V3.0.
-
PROGRESS Application Profiler Zip package
- This is the Application Profiler everyone's been talking about.
A readme file contains a bit
of additional information you may find useful. The utility is
unsupported, so you'll have to address any questions you have to
the progress-list peg@peg.com.
-
PROGRESS ATM Benchmark Zip package Updated 03 may 2000
- This is a zip file contains the unsupported PSC ATM Benchmark.
The zip archive appears to have been created under DOS, so you'll
want to unzip -aL atm.zip if you're running unzip on UNIX.
the ATM Benchmark Source in tar file
-
EMACS PROGRESS MODE package
by Dave Eddy
- For EMACS users, progress-mode.el. Also available in
gzip
and
bandwidth wasting full text format