Progress Code Examples
Progress Conference Presentations 2011-2018
- "All Types of Data Replication" presentation at PUG Challenge America, Nashua NH October 24-26 2018
- "DBAnalys to the rescue Part 2" presentation at PUG Challenge America, Manchester NH June 6-8 2016
- "DBAnalys" presentation at European Progress Conference, Copenhagen Denmark November 5 2015
- "DBAnalys to the rescue" presentation at PUG Challenge America, Westford MA June 6-8 2015
- "RDBMS Progress, Oracle and SQL Server in relationship with Big Data" presentation at PUG Challenge America, Westford MA June 6-8 2014
- "Performance Testing Progress and Oracle" presentation at PUG Challenge America, Westford MA June 6-8 2012
- "Progress and Oracle" presentation at PUG Challenge America, Westford MA June 6-8 2011
Progress DBA
- Replication Scripts for Unix
- How much db and bi extents are in use?
- How to create a partial Progress database backup?
- How to create .st file from a backup
- How to monitor the table and index usage statistics by the user?
- How to monitor before-image size?
- How to grow bi to its normal size ( bigrow )
- In what Storage Area are my Tables and Indexes?
- How to disconnect users with long transactions
- Check Lock Table size
- The Use of After-image Replication for Reporting
and replication scripts for Windows
- How to purge big table data
- AiScanStat.p A program to scan AI file with the "verbose" option and create stats per transaction ( by George Potemkin )
- DbBlockInfo.p A program that parses the standard block headers. It currently supports two types of the blocks - data and index. One can add the support for other block types. ( by George Potemkin )
- -zqil Start up parameter
- How to clear program cache (-q) ?
- List of the Progress Startup Parameters undocumented as well as "documented" ( by George Potemkin )
- Database attributes stored in master block, Timestamps of each database extents, Highwatermarks, Shared-memory segment and semaphore ID, Status of the process that opened database, Login statistics ( by George Potemkin )
- Windows NT script for Progress backup v8
- If Binary Load failed with error (6255) Progress V7-8
Oracle
- "Performace Testing Progress and Oracle" presentation at PUG Challenge America 2012, Westford MA May 6-9
- Toolkit for presentation at PUG Challenge America 2012, Westford MA May 6-9
- ATM Results, PUG Challenge America 2012
- "Progress and Oracle" presentation at PUG Challenge America 2011, Westford MA June 6-8
- Progress to Oracle Map
- My oracle page
Progress SQL 92
- How to create update statistics script
- How to check update statistics
- How to Query Progress Metaschema
Progress ABL
- How to make HTML Document of database schema ? ( like Data Dictionary )
- How to Walk the Procedure Call Tree (.p and .i) ?
- How to walk the widget tree ?
- Rcode-info
( by George Potemkin ) You can find version, size, rcode-crc, as well as initial, action, e-code and debug segments, internal procedure segments and frame segments, text segment, languages, code page etc.
- Data Dictionary. Report Tables and Fields.
- Data Dictionary. Report Indexes.
WebSpeed
- How to display MS-Word document in Embeded SpeedScript
- WebSpeed Broker Administration
- WEB-CONTEXT attributes
- SQL in Embeded SpeedScript
- CGI environment variables
XML and Progress 4GL
- XML Parser ( Progress V9.1 and up )
ED for Windows
- How to check Progress code syntax in ED for Windows
Dmitri Levin
PEG # 1998-03-27-06