fhg
Volume 8, Number 27 -- July 23, 2008
Sponsored By
WORKSRIGHT SOFTWARE

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?

 

We can HELP!
We have affordable AS/400 software
and data to do all of the above.
Call us for 30 days FREE.

 

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com


Sponsored By
HELP/SYSTEMS

SEQUEL™ is the leading business intelligence solution for the IBM® System i™.

 

  · Executive Dashboards with Gauges for
      Critical Business Metrics
  · Graphical Query and Reporting
  · Drill-Down Data Analysis
  · Multi-Platform Database Access
  · Powerful Scripting with CL-like Programming
  · Secure Web Access

 

SEQUEL meets all your System i data access and analysis requirements.

 

Learn more now.



Control the Library List from a SQL Server Linked Server Definition
Hey, Mike:

We are having more and more users call AS/400 jobs from a SQL Server session on their PCs, and we have trouble giving them the proper library list. Usually, just giving them the libraries in QUSRLIBL works fine. Is there a way to make sure every user, regardless of originating machine or system, gets the library list values of QUSRLIBL? READ MORE >

Print Part of an IFS File
Hey, Ted:

Let's say I have an IFS file with several thousand lines in it. Let's say I want to print a few lines of that file. My current method is to copy the IFS file to another file, use Edit File (EDTF) with the copy to delete the lines I don't want, and use EDTF's Print command to get the report. Please tell me there's an easier way. READ MORE >



Sponsored By
GUILD COMPANIES

Internet Programming for AS/400,
iSeries & System i

 

Available NOW from the IT Jungle Bookstore

 

This guide from author Hideyuki Yahagi, an IBM Certified IT Specialist with Internet and open source programming expertise, is suited for programmers with traditional skills who want to quickly learn to use the built-in Web serving capabilities of the System i. Progressing from basic to advanced, this tutorial includes programming tips, snippets of sample code, and a CD.

 

Price: $49.95
Buy Now!




Using LTO 3 Tapes In an LTO 2 Drive
Hey, Joe:

Do you know if we'll be able to read tapes created from a new Linear Tape Open Ultrium drive (400 GB native format) on our old Ultrium LTO 2 drives? We want to take tapes from a scientific vessel at sea that may purchase the LTO 3 drive and read the tapes back in the office on our LTO 2 drive. 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

Computer Measurement Group:  CMG '08 International Conference, December 7-12, Las Vegas
SafeData:  FREE White Paper - IBM iSeries Recovery Options: An Executive Guide
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
What the Heck Is the Midrange, Anyway?

More Power7 Details Emerge, Thanks to Blue Waters Super

IBM Drives Home a Strong Second Quarter Across the Board

The X Factor: The IT Department Matters as Much as the CIO

IT Jobs Grow in the U.S. Despite Economic Woes

The Linux Beacon
More Power7 Details Emerge, Thanks to Blue Waters Super

Intel Has a Great Q2, and AMD Has a Poor One and Taps a New CEO

HP Jumps Into Containerized Data Centers, Too

The X Factor: The IT Department Matters as Much as the CIO

IT Jobs Grow in the U.S. Despite Economic Woes

Four Hundred Stuff
CNX Aims to Streamline Web 2.0 Development for i OS with Valence

Resolution Moves Database Automation Forward

IBM Delivers ID Management as a Service with Tivoli FIM

Micro Focus Moves NetManage Acquisition Forward

ARCAD Opens New Office in Singapore

Big Iron
Micro Focus and Microsoft to Enhance COBOL Alternatives on Windows

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
July 19, 2008: Volume 10, Number 29

July 12, 2008: Volume 10, Number 28

July 5, 2008: Volume 10, Number 27

June 28, 2008: Volume 10, Number 26

June 21, 2008: Volume 10, Number 25

June 14, 2008: Volume 10, Number 24

The Windows Observer
Micro-Hoo Degenerates as Deal Goes Sour

HP Jumps Into Containerized Data Centers, Too

Citrix Promises Tool for Creating Hypervisor-Agnostic Virtual Appliances

Why Now, Vista 'Wow'?

SQL Server 2008 On Track for Summer Release

The Unix Guardian
Fujitsu and Sun Flex Their Quads with New Sparc Server Lineup

HP Jumps Into Containerized Data Centers, Too

HP-UX Shops Not Strongly Interested in HP-UX on X64

Mad Dog 21/21: Mission Possible

Sun Cuts Earnings Projections on Consensus Revenues for Fiscal Q4

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

THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
Guild Companies



TABLE OF CONTENTS
Control the Library List from a SQL Server Linked Server Definition

Print Part of an IFS File

Using LTO 3 Tapes In an LTO 2 Drive

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
IFF ACTIVE Equivalent in CL

Printer Problem

Capture Sort File and Copy to Database File

SNMP Traps on i5OS

Java Messages

Copying recs from a subfile to a file and keeping highlights





 
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