• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • New Manta Training Combos Target New IBM i Hires

    September 30, 2013 Jenny Thomas

    We here in the Jungle have been among the voices who cry out for more attention for the IBM i. We echo the sentiments of many of our readers, who would like to see Big Blue put more emphasis into promoting and growing this platform that we all believe in.

    There are people out there who have never let the IBM i platform fall out of focus, who have in fact dedicated their careers to it. One such person is Bill Hansen, who has been an advocate of education since he started creating the first computer-based training courses for IBM

    …

    Read more
  • Create A Generic Auditing Trigger With SQL

    September 25, 2013 Hey, Mike

    Note: The document accompanying this article is available for download here.

    I am writing a trigger receiver program using RPG with embedded SQL that will go through the before and after record images and create an audit record in an audit file for each field that was changed on an update operation.

    I am developing a “shell” trigger program that I’d like to be able to modify slightly, and use the shell as a basis to write these audit records for each file with a trigger on it.

    Instead of writing multiple (IF this field changed THEN DO…) for

    …

    Read more
  • CPYFRMIMPF And Fixed Data

    September 25, 2013 Ted Holt

    It seems that every time I see Copy from Import File (CPYFRMIMPF) mentioned in a Web forum, the question concerns CSV files. CPYFRMIMPF also handles files of fixed-length fields. Such files have certain advantages over CSV files, and there’s more to using them than the IBM documentation tells you.

    Don’t get me wrong. CSV files are great. I use them often. But consider that fixed-length data has its advantages. Two that come to mind are:

    1. Fixed-length character fields may contain any character without the nuisance of special treatment. In CSV files, character fields require special handling of the characters used
    …

    Read more
  • Cleaning Up Excessive Job Logs On Your IBM i System

    September 25, 2013 Hey, Joe

    Thanks for the article on managing IBM i spooled files. We often find it useful to examine user job logs to see exactly where a problem is. But lately, we’ve been getting too many spooled files in QEZJOBLOG. We’re getting 17,000 QZSHSH and QP0ZSPWP job logs each day from website jobs. Any ideas on how to make these useless job logs go away?

    –Dale

    Preventing A Job Log From Being Generated

    My first thought is to see where these jobs are coming from. If you can find the CL program, job scheduler, or submit jobs statement that launches these

    …

    Read more
  • Raz-Lee Delivers New IFS Object Security for IBM i

    September 24, 2013 Alex Woodie

    IBM i is renowned for being a very securable OS. Its object-level security capabilities enable customers to lock the system down to a very tight degree. However, the operating system’s object-level security capabilities don’t extend to the Windows-like Integrated File System (IFS) data store that’s used to house non-traditional data and application objects, including all Java and PASE/AIX data and objects. Now Raz-Lee Security says it has an answer to that with a new product called IFS Object Security (IOS).

    Implementing object-level security on the server is considered by IBM to be best practice for security on the system. However,

    …

    Read more
  • UNIT4 CODA Delivers a ‘Superior’ Solution for Bulk Carrier

    September 24, 2013 Alex Woodie

    Getting financial data out of its homegrown, AS/400-based accounting program used to be a giant hassle for Superior Bulk Logistics, a privately held trucking company an Oak Brook, Illinois. Reports were distributed to managers on paper, and if they had any questions, it required accounting and IT to dig through the general ledger. Since implementing accounting software from UNIT4 CODA in September 2011, it’s been smooth trucking for the firm.

    Superior Bulk Logistics is national trucking company with 52 terminals throughout the US. The company specializes in hauling and handling tank carriers that transport liquid commodities. It operates two primary

    …

    Read more
  • Ipswitch Adds iOS and Android Clients to MFT Suite

    September 24, 2013 Alex Woodie

    Being out of the office used to mean being separated from back office data and workflows. But thanks to today’s advanced smartphones and tablets, business professionals no longer must sacrifice total productivity for some semblance of mobility. With the latest release of its Windows-based MOVEit managed file transfer (MFT) software, Ipswitch has added clients for iOS and Android mobile devices, giving road warriors (including those at IBM i shops) the capability to move large files in a secure manner.

    Ipswitch is a New England company that is perhaps best known for WS_FTP, a classic piece of FTP shareware that traces

    …

    Read more
  • Avalara Debuts Sales Tax Cloud Connectors for IBM i

    September 24, 2013 Alex Woodie

    Avalara last month announced that its cloud-based sales tax calculation and compliance solution, AvaTax, has been certified for use with Infor ERP XA (MAPICS) and the IBM i platform in general. This is the first time Avalara has supported the IBM i platform with its cloud-based sales tax solutions, although it previously supported the platform with its on-premise software.

    Specifically, Avalara said it has successfully tested and validated the performance of a pair of new tax calculation connectors–dubbed AvaTax Calc–that connect its AvaTax cloud service with the Infor ERP XA software and the IBM i platform.

    Putting sales tax calculations

    …

    Read more
  • Robot Gives Worm-Drive Manufacturer a Leg Up on Lights Out

    September 24, 2013 Alex Woodie

    Cone Drive, a manufacturer of precision worm drives, had automated about 60 to 80 percent of its IBM i operations following the first implementation of Robot products from Help/Systems. After the second go around and some training, the company made it to the holy grail of lights-out computing, or 100 percent automation.

    Cone Drive is a Michigan-based manufacturer of high-precision, double-enveloping worm gear sets, which deliver higher torque and last longer than other types of gearing. The company’s products are used all over the world in a variety of industrial applications, including solar tracking, satellite tracking, machine tools, plastic

    …

    Read more
  • UCG Signs California Water District to Vault400

    September 24, 2013 Alex Woodie

    Santa Margarita Water District will have better protection of its critical IBM i resources now that it’s being protected by United Computer Group‘s VAULT400 cloud backup and disaster recovery program.

    SMWD provides drinking water and waste water services to 155,000 residents and businesses across several cities in southern Orange County. Like many special districts across the country, SMWD relies on the IBM midrange server to automate key aspects of its business.

    Recently, the district began looking for a replacement for its tape-based backup and DR strategy. The district settled upon VAULT400, the online backup and DR service offered by

    …

    Read more

Previous Articles Next Articles

Content archive

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

Recent Posts

  • Tool Aims To Streamline Git Integration For Old School IBM i Devs
  • IBM To Add Full System Replication And FlashCopy To PowerHA
  • Guru: Decoding Base64 ASCII
  • The Price Tweaking Continues For Power Systems
  • IBM i PTF Guide, Volume 27, Numbers 31 And 32
  • You Can Now Get IBM Tech Support For VS Code For i
  • Price Cut On Power S1012 Mini Since Power S1112 Ain’t Coming Until 2026
  • IBM i: Pro and Con
  • As I See It: Disruption
  • IBM i PTF Guide, Volume 27, Number 30

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