• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Easily Create Help Text For Commands

    January 23, 2013 Ted Holt

    Extending IBM i by writing one’s own commands is empowering and gratifying, but a command without help text is like scrambled eggs without salsa. Fortunately, generating help text for a command is easy, thanks to a technique I learned from a very talented programmer named Chris Wages. Let me show you how it’s done.

    First, you must have a command, of course. Here’s the source code for command DOIT.

    CMD        PROMPT('Do it')
    
    PARM       KWD(HOW) TYPE(*CHAR) LEN(7) RSTD(*YES) +
                 DFT(*WELL) +
                 VALUES(*WELL *BETTER *BEST) +
                 EXPR(*YES) +
                 PROMPT('How should I do it?')
    
    PARM       KWD(WHEN) TYPE(*CHAR) LEN(8) RSTD(*YES) +
                 DFT(*MORNING) +
                 VALUES(*MORNING 
    …

    Read more
  • Stopping Unauthorized Users From FTPing To Your IBM i

    January 23, 2013 Hey, Joe

    My programmers keep setting up automatic FTP downloads from the network using the wrong user profile. For security reasons, they are only supposed to use a special FTP download user profile, but they keep using their own profiles and I have no way to stop this. How can I lock down FTP so that they can only use an authorized user FTP profile for their client FTP sessions?

    –Bob

    You can easily use an FTP exit point to prevent unauthorized users from starting an FTP session on your IBM i partition.

    An IBM i exit point is a specific point

    …

    Read more
  • What’s New With CPYFRMIMPF And CPYTOIMPF?

    January 9, 2013 Michael Sansoterra

    As my years as a developer whiz by, I often find myself ignorant of the newest features available. For example, I’ve used the Copy From Import File (CPYFRMIMPF) and Copy To Import File (CPYTOIMPF) commands so often that I just became (as my old boss used to say) “fat, dumb, and happy” when using them, not realizing IBM has added new features since the time I first studied these commands. I’ll briefly share a few of the relatively recent enhancements to these commands.

    First of all, in i7.1 Technology Refresh 5 (TR5), CPYTOIMPF has been enhanced with a new parameter

    …

    Read more
  • Tracing Routines Explain Why The Computer Did What It Did

    January 9, 2013 Ted Holt

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

    Every week someone asks me why the computer did what it did. For instance, not long ago a buyer asked me why the computer did not send our requirements for a certain item to the vendor who supplies the item. I started digging through the program that generates the files we send to vendors. Then I realized there was a better way. Let me tell you about it.

    In many shops, business rules are embedded in source code. Sometimes rules are hard-coded. I’ve seen code that directly referred

    …

    Read more
  • Admin Alert: Four Things To Do For Your IBM i In 2013

    January 9, 2013 Joe Hertvik

    A new year always brings new challenges in administering your IBM i machines. Here are the top four things on my 2013 calendar that IBM i shops should look at in 2013, starting this month.

    #1: Check Your Job Scheduling Date Objects In January

    If you haven’t already done so, look at any date-dependent job processing objects on your system and change them to ensure that they will still work correctly in 2013. These objects might include:

    • Any data areas that affect date processing.
    • Files that need to go through yearly purge routines.
    • Any RUN and OMIT date objects that
    …

    Read more
  • End-Of-Year Odds And Ends

    December 12, 2012 Ted Holt

     

     

    Dear Esteemed Colleagues:

    We made it through another year! Thanks to you, along with our writers and advertisers, this august publication is 11 years old! Who’da thunk it? Let’s wind up 2012 with various and sundry items that you sent my way.

    –Ted


    Hey, Ted:

    I am using SQL to query an index, similar to what I do for a logical file. The system is responding with error SQL7011 (SOMEINDEX in SOMELIB not table, view, or physical file.) Could you please shed some light on why it is happening?

    –Jabir

    What you’re trying to do makes sense from

    …

    Read more
  • BASS: Build A Spreadsheet

    December 12, 2012 Ted Holt

    Note: The code accompanying this article is available for download here. This code was updated on 12/22/14.

    Everybody needs a project–something to putter with in order to relieve stress and deal with the vicissitudes of life. I would like to tell you about a project that I’ve been working on for the past few months. I only wrote it for the fun of it, but it has already come in handy.

    It seems that not a week goes by without someone asking me to stop providing them a report as a PDF and give it to them in Excel

    …

    Read more
  • Admin Alert: Auditing Your IBM i Software Maintenance Bills

    December 12, 2012 Joe Hertvik

    Dealing with IBM i third-party maintenance can be a pain. You buy a software package once, but wind up paying yearly maintenance bills for the life of the application, paying 15 percent or more of the original purchase price per year. And the vendor may increase the cost on a yearly basis. This week, I’ll discuss software maintenance fees and give you some tips on keeping your maintenance costs down.

    Basic IBM i Maintenance

    Third-party software maintenance is a necessary but expensive proposition for IBM i vendors. Software vendors need to charge yearly maintenance to provide cash flow for creating

    …

    Read more
  • Write Your Own SCANRPL Built-In Function

    November 28, 2012 Bob Cozzi

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

    Until IBM i v7.1 has made a pervasive appearance on virtually all IBM systems, the cool new v7.1 updates to RPG IV are out of reach for many RPG developers. Fortunately, with IBM i v7.1, IBM has finally stopped “point release” updates to the RPG compiler, giving us the ability to use anything implemented on (for example) technology refresh 5 all the way back to TR1. Life is good for RPG developers today.

    If you’re a software developer or, like me, consulting with clients that have everything from

    …

    Read more
  • Glenn Wants To Know More Facts About Special Values

    November 28, 2012 Hey, Ted

    I found your article 10 Facts You Should Know about Special Values very interesting. I have a few questions related to a command I am writing.

    –Glenn

    I owe Glenn an apology. He is one of the many people whose email I never responded to. I’m sorry, Glenn. Sometimes life presents too many opportunities.

    Here’s Glenn’s first question:

    1. If a user specifies *ALL for a parameter, how do you prevent the user from typing in other values?

    Fair enough. Define *ALL in the Single Value (SNGVAL) keyword, not in the Special Value (SPCVAL) keyword.

    CMD        PROMPT('Do it')
    
    PARM KWD(RPTTYPE) 
    …

    Read more

Previous Articles Next Articles

Content archive

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

Recent Posts

  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24
  • Big Blue Raises IBM i License Transfer Fees, Other Prices
  • Keep The IBM i Youth Movement Going With More Training, Better Tools
  • Remain Begins Migrating DevOps Tools To VS Code
  • IBM Readies LTO-10 Tape Drives And Libraries
  • IBM i PTF Guide, Volume 27, Number 23

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