SQLWays Product Page
Free Evaluation
This article describes SQLWays testing options, their usage and output generated.
The databases supported are: Sybase Adaptive Server Enterprise, Oracle and Microsoft SQL Server.
There are two ways of specifying the option TEST when running SQLWays:
Option TEST is used to generate the calling statements for procedures or functions converted either from scripts or from the database. If this option is set the conversion is not performed, only calling statements are generated. Please, refer to the following example:
Assume you have the source Sybase ASE procedure. If the TEST option is not specified the conversion to Oracle is as follows:
Table1
| Sybase ASE | Oracle |
|---|---|
| create procedure sp_proc as declare @x int select @x= 2 GO | create or replace procedure sp_proc as v_x NUMBER(10,0); BEGIN v_x := 2; END; |
When the TEST option is ON the following calling statement is generated instead of the converted syntax:
Table2
| Sybase ASE | Oracle |
|---|---|
| create procedure sp_proc as declare @x int select @x= count (distinct col1) from Tab1 return @x GO | CALL sp_proc(); |
Discussion