• 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
    ARCAD Software

    [Webinar Series] Demystifying DevOps on the IBM i

    Join us for a 3-part “Live” Roundtable webinar series as we demystify DevOps on the IBM i.  We’ll start with discussions on Git and the IBM i and developer tool options.  Next, we will cover Branch Management and Builds. We’ll end with discussions on an Automated DevOps Workflow.  It will be an informative series on modernizing the IBM i development process. Our speakers will address your questions and share their years of experience and best practices.

    Register NOW

    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

  • The IBM i Power10 Upgrade Cycle Forecast Looks Favorable
  • White Hats Completely Dismantle Menu-Based Security
  • Cloud Software To Drive Enterprise Application Growth
  • How Do You Stay In Touch With The IBM i Community?
  • IBM i PTF Guide, Volume 25, Number 6
  • Security Still Top Concern, IBM i Marketplace Study Says
  • Bob Langieri Shares IBM i Career Trends Outlook for 2023
  • Kisco Brings Native SMS Messaging to IBM i
  • Four Hundred Monitor, February 1
  • 2023 IBM i Predictions, Part 4

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 © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.