SQL Tips for DB2 LUW

with Tags: sybase

Featured Blog Entries

All posts

The trouble of combining DISTINCT with ORDER BY

Comments (4) Visits (44211)

Motivation Yesterday one of my coworkers from India asked for my help in migrating the following SQL statement from Sybase to DB2. SELECT DISTINCT c1, c2 FROM t ORDER BY c3 When this statement is run in DB2 (assuming the appropriate definition of "T") the following error is being returned: SQL0214N An expression in the ORDER BY clause in the following position, or starting with "C3" in the "ORDER BY" clause is not valid. Reason code = "2". Why does DB2 raise this error? The reason is simple: It's not... [More]

Tags: olap by distinct order row_number sybase over

Migrating from TSQL: The DATEADD function

Comments (5) Visits (17205)

Background When our team added compatibility for DB2 with Oracle applications we learned that no two functions were compatible between Oracle and DB2 as far as date-time arithmetic was concerned. We ended up adding an entirely new library to achieve compatibility. It appears the difference between DB2 and MS SQL Server is equally profound in this area given that I was recently asked to provide a match for the DATEADD() function. DATEADD() This TSQL is a bit of an odd one. It takes three arguments: A "measure" The measure can be... [More]

Tags: sql timestamp microsoft dateadd sybase server tsql arithmetic datetime

Blogs

SQL Tips for DB2 LUW

About this blog

Links

Tags

Recent tweets

The trouble of combining DISTINCT with ORDER BY

Migrating from TSQL: The DATEADD function