Skip to Main Content
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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Future consideration
Workspace IBM i
Categories Db2 for i
Created by Guest
Created on Feb 1, 2024

Allow variables defined with like(<file-field>) to be used as embedded SQL host variables

If a variable in RPGLE is defined with like, and the source field comes from an external file (PF, DSPF, etc), the SQL preprocessor does not like it.


dcl-f CUSTMAST keyed;

dcl-s qCust like(CUSTNUM); // CUSTNUM defined in CUSTMAST

If I attempt to use qCust as a host variable in an embedded SQL statement, I get the error "Field qCust not defined or useable for reason code 1".

I have to then define qCust explicitly with an RPG datatype and length to use it as a host variable.

Idea priority Medium
  • Guest
    Mar 27, 2024
    IBM will use this Idea as input to planning, but no commitment is made or implied. This Idea will be updated in the future if IBM implements it.

    After collecting more details on the problem encountered by the submitter, this Idea is being scoped to the situation that was encountered.

    The SQL RPG precompiler does not recognize a variable that uses LIKE on the return type without a procedure prototype. For example, the variable retval is not recognized:

    dcl-proc Proc1;
    dcl-pi *n int(10);
    Page int(10) const;
    dcl-s retval like(Proc1);

    The retval variable should be usable by the SQL precompiler. This is the Idea request.

    If (today) this prototype is included, the LIKE is recognized by the precompiler.
    dcl-pr Proc1 int(10);
    Page int(10);

    Db2 for i development team
    IBM Power Systems Development
  • Guest
    Mar 2, 2024

    I can confirm that "LIKE" is supported by the SQL pre compiler.

    A good solution to have clean an concise definitions might be the following:

    dcl-ds typeCustMast extname('CUSTMAST') qualified template end-de;

    dcl-s qCusr like(typeCustMast.CustNum) inz;


    There are 2 things that could be improved:

    1. The SQL pre compiler should give better error messages, what it doesn't like about a host variable. It was improved lately but not so far, that it is really useful.

    2. The SQL pre compiler should support the LIKEREC(....:*ALL) construct. It supports LIKEREC but only with one parameter - the second parameter to the keyword isn't supported, and leads to errors.

  • Guest
    Mar 2, 2024
    The SQL precompiler supports LIKE as described in this Idea today. We believe there must be something about the specific file structure you are using that is causing the failure.

    We need your recreate to understand what is causing the problem you describe. This can either be through this Idea, through normal support, or we can contact you for a direct conversation.

    Db2 for i development team
    IBM Power Systems Development