• 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
    Fresche Solutions

    Executive Report for IT Leaders

    Why Smart Modernization Is the Path to Successful IBM i Digital Transformation

    Download this report to get answers these key questions:

    • What is driving digital transformation?
    • Where are organizations going wrong with respect to modernization?
    • What is the best / most efficient / smartest way forward?

    Get the Report »

    _________________________________________________________________

    About Fresche Solutions

    Fresche is the leading provider of digital transformation enablement, application modernization and optimization solutions for companies that rely on IBM i Power Systems. Through the power of automated tools and experienced professionals, Fresche delivers smart solutions that bring our clients the best, boldest ideas to fuel transformation and better manage their business and IT. Our low-risk, phased approach is giving companies new ability to digitally innovate and improve operational processes while leveraging IT assets so clients can take advantage of digital solutions including web, mobile, cloud and AI.

    We can help you with:

    • Developing your IT strategy
    • Building an IBM i roadmap
    • Transforming your RPG and CA 2E (Synon) code to modern languages
    • Addressing developing shortages
    • Quickly onboarding new IT staff
    • Increasing developer productivity
    • Integrating with other systems
    • Extending your ERP
    • Understanding your applications
    • Deploying modern interfaces
    • Improving business agility
    • Starting your digital transformation journey

    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

  • When Cloud Meets DevOps on IBM i
  • JD Edwards Roadmap Reveals Decisions To Be Made
  • IBM Completes Migration of Knowledge Center to IBM Documentation
  • Four Hundred Monitor, April 7
  • Crazy Idea Number 615: Variable Priced Power Systems Partitions
  • Do The Math When Looking at IBM i Hosting For Cost Savings
  • Guru: Web Services, DATA-INTO and DATA-GEN, Part 1
  • Oracle Versus Rimini Slogs On In Second Decade
  • HCI Is The Dominant Converged System, Probably For Good
  • Skytap To Expand IBM i Cloud Offering

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 © 2021 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.