Skip to Main Content
Cloud Management and AIOps


This is an IBM Automation portal for Cloud Management, Technology Cost Management, Network Automation and AIOps products. 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.

Status Under review
Created by Guest
Created on Jan 28, 2026

Process database job stored procedure output variables as IWS variables :- case TS020814036

When defining an IWS job using a database stored procedure, we can set it up in IWS and click lookup parameters to get the variables used by the procedure for both in and out. This works fine and we can specify variable table values as the input values. However the value according to the documentation for the output variable can only be set to “?”. When the job runs it prints the output values returned in the stdlist such as P_FROM_DATE=20251111 and P_TO_DATE=20251112 which are the output parameters defined in the stored procedure.

 

If we need to pick up these values to pass them to a subsequent job the only way to do this is to have an interim job which reads these values from the stdlist of the stored procedure job and then run a mini script to set values using jobprop which can then be picked up in yet another job to set the variables. This means having 2 additional jobs for every stored procedure job to process the variables.  

An enhancement is requested to be able to write to the variable table directly from the stored procedure job into a variable table value. If this is not possible then at least provide functionality where the output variables can be picked up (maybe using jobprop type functionality or equivalent) by a subsequent variable table job so only 1 additional job is required instead of 2.

Idea priority Urgent