SnowConvert: Sybase IQ Functional Differences¶

Note

Conversion Scope

SnowConvert for Sybase IQ focuses its assessment and translation capabilities primarily on TABLES and VIEWS. While SnowConvert can recognize other types of ANSI-standard statements, these are not yet fully supported for conversion. This means that while the tool may identify them, it won’t perform a complete translation for these unsupported code units.

SSC-FDM-SY0001¶

Calling stored procedure in from might have compilation errors

Description¶

Snowflake supports calling a stored procedure in the FROM clause when the procedure meets certain conditions otherwise the query fails.

Code Example¶

Input Code:¶
Sybase¶
 SELECT * FROM MyProcedure(1, 'test');
Copy
Generated Code:¶
Snowflake¶
 SELECT
  *
FROM
  --** SSC-FDM-SY0001 - CALLING STORED PROCEDURE IN FROM CLAUSE MIGHT HAVE COMPILATION ERRORS **
  TABLE(MyProcedure(1, 'test'));
Copy

Best Practices¶

SSC-FDM-SY0002¶

Calling stored procedure in from might have compilation errors

Description¶

Snowflake does not contain indexes for query optimization.

Code Example¶

Input Code:¶
Redshift¶
 SELECT * FROM TABLE1 FORCE INDEX (MyIndex);
Copy
Generated Code:¶
Snowflake¶
 SELECT
  *
FROM
  TABLE1
--         --** SSC-FDM-SY0002 - FORCE INDEX IS NOT SUPPORTED IN SNOWFLAKE **
--         FORCE INDEX(MyIndex)
                             ;
Copy

Best Practices¶

Language: English