09/01/2011
Stored information is only worth anything if you can get it when you need it, so a tool that makes it easy to retrieve that data from across multiple computers and database systems is very valuable. Meet SQuirreL SQL: a robust, open-source solution that lets you do just that on any JDBC-compliant database, including DB2 for i—and its price is unbeatable.
03/01/2010
Gone are the days when you had to write a subroutine just to transform a character field into a number or number into a character. SQL's built-in functions offer many ways to make the transformation between data types. Check out the basics.
02/01/2010
As information providers, developers and data analysts need good, reliable tools to work with date-based information. This article focuses on SQL- and Excel-based tools that can help you better work with those all-important dates.
11/12/2009
The WITH clause is a powerful yet little-known technique in SQL that can make it easier to read your SQL statements, plus help with performance.
11/01/2009
Decreasing revenue means you should be prepared to discuss what IT "stuff" you can get rid of to ease the financial burden without upsetting operational efficiency.
08/01/2009
Simplify your SQL work by using the CASE statement to execute code based on conditions.
07/01/2009
The IBM i development pond is stocked with acronym after acronym. Learn what the letters mean and help your company choose which ones to reel in.
06/01/2009
Using SQL in your RPG applications is an elegant way to modernize and streamline your programs. Find out how easy it is to use embedded SQL for database retrieval—without the need for F specs.
03/01/2009
If webfacing is your game, check out the solutions available to take your applications to a new interface.
02/01/2009
The i system OS provides a robust set of messages to communicate between applications and users. These messages are key in most troubleshooting situations. Learn how to use them effectively to better manage your system.
01/01/2009
If you want a technology team that truly understands what your company does, you need to immerse these people in the company’s core business.
12/01/2008
Technology workers are often thought to lack conversational tact, but you can follow these steps to master the Art of No and avoid alienating co-workers.
12/01/2008
Ever wanted to make your RPG service programs into web services but didn't really know where to start? This article offers a helpful how-to guide on creating RPG web services and testing them. To make the deal even sweeter, you can do it all within one tool: WDSc.
12/01/2008
i5 developers are fiercely loyal to their platform, but IBM's refusal to produce a native web UI is testing that loyalty for some. Here's how IBM can make its i5 developers happy and turn a profit at the same time.
08/01/2008
Cascading Style Sheets (CSS) can do more than make a web page more visually appealing they can help make your whole website more flexible and functional. This article shows some CSS basics to get you started.
06/01/2008
When the amount of i5 objects on your system becomes too large and impossible to manager, never fear RSE has the perfect solution: filters. Learn how to utilize RSE to manage those cumbersome lists of objects by learning how to create, manage, and edit filters. For even more organization, learn to create and use filter pools.
05/01/2008
Despite the doom that many have cast on our beloved i5, it is still around and advancing in some areas. But there is always room to do better.
03/01/2008
Version 7 of WDSc has a huge selection of options that help you customize your experience. This Essential Guide covers some of those that are most important to System i developers.
02/01/2008
Determining the workstation requirements of a System i programmer is as much art as it is science and depends not only on the programmer's job description but also on that programmer's personality. Put on your psychoanalyst cap and check out these guidelines.