|
In This Issue
|
|
You Have Questions. The Gurus at Guild Companies Have Answers.
Sponsored By
 ADVANCED SYSTEMS CONCEPTS
|
|
E-Mail or FTP Files
with Esend
Send database, IFS or spooled files
from your AS/400 or iSeries.
Convert spooled files to PDF,
HTML, PDF, and other formats.
Burst and distribute reports by e-mail
to any number of recipients.
(Read more information)
FREE Trial - Call 847-605-1311 or
DOWNLOAD HERE
|
|
Sponsored By
 COMMON
|
|
Get the IT training you need by attending COMMON Users Group's Spring 2003 IT Education Conference and Expo,
March 9 - 13, in Indianapolis.
Choose from hundreds of sessions and labs covering the widest range of industry topics, including RPG IV, LPAR, WebSphere, and High Availability.
COMMON is the best value in IT education, so don't miss out!
Click and visit www.common.org for details!
|
|
|
Batch FTP Under ILE
Hey, Ted:
I have a CL program that runs FTP in a batch job. It overrides INPUT to a source member of FTP commands and OUTPUT to a database file.
READ MORE >
|
A Room with a View
Hey, Howard:
I haven't messed with views much until now, but I came across a good use for one today. I created it, and it was good. But then I noticed that the logical I was hoping to replace with the view was sorted in ascending order by a couple of fields, so I added an ORDER BY clause. The system let me know in no uncertain terms that I couldn't do that.
READ MORE >
|
Reader Feedback and Insights: Converting Zeros to Nulls
In SQL, CASE can convert a zero to NULL in a select statement . I'm not sure at what release it became available, though [see the first question and answer in the February 12 issue of Midrange Guru].
READ MORE >
|
Editors: Howard Arner, Joe Hertvik, Ted Holt, David Morris
Managing Editor: Shannon Pastore
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
|
|
|
