|
Demand DBU
and get it for $10 a day!
When you need to get to your data NOW, use DBU-on-Demand and activate for one day or for any number of days. 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
|
|
|
SEQUEL can be used for
virtually ALL data access functions
on the System i, including:
· Executive Dashboards
· Graphical Query & Reporting
· Drill-Down Data Analysis
· Multi-Platform Database Support
· E-Mail Report and File Distribution
· Secure Web Access
SEQUEL is the ONE solution for all
your data access needs.
www.ASC-iSeries.com
|
|
|
The SPACE Function Takes Up a Lot of Space
Hey, Ted:
I have to build a file for input to another system. All fields are fixed-length, and numeric values are to be edited and right-adjusted. SQL's CHAR function takes care of the editing requirement, but the result is left-adjusted. How do I right-adjust an edited numeric value? Or will I have to rewrite my program using native I/O operations? READ MORE >
|
|
|
Declare the BINARY Data Type Using DDS
by Michael Sansoterra
We've all heard by now that defining tables using DDS is becoming outdated and that developers need to use SQL in order to access the relatively new data types, including DATALINK and Large Objects (BLOB, CLOB, and DBCLOB). READ MORE >
|
|
|
SpooliT - Control Spool Files Automatically
Intelligent iSeries spool file management:
· Automated Rules based system
· Automate spool file conversion to:
EXCEL, PDF, WORD, HTML, CSV & more
· Features: Archiving, Emailing, Exporting,
Splitting, Bursting, Overlay markings & more
· Intuitive Wizards - Templates
· SOX Compliant - Totally Secure
Powerful iSeries Paperless Reporting System
See it here - Introductory 'SpooliT Webex Demo'
Test it yourself - Request a Trial here
SpooliT - Now you can - www.SpooliT.net
|
|
|
|
Using FTP to Transfer Multiple Files Between Windows and the i5
Hey, Joe:
Every day, I have to transfer a variable number of files from my Windows server to my AS/400. I need to FTP all the files in the same directory and each transferable file begins with the same prefix, ABCFILE (ABCFILE.2006.09.11.2, ABCFILE.2006.09.11.3, etc). Once I get the files to the AS/400, I'd like to combine them into one file that's simply called ABCFILE. Got any ideas? 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
|
October 14, 2006: Volume 8, Number 39
October 7, 2006: Volume 8, Number 38
September 30, 2006: Volume 8, Number 37
September 23, 2006: Volume 8, Number 36
September 16, 2006: Volume 8, Number 35
September 9, 2006: Volume 8, Number 34
September 2, 2006: Volume 8, Number 33
August 26, 2006: Volume 8, Number 32
|
|
