PowerBuilder Authors: Chris Pollach, Yeshim Deniz, Jayaram Krishnaswamy, Kevin Benedict, Avi Rosenthal

Related Topics: PowerBuilder, Containers Expo Blog

PowerBuilder: Article

Chris Pollach's PowerBuilder Blog: "SQLXTRACT New Release!"

I am pleased to announce that Software Tool & Die Inc. has just released a new version of the SQLXtract utility (10.2.1)

I am pleased to announce that Software Tool & Die Inc. has just released a new version of the SQLXtract utility (10.2.1) that reverse engineers Sybase's proprietary SQL format (PBSELECT) into ANSI, PL/SQL or TransAct SQL from the "DataWindow" object. The new version of the SQLXtract utility was mainly revised to allow it to reverse engineer the source code from a Unicode based library vs.. an ANSI format previously.

The output of SQLXTract is a textual .SQL file that can be input directly into products like Quest Central (aka SQLExpert) for further analysis. I have successfully tested the new version of SQLXTract with Sybase's ASE 15 and Microsoft's SQLServer2005 DBMS versions of Quest Central (by Quest Software). SQLXTract will also be able to handle the new Microsoft DB access mechanisms, they are: OLE-DB and ADO.net. Support for the ODBC db driver is still standard, but the native MS db driver support has been dropped because Microsoft no longer supports this feature. For ASE 15, SQLXTract supports ODBC, OLE-DB, ADO.net and Open Client (native) DB driver access mechanisms.

This new version of the SQLXTract utility will also work on Sybase's new "WorkSpace" 1.5.x development tool that incorporates DW.Java (java based DataWindow),  DW.Net 2.x (.Net 2.0 version of the DataWindow) plug-in for Visual Studio 2005, Infomaker 10.x (report writer), PowerBuilder 10.x and PocketBuilder 2.x (PDA version of PowerBuilder for Windows Mobile)! The support for all these other environments other than PowerBuilder is new to this version of SQLXTract!

The PocketBuilder version of SQLXTract is a special version and exists to handle the DW.wm (Windows Mobile DataWindow). The separate version will be a PocketBuilder application and is designed to handle unique features of DW.wm such as: SIP (System Input Device), Multiple Orientation, WM Fonts, etc. The support for these specific DW features can only be found in the PDA version. The PDA version of SQLXTract will be able to reverse engineer SQL into ASA DBMS format and soon, MS-SQLServer CE. The PocketBuilder version of SQLXTract is currently in Alpha, but is working well in my testing thus far and will be released separately to CodeXchange in the near future!

The PowerBuilder 9.0.3 (ANSI) version of SQLXTract has been available on CodeXchange for the past year.  SQLXtract version 10.2.1 can be downloaded from Sybase's CodeXchange (click here)!
Regards ... Chris
President: STD Inc.

More Stories By Chris Pollach

Chris Pollach is a Senior Consultant with over 30 years experience in Systems and Software Analysis, Development, Maintenance and Technical Support, mainly in the areas of GUI Design, MS-Windows Programming, Java / .NET Programming, Wireless, Application / Web Server Design & Programming, Object Oriented Development Tools and Methodologies, Data Base, Data Communications and Network application development. He has participated in numerous technical, planning and management roles, as well as consulted and educated in these fields for a diverse clientele. He is also the owner of “Software Tool & Die Inc.” a company dedicated to provide custom software and education solutions on Object Oriented business systems.

As an educator, Chris is certified to teach PowerBuilder (first in Canada), MS-SQLServer, Sybase’s Enterprise Application Studio and EAServer integrated application/web development environment. He is former Certified SilverStream developer (CSSD) and current Certified PowerBuilder Developer – Associate / Professional (CPD-P) as well as a Certified Sybase Tools Instructor (CSI).

Chris has written numerous articles in various popular personal computer magazines, newsletters and is the author of the PowerGuide and PowerExpert products as well as the STD Foundation Classes. Currently, Chris has developed a Foundation Class library for Sybase's PocketBuilder, SAP's PowerBulder and EAServer products and now Appeon Web & mobile products that integrates JSP or ASP web development, Section 508 / CLF web standards and mobile applications. A new Web Service framework has also been released for IIs to support PowerBuilder based web service NVUO's!

Chris recently became a 2nd Degree Black in the TaeKwonDo martial art and has developed a Martial Art multimedia study guide using the Component-One “Doc2Help” and Sybase PowerBuilder products. Since the fall of 2004 he became a TaeKwonDo instructor for the City of Ottawa’s Goulbourn program. He has also been certified with the World TaeKwonDo Federation (February 2005 - 1st Dan and October 2008 - 2nd Dan).

Chris was awarded the Sybase “Innovation and Achievement” award for 2005 as voted for by the International Sybase User Group (ISUG). This award was presented for innovations to the PocketBuilder mobile development product, contributions to the PowerBuilder News groups and support of the Ottawa Sybase User Group.

To round his management and leadership skills, Chris is the former president of the Kiwanis Club of Goulbourn and still volunteers his time with the service clubs in his area. He is also the coordinator of the Ottawa Sybase User group and a certified NAUI scuba instructor. For the last three years, Chris has been voted onto the ISUG Board of Directors and holds the position of "Director - North American User Groups".

Comments (1)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.