Chris Pollach's Blog Site for up-to-date news and information on various Sybase products, technologies, and methodologies.
|
This is a PowerBuilder utiltiy designed to scan datawindow objects in PowerBuilder libraries from version 1.x though 9.x. The utility converts the "PBSelect" statement found in a normal DW object into it's production SQL syntax that would be used in production at run time. This SQL can then be saved in a normal text file and used for input into Sybase's SQLExpert product for a full in-depth analysis.
The SQLExtract utility is written in PowerBuilder 9.0.2 and requires the run time of the same vintage. It is available on Sybase's codeXchange at: http://powerbuilder.codexchange.sybase.com/servlets/ProjectDocumentList?folderID=409