Specify a DB Parser to Analyze the SQLs Embedded in PowerBuilder - [Settings]

When analyzing PowerBuilder code, Visual Expert will isolate embedded SQL queries and pass them to a generic database code parser. This works fine as long as your embedded SQL does not include specific syntaxes for a particular database engine.

In that event, you can select a specific database parser (Oracle or SQL Server), instead of the generic one - for analyzing the embedded SQL queries:

  1. Go to [Code Analysis - Select Source Code]
  2. Select the source of code related to your PowerBuilder code
  3. Click on “SQL Parser” and select a database parser
  4. Close this window and run a new code analysis

Select a database code parser to analyse sql queries embedded in PowerBuilder

 

Visual Expert 2019, Oracle, SQL Server, PowerBuilder