SQL Tips for DB2 LUW

Submit a question

Featured Blog Entries

All posts

• Date ▼
• Likes
• Comments
• Visits

More family matters: Selected common SQL features for developers of portable DB2 applications | | Visits (668) Tweet Are you writing SQL applications that need to be portable across DB2 platforms? Are you looking for information to help ensure your DB2 applications are portable? Back in June 2012, Serge posted an entry called " Family matters: The SQL Reference for Cross-Platform Development " where he wrote about the DB2 family and the availability of Version 4 of the SQL Reference for Cross-Platform Development . I want you to be aware of some related cross-platform summary information that is also available.   A... [More] Tags:  featured i sql common unix luw cross-platform z db2 linux reference windows

DB2 Tech Talk: Introduction and Technical Tour of DB2 10.5 with BLU Acceleration on May 8th | | Visits (1061) Tweet As your DB2 Tech Talk host, I want invite you to join the next DB2 Tech Talk to learn the technical details behind the recent announcement of DB2 10.5 for Linux, UNIX and Windows  with BLU Acceleration software Distinguished Engineer and DB2 expert Berni Schiefer will lead us on a technical tour of the all new DB2 10.5 with BLU Acceleration software.  You will learn about new features of this  release such as: • BLU Acceleration, for “Speed of Thought” analytics Designed to handle... [More] Tags:  purescale featured acceleration hadr analytics nosql blu

In the PIPE: Compiled SQL PL and PL/SQL Table Functions | | Comment (1) | Visits (1226) Tweet Introduction A table function, as you will likely know, is a function that returns a number of rows instead of a single scalar value. Table functions can therefore be invoked in the FROM clause of an SQL statement, while scalar functions get invoked in expressions. Table functions are nothing new to DB2. They have been around with C and Java implementations since DB2 V5.1. And in DB2 7.1 we made them available in inline SQL PL by using the RETURN statement as the body of the table function. The C and Java table function implementation however,... [More] Tags:  function featured pl table pipelined pl/sql sql pipe

Full reverse: A REVERSE function that handles unicode | | Comments (4) | Visits (2237) Tweet Background This week a co-worker converting an Oracle application to DB2 contacted me and requested a REVERSE function. REVERS() is a function which reverses strings by reordering all the characters in reverse order. For example: 'Hello World!' becomes '!dlroW olleH'.  Not a terribly useful function within an application, generally speaking. However reversing strings can reduce contention on index pages when inserting rows into a table in ascending order.  At any rate, I have learned over the years that conversions are much more successful when... [More] Tags:  utf8 reverse 1208 unicode index

Size matters: A handy routine to compute the defined row size of a table | | Comments (6) | Visits (3263) Tweet Background Have you ever seen: "SQL0670N  The row length of the table exceeded a limit of "<length>" bytes. (Table space "<tablespace-name>".)" When creating or altering a table DB2 imposes limits on the total worst case size of a row. This size depends on the page size of the tablespace in which the table resides: 4005 bytes in a table space with a 4K page size 8101 bytes in a table space with an 8K page size 16293 bytes in a table space with an 16K page size 32677 bytes in a table space with an... [More] Tags:  table row width length size sql0670n 670 sqlcode pagesize getrowsize

DB2 Tech Talk: Inside Row and Column Access Control for DB2 10 for LUW | | Visits (1541) Tweet Many organizations are struggling to comply with data security and compliance mandates, while also reducing costs.  With the new row-permission and column-mask features, IBM DB2 10 takes security and ease of use to the next level. Join IM Information Management Chief Security Architect Walid Rjaibi for a deep dive technical discussion of the new Row and Column Access Control (RCAC) features in DB2 10 for Linux UNIX and Windows and InfoSphere Warehouse 10. Walid will also  teach you proven methods to implement data security in the most... [More] Tags:  db2 fine access rcac column talk tech row virtual private control database grained

Fractions of time: A PostgreSQL compatible DATE_PART function | | Visits (2138) Tweet Intro Anyone who has ever attended a talk of mine on SQL compatibility has heard my claim that "to support Oracle applications in DB2 we had to add a completely new date-arithmetic library of functions since no two functions operating on date appeared to be the same in DB2." Well, it appears PostgreSQL has its own set of functions yet again. So, sooner or later a request for the DATE_PART() function in DB2 was bound to pop up. Not having PostgreSQL available to test for an exact match, here is what I came up with: ... [More] Tags:  extract doy date_part epoch millenium century decade postgresql dow

DB2 Tech Talk: Deep Dive into the new PureData expert integrated systems! | | Visits (1928) Tweet The new PureData expert integrated systems are optimized for delivering data applications with simplicity and speed.   Join the architect of the PureData transactional and operational warehousing PureData products for a look at these new offerings, which feature DB2 for Linux as a core technology. We will explain how which type of workload goes on which system, how to leverage patterns, factory-optimized scalability and much more to speed deployment, ease administration and reduce development efforts.   Date: Nov 15th, 2012 Time: 12:30 ET More... [More] Tags:  expert talk tech integrated systems puredata appliance db2

Migrating from TSQL: The DATEADD function | | Comments (5) | Visits (4245) Tweet 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... [More] Tags:  sql timestamp microsoft dateadd sybase tsql server arithmetic datetime

DB2 Tech Talk: What's Hot from Information on Demand Conference | | Visits (1492) Tweet In case you have been hiding under a rock: IOD 2012 is nearly upon us!   So we figured it would be nice to present the next  DB2 Tech Talk straight from IOD and take a pulse of what's hot and what's cool. Circle your calendars for October 24, 2012 12:30 PM ET - that's 9:30 AM in Las Vegas. As always you can register at www.idug-db2.com.   See you there! Tags:  las iod 2012 vegas