SQL Tips for DB2 LUW

Submit a question

Entradas de Blog Apresentadas

TODAS AS PUBLICAÇÕES

• Classificar por:
• Data ▼
• Título
• Curtir
• Comentários
• Visualizações

DB2 Tech Talk: SQL Tips and Techniques, Leverage the Power of SQL | | Visits (7266) Tweet 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] Marcações:  recursive featured power nested sql query

Now, where did that come from? Getting more out of your error messages. | | Visits (8559) Tweet Motivation Have you ever received an error message that left you scratching your head? Of course you have. Matter of fact I for one cannot recall any software product that ever outright impressed me with the quality of their error messages. DB2's messages, overall tend not to be too bad compared to what I have seen with competitors when it comes down to regular SQL. But things get really interesting when you add SQL PL (or PL/SQL) to the mix. "My" product OpenPages is chock full of tens of thousands of lines of PL/SQL and recently... [More] Marcações:  error source message line number sqlstate sqlca origin sql sqlcode runtime

Finding and releasing the handbrakes on JDBC: enableExtendedDescribe | | Comments (2) | Visits (7534) Tweet But first, what's up with Serge? OK, I haven't been posting for a long time, but I do have a good excuse. Some six months ago I switched jobs from being " SQL Architect for DB2 for LUW " to being " Chief Architect for OpenPages " . OpenPages is a product IBM acquired some two years ago that is leading in the eGRC (enterprise Governance, Risk, and Compliance) space. Coming from deep in the bowels of DBMS development covering a three tier architecture, Java and a host of Web UI interfaces is challenging, but just what... [More] Marcações:  java network performance jdbc db2 enableextendeddescribe

DB2 Tech Talk: DB2 pureScale + HADR for Always Available Transactions, DB2 10.5 | | Visits (6102) Tweet There is another DB2 Tech Talk coming up this week on Thursday June 20, 2013 at 12:30 PM EDT. Transaction system availability is always a key issue, and the all-new DB2 10.5 for Linux, UNIX and Windows includes a series of enhancements that make it faster and easier for you to ensure the level of availability that stakeholders in your organization expect.   Join IBM architect Aamer Sachedina for an in-depth discussion of the enhancements in DB2 10.5 that help ensure 'always available' transactions. DB2 pureScale provides two major... [More] Marcações:  availability purescale hadr capacity

Distinctly weak type rules with a constrained twist | | Visits (6715) Tweet 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] Marcações:  type alias weak rules subtype constraint domain check featured distinct

DB2 Tech Talk: Deep Dive on BLU Acceleration in DB2 10.5, Super Easy Analytics | | Visits (6575) Tweet It's almost time for another DB2 Tech Talk. I think this will be particularly interesting for DBAs that have heard about BLU Acceleration and are craving more technical information about this exciting new technology. BLU Acceleration in DB2 10.5 for Linux, UNIX and Windows delivers results from data-intensive analytic workloads with speed and precision that is termed "speed of thought" analytics.  Join IBM Distinguished Engineer and DB2 expert Sam Lightstone for an in-depth discussion of the all-new BLU Acceleration features... [More] Marcações:  analytics columnar blu acceleration compression

More family matters: Selected common SQL features for developers of portable DB2 applications | | Visits (6707) 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 developerWorks article with... [More] Marcações:  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 (5982) 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 data-intensive analytics... [More] Marcações:  purescale acceleration hadr analytics nosql blu

In the PIPE: Compiled SQL PL and PL/SQL Table Functions | | Comment (1) | Visits (11236) 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] Marcações:  function pl featured table pl/sql pipelined sql pipe

Full reverse: A REVERSE function that handles unicode | | Comments (6) | Visits (15811) 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] Marcações:  utf8 reverse 1208 unicode index