fhg
Volume 8, Number 31 -- September 10, 2008
Four Hundred Guru is taking a hiatus next week. We will resume publishing on September 24.
Sponsored By
HELP/SYSTEMS

SEQUEL™ -- IBM® System i™
Business Intelligence Made Easy

 

  · Easy to use by IT and end users
  · Automated data access and display
  · Complete BI package: reports, tables, key
     performance indicators, and dashboards
  · System i-centric for real-time data analysis
  · Multiple interface options: graphical,
     green-screen, browser
  · Expert support and training

 

SEQUEL meets your System i data access and analysis needs.

 

http://www.helpsystems.com/400g



Sponsored By
PRODATA COMPUTER SERVICES

Learn how to access remote databases from your RPG programs!

 

RDB Connect is a stand alone product that
offers APIs for using SQL queries to access
remote data. It gives you easy access to
current and accurate data from remote systems.
RDB Connect allows full SQL access to
MySQL, Microsoft SQL Server, Oracle,
Postgre and DB2 and more...

 

Attend our Webinar
Wednesday, September 17, 2008
2:00 pm CDT (-06:00 GMT)

 

sales@prodatacomputer.com
www.prodatacomputer.com


The Efficiency of Varying Length Character Variables
by Jon Paris

Remember the bad old days when dinosaurs still roamed the earth and the only way to build strings in RPG involved playing silly games with arrays? Or worse still, obscure combinations of MOVE operations? Thankfully those days are far behind us--although sadly there are still a few RPG/400 dinosaurs coding away! READ MORE >

SQL Assist: Powerful Interactive SQL
by Skip Marchesani

The Run SQL Scripts function, a.k.a. the SQL Script Center or Script Center, is System i Navigator's counterpart to Interactive SQL on the green screen side of the System i. The SQL Script Center allows the user to execute all or a subset of a script that contains one or more SQL statements and/or batch CL commands. It is part of the Navigator Database function and is an extremely powerful and flexible tool with lots of function that can have a very positive impact on application developer productivity. READ MORE >



Sponsored By
SYSTEM i DEVELOPER

Take it to the Summit!

 

Come to the RPG & DB2 Summit in Las Vegas, October 20-22, for three full days of intense education focused on RPG IV, ILE, SQL, DB2, V6R1, WDSC/RSE/RDi & 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 highly interactive, fun, invigorating environment. You'll leave the Summit re-energized and eager to use all your new skills and ideas.

 

Register today and save $100
- $1295 registration ends October 3.




Admin Alert: Getting into a i5/OS Restricted State
by Joe Hertvik

There's a special place for restricted state processing in the i5/OS or OS/400 world. In restricted state, administrators can apply upgrades, change core system parameters, backup the operating system and run special commands that affect partition configurations. This week, I'll examine everything about restricted state processing, from why it exists, to how to enter and leave this core operating system function. 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: Edwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

 

Sponsored Links

ProData Computer Services:  Access remote databases from RPG, Webinar, Sept. 17, 2 p.m. CDT
MoshiMoshi:  Episode Three now showing! Watch and Win!
COMMON:  Join us at the Focus 2008 workshop conference, October 5 - 8, in San Francisco, California

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.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 Developers' 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
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


 
The Four Hundred
Expanded Power Systems i Boxes on the Horizon?

Entry Power System i Boxes Compete Well with Windows Boxes

X64 Servers See Pricing Pressure in Q2, Big Box Sales Grow

The Law of Attraction

Arrow Says Midrange Shops More Worried About Security than Money

The Linux Beacon
Why Blade Servers Still Don't Cut It, and How They Might

Intel Keeps Both Arms Swinging with Xeons, Jabs with Itanium

Microsoft Ponies Up Another $100 Million for Novell Linux

Mad Dog 21/21: Newtonian Economics

Two More Xeon-Based Galaxy Servers from Sun

Four Hundred Stuff
SafeData Launches First Fully Managed Service for i5/OS HA

Aldon Brings PHP Closer Into Change Management Fold

HiT's DBMoto Gains Enterprise Replication Features

AmeriVault Debuts DR Service for i OS Servers

BMC Aims to Bring Virtual Servers Under Control

Big Iron
For Some Customers, the Mainframe Is Green

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
August 23, 2008: Volume 10, Number 34

August 16, 2008: Volume 10, Number 33

August 9, 2008: Volume 10, Number 32

August 2, 2008: Volume 10, Number 31

July 26, 2008: Volume 10, Number 30

July 19, 2008: Volume 10, Number 29

The Windows Observer
Citrix Addresses Performance with XenApp 5

Server Buyers Shop Like It's 1999 in the Second Quarter

Intel Keeps Both Arms Swinging with Xeons, Jabs with Itanium

Mad Dog 21/21: Newtonian Economics

Microsoft Does Something About Those SQL Injection Attacks

The Unix Guardian
What the Heck Is the Midrange, Anyway?

Overseas and Notebook Sales Offset Printer Declines for HP in Q3

Two More Xeon-Based Galaxy Servers from Sun

Mad Dog 21/21: Newtonian Economics

Intel's Nehalems to Star at IDF, AMD Pitches Shanghai

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

THIS ISSUE SPONSORED BY:

Help/Systems
ProData Computer Services
System i Developer



TABLE OF CONTENTS
The Efficiency of Varying Length Character Variables

SQL Assist: Powerful Interactive SQL

Admin Alert: Getting into a i5/OS Restricted State

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
MQ Help Desired

Printing TCP/IP Details into a Spoolfile

IFF ACTIVE Equivalent in CL

Capture Sort File and Copy to Database File

SNMP Traps on i5OS

Java Messages





 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement