• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Reader Feedback and Insights:

    September 27, 2002 Timothy Prickett Morgan

    Hey, Ted:

    I find your Web site and the information stored there more and more useful. Today, somebody I know was having trouble with data being truncated on FTP. Overhearing this triggered me to find the Midrange Guru article where you were discussing “locsite trim 0.” I went to the Midrange Guru Web site, found the article, and passed it on to the person in need of the information. It worked.

    I just thought I would pass that information along.

    Keep up the good work.

    — Darrell



























    Sponsored By
    ADVANCED SYSTEMS CONCEPTS

    SEQUEL meets all your iSeries and AS/400 data access needs in a single, integrated solution:

    • Windows, Web or host user interfaces

    • Convert AS/400 data into PC file formats

    • E-mail or FTP query results, reports and spool files
    • Run-time prompted queries and reports for end users

    • IF-THEN-ELSE logic in queries and reports

    • Report, form and label formatting second to none

    • Easily convert date fields, character-to-numeric, numeric-to-character and other data manipulation

    • SORT or JOIN using a calculated field

    • Quick summarization of data with Tabling function

    • Run multiple SEQUEL requests as one with the SEQUEL Scripting function

    • OLAP Business Intelligence at a fraction of the cost of comparable solutions

    Take 6 minutes to view a SEQUEL ViewPoint ScreenCam movie to see how simple Windows-based AS/400 and iSeries data access can be! In just a few short minutes, you can find out ways to make your job easier and improve data access throughout your organization. Download the ViewPoint movie here .

    For more information or a FREE trial of SEQUEL, call 847/605-1311 or visit Advanced Systems Concepts.

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Tags: Tags: mgo_rc, Volume 2, Number 74 -- September 27, 2002

    Sponsored by
    Computer Keyes

    Create Full Color Overlays, Interactive PDFs

    KeyesOverlay rapidly converts standard *SCS printer files into eye-catching PDF documents. Create graphical overlays in full color (or black and white if preferred) then easily map your spooled file text with different fonts, sizes and colors!

    KeyesOverlay can also create Interactive Forms for your customers to fill out and email or submit back to you.

    www.computerkeyes.com

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    OPNQRYF Date Arithmetic Loading a Tilde-Delimited File into the Database

    Leave a ReplyCancel reply

MGO Volume: 2 Issue: 74

This Issue Sponsored By

    Table of Contents

    • Reader Feedback and Insights:
    • Loading a Tilde-Delimited File into the Database
    • Find the Cursor Position in a CL Program

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • More Power Systems Price Hikes, This Time They Are “Directional”
    • AI Is Not Just For Developers, It Is For Everyone At Your Company
    • Guru: Finding Data In The Forest – Exploring Three-Part Naming In SQL
    • Former IBMer’s New Book Puts The Midrange In The Spotlight
    • Have You Tried To Buy A Server Lately?
    • GenAI Is The Death Of Deterministic Project Budgeting
    • PTC Adds Support For VS Code With Implementer 12.7
    • Guru: Single Threading A Program Execution
    • As I See It: Push Back
    • IBM i PTF Guide, Volume 28, Number 21

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle