(Derik Hammer) A globally unique identifier (GUID) is a great way to identify a record in your database. It can be easily created at the database or application layer and, when generated, is guaranteed to be unique regardless of other records already written. It doesn’t require a sequence or an iden
Author: SSWUG Research
Dynamic Compound Statements In DB2 For i
(Michael Sansoterra) Dynamic compound statements are sure to be one of the most oft used new SQL features in IBM i 7.1. In general, this feature allows developers to execute a complex set of SQL statements that include variable use, error handling, and conditional logic on the fly without creating a
12c Online Partitioned Table Reorganisation Part II (Move On)
(Richard Foote) In Part I, we looked at some of the issues associated with locking and unusable indexes when Moving both tables and table partitions.
Accessing Custom Attribute Property from ADF UI Expression
(Andrejus Baranovskis) You may not know, but it is possible to access custom property defined for the VO/EO attribute from ADF UI expression. This may turn useful, when implementing custom generic functionality and standard attributes are not enough.
HTML5 Gantt Chart improvements, including XML import/export
As previously announced, an important set of improvements for our GanttChartView and related controls for HTML5 and JavaScript has just been released; some of the new features have also been forwarded to the ASP .NET and WinRT products, as appropriate:
DB2 10.1 fundamentals certification exam 610 prep, Part 4: Working with DB2 Data using SQL
(Amyris Rada and Renu Sharma) This tutorial shows you how to use SQL statements such as SELECT, INSERT, UPDATE, DELETE, and MERGE to manage data in tables of a SAMPLE database. It also shows how to perform transactions by using the COMMIT, ROLLBACK, and SAVEPOINT statements, how to create stored pro
DB2 Application Design for Big Data
(Lockwood Lyon) Current use of the term Big Data is a result of the confluence of several industry trends over the last decade. These trends include the accumulation of large amounts of data in databases, the advent of large-scale enterprise data warehouses, multiple means of high-speed data transfe
Adaptive Optimization Limitation Example
(Bobby Durrett) I’ve been reading up on Oracle 12c to get certified and to help advise my company on potential uses for the new version. I’ve been looking forward to researching the new Adaptive Optimization features because it makes so much sense that the database should change its plans when it f
Reorder Elements in a List Through Mouse Using jQuery
(Anubhav Chaudhary) This article explains how to reorder elements in a List using the mouse using jQuery.
Testing Which ASCII Characters Break JSON (JavaScript Object Notation) Parsing
(Ben Nadel) This title of this blog post is a bit of a misnomer, so take it with a grain of salt. Basically, I have found that in my AJAX-driven applications, certain characters, embedded within a JSON (JavaScript Object Notation) payload, break the parser and throw a syntax error.