• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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) TYPE(*DEC) LEN(1) RSTD(*YES) +
         DFT(*ALL) +
         SPCVAL((*CVNPRB 1) (*LIBSUM 2) (*LIBDTL 3) +
                (*OBJSUM 4) (*OBJDTL 5)) +
         SNGVAL((*ALL 0)) +
         MIN(0) MAX(5) +
         PROMPT('Type of report')
    

    Now you can run commands like these:

    DOIT RPTTYPE(*ALL)
    DOIT RPTTYPE(*LIBSUM *OBJSUM)
    DOIT RPTTYPE(*CVNPRB *LIBSUM *LIBDTL *OBJSUM *OBJDTL)
    

    But do this. . .

    DOIT RPTTYPE(*ALL *LIBSUM)
    

    . . .and you’ll get error CPD0094 (*ALL must be only value for parameter RPTTYPE).

    Now, Glenn’s second question:

    2. Can you prevent a user from keying in the same value more than once?

    No. Nothing will stop you from doing this:

    DOIT RPTTYPE(*LIBSUM *LIBSUM *LIBSUM *LIBSUM *LIBSUM)
    

    The system allows you to enter up to five values in the RPTTYPE parameter. If you want to waste a spot by duplicating a value, the system won’t object. It is up to the command-processing program to recognize and ignore duplicates.

    Glenn had two more questions, both of which deal with mixed lists. That will have to be a topic for another day.

    –Ted

    RELATED STORY

    10 Facts You Should Know about Special Values



                         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
    DRV Tech

    Get More Out of Your IBM i

    With soaring costs, operational data is more critical than ever. IBM shops need faster, easier ways to distribute IBM applications-based data to users more efficiently, no matter where they are.

    The Problem:

    For Users, IBM Data Can Be Difficult to Get To

    IBM Applications generate reports as spooled files, originally designed to be printed. Often those reports are packed together with so much data it makes them difficult to read. Add to that hardcopy is a pain to distribute. User-friendly formats like Excel and PDF are better, offering sorting, searching, and easy portability but getting IBM reports into these formats can be tricky without the right tools.

    The Solution:

    IBM i Reports can easily be converted to easy to read and share formats like Excel and PDF and Delivered by Email

    Converting IBM i, iSeries, and AS400 reports into Excel and PDF is now a lot easier with SpoolFlex software by DRV Tech.  If you or your users are still doing this manually, think how much time is wasted dragging and reformatting to make a report readable. How much time would be saved if they were automatically formatted correctly and delivered to one or multiple recipients.

    SpoolFlex converts spooled files to Excel and PDF, automatically emailing them, and saving copies to network shared folders. SpoolFlex converts complex reports to Excel, removing unwanted headers, splitting large reports out for individual recipients, and delivering to users whether they are at the office or working from home.

    Watch our 2-minute video and see DRV’s powerful SpoolFlex software can solve your file conversion challenges.

    Watch Video

    DRV Tech

    www.drvtech.com

    866.378.3366

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    ASNA:  Create great mobile apps with ILE RPG. Period.
    looksoftware:  Achieving the impossible with RPG Open Access. Live webcast Dec 4 & 5.
    ITJ Bookstore:  Bookstore BLOWOUT!! Up to 50% off all titles! Everything must go! Shop NOW

    IT Jungle Store Top Book Picks

    Bookstore Blowout! Up to 50% off all titles!

    The iSeries Express Web Implementer's Guide: Save 50%, Sale Price $29.50
    The iSeries Pocket Database Guide: Save 50%, Sale Price $29.50
    Easy Steps to Internet Programming for the System i: Save 50%, Sale Price $24.97
    The iSeries Pocket WebFacing Primer: Save 50%, Sale Price $19.50
    Migrating to WebSphere Express for iSeries: Save 50%, Sale Price $24.50
    Getting Started with WebSphere Express for iSeries: Save 50%, Sale Price $24.50
    The All-Everything Operating System: Save 50%, Sale Price $17.50
    The Best Joomla! Tutorial Ever!: Save 50%, Sale Price $9.98

    Jinfonet Speeds In-Memory OLAP with ‘Push Down’ Technology Power Systems Cloud Builders Get Huge Discounts

    Leave a Reply Cancel reply

Volume 12, Number 28 -- November 28, 2012
THIS ISSUE SPONSORED BY:

WorksRight Software
ProData Computer Services
Sirius Computer Solutions

Table of Contents

  • Write Your Own SCANRPL Built-In Function
  • Glenn Wants To Know More Facts About Special Values
  • Admin Alert: Strategically Using Power Systems’ Processor Trial Capacity On Demand

Content archive

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

Recent Posts

  • The Power11 Transistor Count Discrepancies Explained – Sort Of
  • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
  • Big Blue Delivers IBM i Customer Requests In ACS Update
  • New DbToo SDK Hooks RPG And Db2 For i To External Services
  • IBM i PTF Guide, Volume 27, Number 33
  • 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

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