(Ged Mead) The Split function is quite versatile and frequently useful. One scenario I looked at recently was where the task was to find a user name in an ini file. Here’s how I went about it.
Other News
Two Kinds of Big Data
(Rob Gonzalez) With all the hullabaloo around Big Data, I’ve been a little surprised that there hasn’t been more talk about how to consume the vast petabytes that people are talking about…until I realized that there are really two Big Data problems out there!
SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction
(Pinal Dave) In SQL Server Denali, there are three new conversion functions being introduced, namely:
Splitting a Range Partitioned Table
(Hemant K Chitale) Here’s a simple demonstration of splitting a Range Partitioned Table :
Error converting data type varchar to float
(Vadivel) One of the forum member had posted a question yesterday saying she was trying to use a CASE statement and it was throwing an error as “Error converting data type varchar to float”.
Security Functions of IBM DB2 10 for z/OS
(Paolo Bruni, Marcelo Antonelli, Hyun Baek, Rick Butler and Ernie Mancill) IBM DB2 9 and 10 for z/OS have added functions in the areas of security, regulatory compliance, and audit capability that provide solutions for the most compelling requirements.
Primary keys from experience
(Giuseppe Maxia) From time to time I see articles in defense of natural primary keys against surrogate keys. I don’t take an immovable stand on either side, as I have seen good cases for both. In general, I like the idea of a natural primary key, when I see one that it is really natural. Quite often
Preserve the node states on a custom TreeVew
(JRINC) I worked a few weeks in an application that required the data to be displayed in a hierarchical structure that exemplify and make it easier to understand the structure of this information in particular.
Development using InfoPath: Part I
(Destin Joy) InfoPath is a software application for developing XML-based data entry forms. The main feature of InfoPath is its ability to author and view XML documents with one-to-many links among different data groups in an XML schema.
Informix DBA: Informix Warehouse Accelerator
(Lester Knutsen) At the end of March, IBM announced the new Informix Warehouse Accelerator (IWA) for Informix 11.70.xC2. I have been beta testing this accelerator for a while and would like to share some of my findings with you.