Sybase Features

Question

Does anybody know if Common Table Expressions and User-defined functions (not from Java) are supported on Sybase 12.5? I'm trying but could not seem to make these work. Thanks guys.

There is some info in related question here: http://stackoverflow.com/questions/4803573/does-sybase-ase-12-5-support-common-table-expressions — Lukas Eder, Sep 04 '11 at 08:42

score 0 · Answer 1 · answered Aug 24 '12 at 04:19

Sorry I have to disagree. Microsoft SQL Server is based on Sybase 7.0. So there may not be Common Table Expressions and User-Defined Functions, there are equivalent ways to do the same thing.

For example CTE can be done either in nested queries or via temp tables using a number sign (#) in front of the table name.

For User Defined Functions, create a stored procedure with simple SQL code and call it via the exec function for example "exec my_sql_code". This allows nesting of stored procedures.

Good SQL, good night.

We are talking about 'feature' availability. What you've mentioned are workarounds. — , Aug 24 '12 at 08:06

score 0 · Answer 2 · answered May 31 '11 at 19:17

0

Both are not supported by ASE 12.5

answered May 31 '11 at 19:17

Jarek Bielicki

856
6
16

score 0 · Answer 3 · edited Nov 25 '11 at 12:22

0

You can use stored procedure instead of functions. I am not sure about what you are referring to by saying common table expressions

edited Nov 25 '11 at 12:22

George Duckett

31,770
9
95
162

answered Nov 25 '11 at 12:13

Aditya

549
1
6
11

Sybase Features

3 Answers3