• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Interpreted CL Members, Take 2

    April 11, 2012 Ted Holt

    Once again, the alert and astute readers of this august publication have proven true the old adage that multiple methods exist for removing the outer covering of a feline animal. Several of you wrote in response to my article, Interpreted CL Members, to share other methods of running CL commands in interpreted mode. Here are some of the comments I received.

    I use REXX to handle scripting for CL commands. While I’m not an expert, I’ve found it useful for tasks that you do at a command line to set up something, do over and over, and forget the sequence. I use CL within REXX for certain system functions, such as building a member to re-create data areas and then assign them authorities. So I just F9 back through my command line and paste my commands into a REXX script.

    –Russ

    REXX is an amazing tool, Russ, but I’ve never become an expert at it either.

    What about using the Start Database Reader (STRDBRDR) command with a source member like this one:

    //BCHJOB   JOB(jobname) JOB(jobdescription)
    ... more CL commands
    //ENDBCHJOB
    

    –W

    I think SBMDBJOB is easier than using a reader, but that works, too. If any of you use readers, I’d like to hear how you use them.

    –Ted

    I have a tool that will interpret a CL member interactively. You can get it at here.

    It takes each line in a source member, sends it to *EXT as a *RQS, and then calls QCMD. I wrote this 25 years ago, and it is a rare day that I don’t use it This site, www.brilligware.com has a number of tools and utilities, emphasizing ILE/RPG and /free.

    –Chris Pando

    Thanks for sharing your utility with us, Chris.

    I wanted to mention three alternatives to interpreting commands.

    1) If your reader has TAA Tools installed, he can use the EXCCMD command, which does exactly what he wants, without any of the input spooling directives.

    2) Use REXX. This is what I do. This allows a lot of flexibility and readability.

    3) Your reader could also use RUNSQLSTM, placing the CL commands on lines beginning with “CL:”. (Don’t forget to put a semicolon at the end of the command.) I don’t use this method for pure CL, but sometimes I need CL to support my SQL statements (such as an RGZPFM on a table I just loaded, for example).

    –Doug

    Thanks to all who wrote.

    Keep the feedback coming, folks. I learn a lot from you.

    –Ted

    RELATED STORY

    Interpreted CL Members



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Midrange Dynamics North America

    With MDRapid, you can drastically reduce application downtime from hours to minutes. Deploying database changes quickly, even for multi-million and multi-billion record files, MDRapid is easy to integrate into day-to-day operations, allowing change and innovation to be continuous while reducing major business risks.

    Learn more.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Abacus Solutions:  More affordable and flexible alternatives to deliver secondary workloads
    PowerTech:  Get PowerTech's PCI Compliance Kit to learn how PCI DSS applies to IBM i servers
    COMMON:  Join us at the 2012 Conference & Expo, May 6 - 9 in Anaheim, CA

    IT Jungle Store Top Book Picks

    BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The iSeries Pocket Database Guide: List Price, $59
    The iSeries Pocket SQL Guide: List Price, $59
    The iSeries Pocket WebFacing Primer: List Price, $39
    Migrating to WebSphere Express for iSeries: List Price, $49
    Getting Started with WebSphere Express for iSeries: List Price, $49
    The All-Everything Operating System: List Price, $35
    The Best Joomla! Tutorial Ever!: List Price, $19.95

    Oracle Unveils New BI Apps for Exalytics Machine IBM Launches Hybrid, Flexible Systems Into The Data Center

    Leave a Reply Cancel reply

Volume 12, Number 9 -- April 11, 2012
THIS ISSUE SPONSORED BY:

SEQUEL Software
Help/Systems
CNX

Table of Contents

  • Index Advisor, Part 2
  • Interpreted CL Members, Take 2
  • What Happened to My QFileSvr.400 Connection?

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