SnowConvert AI – Funktionale Unterschiede bei Synbase IQ

Bemerkung

Konvertierungsbereich

SnowConvert AI for Sybase IQ focuses its assessment and translation capabilities primarily on TABLES, VIEWS, STORED PROCEDURES, and FUNCTIONS. While SnowConvert AI 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

Beschreibung

Snowflake unterstützt das Aufrufen einer gespeicherten Prozedur in der FROM-Klausel, sofern die Prozedur bestimmte Bedingungen erfüllt; andernfalls schlägt die Abfrage fehl.

Codebeispiel

Eingabecode:
Sybase
 SELECT * FROM MyProcedure(1, 'test');
Copy
Generierter 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

Beschreibung

Snowflake enthält keine Indizes zur Optimierung von Abfragen.

Codebeispiel

Eingabecode:
Sybase
 SELECT * FROM TABLE1 FORCE INDEX (MyIndex);
Copy
Generierter Code:
Snowflake
 SELECT
  *
FROM
  TABLE1
--         --** SSC-FDM-SY0002 - FORCE INDEX IS NOT SUPPORTED IN SNOWFLAKE **
--         FORCE INDEX(MyIndex)
                             ;
Copy

Best Practices