|
SEQUEL ViewPoint®--Data Access & Analysis for Power Systems™ Servers
· Easy to use by IT and end users
· Automated data access and display
· Complete BI package: reports, tables, key
performance indicators, and dashboards
· IBM i-centric for real-time data analysis
· Expert support and training
· Secure data access
· Green screen, Web, browser
SEQUEL--Fast, efficient & cost-effective data analysis
Click here for a FREE Information Kit!
|
|
|
Upgrade Your Skills at the Summit
- Quality training, excellent value -
Come to the RPG & DB2 Summit Oct 13-15 in Minneapolis for three full days of intensive education focused on RPG IV, SQL, DB2, PHP, V6R1, ILE, RSE/WDSC/RDi, the Web & more.
Learn the latest in practical, usable tips and techniques from top gurus Susan Gantner, Skip Marchesani, Jon Paris, Paul Tuohy, Scott Klement and others in a fun, highly interactive, invigorating environment. Early Registration is just $995 thru Aug 31 and includes 7 meals; hotel is just $99 per night.
Check out the sessions & register today!
|
|
|
Validate DBCS-Open Data
by Michael Sansoterra
The DBCS open data type is used in many legacy applications as a way to support storage of either single byte character set (SBCS) data, double byte character set (DBCS) data, or even data from both character sets within a single data column. Defined with a data type of O within DDS specs, this data type carries an inherent agnostic coded character set identifier (CCSID) of 65535. READ MORE >
|
|
|
Formatting Dates with SQL
by Ted Holt
The famous ERP package with which I work at my day job stores dates in seven-digit packed decimal fields in CYYMMDD format. Reformatting these dates into something readable in an SQL query is challenging, to put it mildly. To complicate matters, our homegrown systems have dates in YYYYMMDD formats, and outfiles of CL commands have dates in MMDDYY format. I finally got tired of converting and substringing and concatenating, and decided to write a general SQL function to convert dates. I hastily threw it together, but it seems to be working fine. Feel free to suggest improvements. READ MORE >
|
|
|
Full system console control for multiple AS/400s and LPARs from anywhere on your LAN, WAN, VPN, even over the Internet!
Perform certain System Maintenance and Configuration Procedures while in "Restricted State." Execute certain types of System Backups (SAVSYS) and respond to "System Console Only" messages.
Call for details about this
IP Console Solution:
800-597-2525
www.twindata.com
|
|
|
|
Admin Alert: Correcting and Expanding the Program to Change User Passwords on the Fly
by Joe Hertvik
Last week, I published code that allows authorized users to change user profile passwords with a simple call command. However, several readers emailed me about a mistake that will stop the code from compiling. This week, I'm publishing a correction to the code, as well as a new function for preventing the code from changing passwords for security officers, security administrators, and users with all object access. READ MORE >
|
|
Reader Feedback and Insights
We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >
|
Senior Technical Editor: Ted Holt
Technical Editor: Joe Hertvik
Contributing Technical Editors: Erwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
IT Jungle Store Top Book Picks
Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95
|
August 15, 2009: Volume 11, Number 33
August 8, 2009: Volume 11, Number 32
August 1, 2009: Volume 11, Number 31
July 25, 2009: Volume 11, Number 30
July 18, 2009: Volume 11, Number 29
July 11, 2009: Volume 11, Number 28
July 4, 2009: Volume 11, Number 27
|
|
|
|
|
