fhg
Volume 6, Number 7 -- February 15, 2006
Sponsored By
PRODATA COMPUTER SVCS

Demand DBU and get it for $10 a day!

 

When you need to get to your data NOW,
use DBU-on-Demand and access data on any server or any partition at anytime. This is great for those ‘seldom touched’ systems without a database utility and a lifesaver in emergency database situations.

 

Use DBU for $10 a day anytime, anywhere!
Do it with DBU.

 

It's Server Proven and on IBM’s Roadmap! Call us today to access DBU-on-Demand.
800.228.6318
www.DoDBU.com


Sponsored By
ITERA


Researching High Availability Solutions?

 


View the contents of this valuable iSeries high availability resource portal that includes HA white papers, archived
webinars, case studies and more.

 

Learn essential information about iSeries high availability before you implement this powerful business-continuity technology.

 


Click here for instant access.



RPG Looks into the Future
by Ted Holt

If you could write a program that could accurately predict the future, you'd be set for life. Unfortunately--or fortunately, depending on your point of view--such a program is not possible. But you can make a program look ahead as it reads a sequential data set, and that can be a valuable asset. READ MORE >

Work Fields and SQL
Hey, Ted:

I haven't been able to get SQL to handle result fields in the same way Query/400 can. In Query, I can define a result field, then use that field in the definition of another field. If I try this with SQL, I get a message that says, "Column X not in specified tables." Is there a way to avoid duplicating the calculations of a work field? READ MORE >




Sponsored By
ASYMEX

SpooliT
Convert iSeries Reports to Excel and automatically...

 

· Remove page breaks and blanks lines.
· Convert negative numbers to true negative
   numbers.
· Denormalize level breaks against each row
   in the spreadsheet.
· Reorder columns and conditionally select
   rows based on content.
· Deliver reports by email or intranet.

 

Click here to download a free trial of SpooliT
Click here to book an online demo of SpooliT
Visit www.SpooliT.net




When Users Need to Create Duplicate Objects
Hey, Joe:

I just wrote a CL program that uses the Create Duplicate Object command (CRTDUPOBJ) to copy a file into a user's QTEMP library for test processing. However, every time my users run the CRTDUPOBJ command in that CL, it gives them a CPF2189 error (Not authorized to object), even though the users have *PUBLIC *USE authority to the object. What's going on here? 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 Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
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

COMMON:  Join us at the Spring 2006 conference, March 26-30, in Minneapolis, Minnesota
T.L. Ashford:  BARCODE400 - the fastest way to create compliance labels directly from the iSeries
California Software:  Migrate iSeries apps to Windows, Linux, or Unix

 


 
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