SQL Archives - Page 32 of 37

More Transparency Needed For Open Source Running on IBM i

July 25, 2018 Alex Woodie

Open source may be the future of IBM i. It certainly seems that way at the moment. But if open source is going to soar to new heights on the platform, it will need better integration with the existing processes in place to monitor and manage the platform.

That’s the opinion of JK Grafe, the CEO of Quad Nova Group, a Jacksonville, Florida-based IBM i consultancy that has offices up the Eastern Seaboard. By Grafe’s own admission, open source is a great thing for the platform. But the difficulty in seeing what’s actually going on with open source workloads …
Read more
PTC Refines Handling Of IBM i Database Logic

July 18, 2018 Alex Woodie

More organizations are moving business logic from RPG and COBOL programs into the DB2 for i database, which most community members agree is a good thing. The IBM i server’s core strength is its integrated a database, after all. However, when business logic moves into the database, it requires customers to rethink how they’re managing the code, which is a mantle that PTC has taken up with its Implementer software change management (SCM) tool.

When it comes to application modernization, fancy HTML5 screens and mobile apps usually grab the spotlight. We’re often moved by the things we can see, and …
Read more
Trinity Guard Gives Audit Tool A Friendly GUI

June 25, 2018 Alex Woodie

IT professionals who are tired of using 5250 greenscreens to manually conduct regulatory audits of their IBM i systems may be interested in a colorful piece of software from Trinity Guard. The company recently launched TGCentral, which is a unified HTML interface designed to simplify the configuration and execution of security and regulatory audits across multiple IBM i servers.

As the spiritual and intellectual successor to PentaSafe, Trinity Guard understands how beloved those old PentaSafe products were. Even though NetIQ/Attachmate/Micro Focus has not added any new features to its IBM i security suite for over a decade, there were …
Read more
Guru: Table Value Constructors Build Tables On The Fly

June 25, 2018 Ted Holt

Because I wish to be as valuable and productive as possible to the people who pay me to program their computers, I continually search the Web for new ideas and techniques. Doing so often leads me to sites that cater to other computing platforms. Today I want to share with you some SQL techniques that I learned from Microsoft SQL Server professionals.

These techniques are based on the Table Value Constructor (TVC), which is a group of data values, usually literals, organized into rows and columns. In its simplest form, a table value constructor is literal tabular data that is …
Read more
Guru: DB2 For i XML Composition And The IFS

June 11, 2018 Michael Sansoterra

Hey, Mike! Regarding Composing An XML Document From Relational Data, Part 1, I have built an XML document using DB2 and i. When I run the query, I get a worthless result set. How do I use the SQL XML functions to get a usable XML file?

This question comes from reader RA, and he doesn’t exaggerate. The result set from his XML-based query looks like this:
```
....+....1....+....2....+....3....+....4....+
************Beginning of data************** 

XMLDATA 
-------- 
#CGULIB#

  1 RECORD(S) SELECTED.

 ************End of Data********************
```
Notice that DB2 for i does nothing to make the XML attractive to human eyes as the entire XML …
Read more
Guru: Refactoring into Routines

May 7, 2018 Ted Holt

In RDi and Refactoring, I illustrated the process of refactoring by taking code of a very old style and converting it little by little into something modern. I promised to write more about the subject, and today I fulfill that promise.

The things I did in that first article — removing indicators, removing the COMP op code, removing GOTO, and renaming variables — are great, but they are not the only refactoring techniques. One of the best ways to refactor is to create new routines or improve existing routines, especially routines that can stand alone.

To illustrate, I’ll begin …
Read more
Guru: LTRIM + RTRIM > TRIM

April 2, 2018 Ted Holt

When IBM enhances SQL for my favorite database management system, I feel so happy I could dance like Karlos Klaumannsmoller selling diabetes medicine. It is my pleasure today to let you know (in case you don’t already know) that IBM has once again enhanced two SQL functions to make them as powerful as their RPG counterparts.

The functions to which I refer are LTRIM (left trim) and RTRIM (right trim). Until recently these functions could only remove blanks (or hexadecimal zeros, for some data types) from the beginning (left) or end (right) of a string. IBM recently added …
Read more
Insurer Chooses IBM i Database Re-Engineering Over Migration

March 26, 2018 Dan Burger

How do you want your database designed for the future and what problems have you created in the past that need to be fixed before you can think about the future? Old databases, originally designed for a business environment that has changed and continues to change, are not compatible. You may not be feeling any pain today and you may have no plans to change your business/IT alignment in the future, but much of the technology-driven business world is changing, which at some point will leave you alone on an island with a boat but no motor and no paddle. …
Read more
Guru: More Date And Time Conversions Using SQL

March 26, 2018 Ted Holt

Since many, if not most, IBM i shops store dates and times in numeric and character fields, it behooves those of us who program those systems to understand all available date- and time-conversion tools. A conversation with a fellow attendee of the recent RPG & DB2 Summit made me realize that I had not written about certain SQL conversion methods.

IBM i programmers need to convert date, time, and timestamp data from one format to another for at least two reasons. First, we can’t do date and time arithmetic with numeric and character fields. Second, the people whom we serve …
Read more
TEMBO Bolsters Database Modernization Kit

March 26, 2018 Alex Woodie

TEMBO Technology Lab is shipping a new release of its software designed to help IBM i shops modernize their databases for the SQL age. The South African company made mostly minor tweaks to its flagship product, dubbed AO Foundation, which should position the product to do more down the road.

Since it entered the IBM i discussion in 2012, TEMBO has been building database modernization tools and evangelizing the benefits of the SQL Query Engine (SQE) as the modern, up-to-date database engine that IBM i shops should strive to use, as opposed to the older CQE engine that used DDS …
Read more

Previous Articles Next Articles

Content archive

Recent Posts

Subscribe

Pages

Search