Skip to Main Content
IBM Sterling


This portal is to open public enhancement requests for IBM Sterling products and services. 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 Future consideration
Created by Guest
Created on Feb 29, 2024

ITXA - GET multiple codelist columns at once

In Sterling Integrator, we are currently able to pull multiple columns from a code list entry in one SELECT statement, as below:


SELECT SenderCode, TEXT1, TEXT2 INTO VAR_SENDERCODE,VAR_TEXT1,VAR_TEXT2 FROM CODELIST WHERE NAME = "DSV_STD_EXCEED_RP_CUSTOMER_cl" AND ReceiverCode = #9804;


In Design Studio, the equivalent logic to obtain just the SenderCode would be like below:


= GET("SPE", "-TE+ -C getCodeListItemByReceiverCode -D '" + #9804 + "' -B DSV_STD_EXCEED_RP_CUSTOMER_cl -K 0")


We would need two more GET calls to get the TEXT1 (column 4) and TEXT2 (column 5) values. If there is a requirement for multiple columns, and it is needed e.g for multiple ReceiverCode values, then this will result in a large number of GET requests being made, which we are concerned will have a performance impact


Functionality should be added so that a single GET request that can pull multiple columns.

What is your industry? Travel & Transportation
How will this idea be used?

This will be used to avoid repeated GET calls being made in the same map when one could be used

  • Admin
    Mike Lamb
    Reply
    |
    Mar 21, 2024

    Sarah,


    Thank you for taking the time to provide your ideas to IBM. We are reviewing this and will come back with a response.


    Thanks,

    Mike Lamb

    IBM Sterling Data Exchange, Product Management