Unanswered: Sybase to DB2 - REWRITE function
i am new to sybase....
Was trying to use REWRITE function as given in documentation to convert TSQL to ANSI but its failing ...
SELECT REWRITE( 'SELECT DISTINCT s.ID, s.OrderDate, e.GivenName, e.EmployeeID
FROM SalesOrders s, Employees e
WHERE e.EmployeeID *= s.SalesRepresentative', 'ANSI' )
Number (14216) Severity (16) State (1) Server (WIPIBV6S115) Function 'REWRITE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
any pointers ?
Sybase ASE 12.5.4 (Does this version support this Fn. ?)
Certified DB2 9 DBA / Application Developer