MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

June 22, 2012 | Volume 9 Issue 25


TOP STORY: TechTip: TO_CHAR: Formatting Dates in SQL
FEATURED ARTICLE: SolarWinds Offers Techies 25 Free Software Titles
NEWS HIGHLIGHT: Magic Software Announces Release of Mobile Offering for Business Application Development
BUYER'S GUIDE: Maxava HA Enterprise+ and Barcode 400
EVENT: SkyView: Coffee with Carol - Step by Step Approach to Implementing Object Level Security
BLOG: Maxava Appoints New Sales Management in Europe
Manage Subscription | Contact Us

Feature Article - TechTip
TechTip: TO_CHAR: Formatting Dates in SQL

ANSI SQL is extremely limited when it comes to date formatting, but DB2 provides a powerful extension that alleviates that problem.

joe plutaWritten by Joe Pluta

SQL is becoming ever more popular in most IBM i shops, and for good reason: it makes it very easy to do things that are perhaps not so easy in RPG. SQL also provides a standard interface to various tools that aren't specific to the platform, primarily through ODBC and JDBC. However, SQL isn't a silver bullet. There are things that are easier and faster in RPG, and some things that are nearly impossible to do in SQL.


Feature Article - System Administration
SolarWinds Offers Techies 25 Free Software Titles

If you're not monitoring your storage with at least one of them, that overloaded hard drive could jump up and bite you.

chris smithWritten by Chris Smith

I noticed my desktop PC slowing down last week, and I couldn't think why Betsy (I call her Betsy because she's like a good ol' gal) was beginning to balk under my gentle abuse. I began to peek around under her hoop skirt and realized that of 153 GB of usable disk space, her hard drive had only 844 MB left! I was shocked, I tell you—shocked!


MC Showcase Buyer's Guide

Maxava HA Enterprise+ delivers comprehensive High Availability and Disaster Recovery readiness for your IBM i. Maxava HA Enterprise includes all the functionality of the Maxava HA SMB version along with enhanced replication and tools necessary for more complex environments.


Secure, reliable replication of data, objects, spool files, IFS and MQ Series – Maxava HA Enterprise does it all, along with Command Scripting Function and maxView ; remote monitoring of your HA solution and key IBM i system resources from your web-ready mobile device.


Learn more about Maxava and its high availability and disaster recovery software solutions for IBM i systems here.



T.L. Ashford's award winning BARCODE400 software is the labeling answer for the iSeries. With this versatile and easy to use software you will be designing and printing labels in minutes. Compliance labeling is a snap using templates provide by TL Ashford.

Learn more about T.L. Ashford & Associates and its Barcode and RFID solutions here.


Want to feature your company products? Click here or call (208) 726-6822 for information.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor






Search Sponsor