sap ase - Does Sybase ASE 12.5 support Common Table Expressions?

Question

I noted that Sybase SQL Anywhere supports them, but can't find any documentation on ASE also doing so.

If it doesn't, what would be my best option for designing a recursive query? In SQL Server 2008 I'd do it with a CTE, but if that's not available? A function perhaps?

Answer 1

Sybase ASE 12.5 (and also 15.0) doesn't support CTE.

---

You can use a inner query to solve your problem.

A simple CTE like this:

WITH Sales_CTE (Folders_Id)
AS
-- Define the CTE query.
(
    SELECT Folders_Id FROM Folders
)
SELECT Folders_Id FROM Sales_CTE

is the same as this:

SELECT aux.Folders_Id
FROM (SELECT Folders_Id FROM Folders) aux

For a litle more info, check this!