IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Delivered
Workspace IBM i
Categories Application Development
Created by Guest
Created on Mar 16, 2017

RELATED IDEAS

Many commands are still missing the option OUTPUT(*OUTFILE) !

The As400 Is about 40 years old, and till todays day, many important commands do not have yet an OUTPUT(*OUTFILE) option, just OUTPUT(*PRINT). The programmer-user needs to do some patching to get it into a DB File or use it in a program.

Here is a partial list of commands that do not have the OUTPUT(*OUTFILE) option:

WRKACTJOB
WRKSBS
WRKOUTQ
WRKSBMJOB
WRKJOB
WRKSPLF
PRTCMDUSG

I am aware hat there are API's, but to use an api is much more complex than using an ouput file.

There are some SQL Tables/Views that have the inforamtion, and are available throug SQL. It would be a good idea, to put the names of the tables in the command help screen.


Use Case:

WRKSBSJOB SBS(QBATCH) OUTPUT(*OUTFILE) OUTFILE(QTEMP/MYSBS)


Idea priority Medium
  • Guest
    Reply
    |     Mar 22, 2017

    We have been delivering the ability to access the details in a programatic manner over the past couple of years. Since todays new programmers are far more familiar with technologies like SQL vs CL Commands, we have made a strategic decision where it makes sense to provide programatic access to data through SQL Services. This allow the developer to have access to all the power and flexibility SQL gives for data manipulation.

    No, we have not been able to deliver all, but we have delivered many Of the list below, we have included the SQL Service equialavent
    WRKACTJOB - QSYS2/JOB_INFO and QSYS2/ACTIVE_JOB_INFO
    WRKSBS - don't have it
    WRKOUTQ - QSYS2/OUTPUT_QUEUE_INFO and QSYS2/OUTPUT_QUEUE_ENTRIES
    WRKSBMJOB - QSYS2/JOB_INFO
    WRKJOB - QSYS2/GET_JOB_INFO
    WRKSPLF - QSYS2/OUTPUT_QUEUE_INFO and QSYS2/OUTPUT_QUEUE_ENTRIES.

    For more details on SQL Services, check out developer Works - https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20-%20Services

  • Guest
    Reply
    |     Mar 22, 2017

    I have created a companion request as I felt this request was two separate requests and I wanted to break out the part I wanted to concentrate on. My companion request was solely to add the desired help. I left off the part of adding output file support.
    You may view the companion request at
    http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=102689

  • Guest
    Reply
    |     Mar 20, 2017

    Adding the DB2 service to the help panel, possibly with a basic example, would probably get more people to try accessing the system through that path to retrieve the data we need. I also agree that these commands need either a DB2 service or *OUTFILE capability.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.