SQL Extract Utility Application - (2026 R3) Released!

 ** Hot News **

Updated SQL Extract version 2026 R3

for Appeon PowerBuilder 2025 R2 

 

    Software Tool & Die Inc. (STD Inc) have just released a new version of the SQL Extract utility (version 2026.3.48) that can reverse engineer Appeon PowerBuilder's proprietary SQL format known as a PBSELECT into either ANSI, PL/SQL or T-SQL format from within any DataWindow (TM) object. The new version of the SQL Extract utility was designed to allow it to forward & reverse engineer the DataWindow source code from any Unicode based PowerBuilder library. This means that DataWindow source from PowerBuilder version 10 through PB 2017 can be parsed & the SQL run-time generated from a PBSELECT - just like when your DataWindows are actually running under control of your PowerBuilder based production applications! The utility will also identify DataWindows that are not using a PBSELECT format that may be already causing performance, migration or cross-DBMS issues.

 

Main App dialogue with new TabbedView & RibbonView features added!

    The output of SQL Extract is a textual based .SQL file that can be input directly into SQL syntax analysis  products like: SQL Parser; SQL Doctor; Aqua Data Studio; DB Optimizer; etc (to name a few products) for further SQL analysis, formatting, & tuning. STD successfully tested the new version of SQL Extract with SAP's latest SQL Anywhere 17 & ASE 16 as well as the Microsoft SQLServer 2017 DBMS system. SQL Extract can also handle other DB access mechanisms, such as: OLE-DB, ADO.net, JDBC, OData. Support for the ODBC db driver is still standard, but the native db drivers are fully supported as per the Appeon PB 2017R1 product feature set. For older ASE databases, SQL Extract also supports the Open Client (SYC) native DB driver access mechanism.

    The new version of the SQL Extract utility will also work with Appeon's PowerBuilder & InfoMaker 2025 R2 development tools as well, as those products also utilize the same DataWindow object technology. The new features of SQLXTract v2026R3 are as follows:

• Migrated the App code to PB2025 GA to PB2025 R2 version 25.1.0.6430.
• Revised SQL extraction logic to support "on the fly" DataWindow source conversion to PB2025 R2 syntax standard
• Tested SQL Extract with SA 17 and the new "PB Demo DB V2025 R2" database
• Added support for PB 2025's new RibbonView feature
• Added support for PB 2025's new TabbedView feature
• Tested SQL Extract on W11 version 25H2 build 26200.9278

 

    The SQL Extract utility application is open source and thus royalty free to use. You can download the SQL Extract application source code from its current location on the SourceForge website.

Enjoy!

Regards ... Chris