SQL Tips for DB2 LUW

with Tags: featured

Featured Blog Entries

All posts

DB2 Tech Talk: SQL Tips and Techniques, Leverage the Power of SQL

Visits (5553)

The next DB2 Tech Talk is one that should be of interest to those that follow this blog. On April 10, 2014, Nick Ivanov, an IBM Senior Consultant, will present a talk called: SQL Tips and Techniques, Leverage the Power of SQL Those who follow this blog will already realize that SQL is a powerful language. The objective of this talk is to help you learn to use more of that SQL power. Join us to explore some of the less well-known features of SQL and see how they can help in some practical situations. We will also look at some common mistakes and... [More]

Tags: recursive featured power nested sql query

Distinctly weak type rules with a constrained twist

Visits (5140)

Background Back in the early 1990s when I first started working on database language architecture, DB2 for Linux, Unix, and Windows was a new DB2 database manager (I believe we called it DB2 for common servers back then) and making a big jump in the SQL that it supported along with implementing the Starburst compiler with the research team from the Almaden Research Center. During that time, we started to make SQL more user-extensible with user-defined objects for procedures, functions and data types. The first kind of user-defined data type was... [More]

Tags: type alias weak rules subtype constraint check domain featured distinct

More family matters: Selected common SQL features for developers of portable DB2 applications

Visits (5426)

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 developerWorks article with... [More]

Tags: featured i sql common unix luw cross-platform z db2 linux reference windows

In the PIPE: Compiled SQL PL and PL/SQL Table Functions

Comment (1) Visits (8463)

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 pl featured table pl/sql pipelined sql pipe

Making SQL PL and PL/SQL sensitive to changes in statistics, and more

Comments (4) Visits (6007)

Motivation Recently one of our major business partners submitted the following feature request: " Please make all the SQL in my SQL Routines dynamic! " Why, I asked, would you want to do that? If you make the SQL dynamic at lot of bad things would happen to your SQL: No dependencies are recorded anymore. So you do not know anymore with which objects the routine interacts SQL executes under "invoker's rights" That is the invoker of the routine or trigger would need the authorization to execute the SQL within. There will be... [More]

Tags: once reopt conservative bind binding runstats run option validate static dynamic featured always

Migrating OpenBravo from Oracle to DB2

Visits (5440)

When we started down the path of making DB2 compatible with Oracle Applications we wondered how to demonstrate the capability. It seemed unlikely that any application vendor would allow us to expose their Oracle Application to a public audience. Getting a custom application seemed not much more likely. But creating an artificial benchmark application would immediately cause suspicion that the workload is either too trivial or biased towards success. After a quite a bit of searching we found OpenBravo . This company sells an ERP product that is... [More]

Tags: oracle openbravo featured migration

Blogs

SQL Tips for DB2 LUW

About this blog

Links

Tags

Recent tweets