Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer Sybase ASA to SQL Server Migration overview.

Ispirer SQLWays Database Migration Software

Non-Table Result Set Conversion from Sybase Adaptive Server Anywhere to Microsoft SQL Server

The DUMMY system table can be used in order to return non-table data as a result set in Sybase Adaptive Server Anywhere.

The SELECT statement without the FROM clause and a variable assignments returns non-table result set in Microsoft SQL Server.

SQLWays removes the FROM [SYS.]DUMMY clause when converting Sybase Adaptive Server Anywhere non-table result sets to Microsoft SQL Server.

Examples:

TABLE 72. Sybase Adaptive Server Anywhere - Microsoft SQL Server Conversion
Sybase Adaptive Server Anywhere
Microsoft SQL Server 
SELECT 1 
FROM  SYS.DUMMY 

SELECT 1  

SELECT 1
FROM  DUMMY 

 SELECT 1

Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.