Skip to Main Content
IBM Data and AI Ideas Portal for Customers

This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. 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

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

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.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at

Status Not under consideration
Components Q Replication for Z
Created by Guest
Created on Sep 30, 2017

No Expression Procession for CAST_TO_VARCHAR2

z/OS has 65536 code page for Chinese character. CAST_TO_VARCHAR2 does not make any change in character. But the expression with Chinese character causes performance problem.

For character in RAW to VARCHAR2, Qrep should ignore the expression CAST_TO_VARCHAR2 and make no procession.

  • Admin
    Rohit Agarwal
    Apr 6, 2020

    Latest discussion with Serge suggests there is a workaround and this idea could be rejected.

  • Admin
    Rohit Agarwal
    Apr 6, 2020

    Adding histroy from RFE-32425:

    4.Davendra PaltooDec 1, 2017 6:32 AMJennifer:

    Serge and Tao Qian suggested that change 65535 in Source with 1386 in Target to prevent cast_to_varchar2 with primary fields. ICBC has tested with the suggestion. The fuction is OK. ICBC plans to set up environment to test performance in next week.

    3.Davendra PaltooDec 1, 2017 6:30 AMSerge:
    We still need to better understand this issue. We would like to fully understand why the customer needs expression on the replication key and unique indexes. Have they tried defining the subs without those expressions? Is the data coming from the mainframe already in the target Oracle codepage? Are they using codepage_override for both cases?

    Today, Q Apply must evaluate the expressions BEFORE it can do dependency analysis on the replication key and other unique indexes. We could consider not evaluating the expression only if and when the expression is a CAST_TO_VARCHAR2 and the source is for BIT DATA (and codepage_override to no conversion). Would that work? For this case, I wonder why there is the expression in the first place.
    Unfortunately, removing the expression evaluation before dependency analysis has several implications on Q Apply design and is not entirely trivial. We will need to further assess if it really needed, before we accept this requirement.

    2.Davendra PaltooOct 19, 2017 7:47 AMHe Fang to help with the clarification on what is being requested.

    1.Davendra PaltooOct 19, 2017 7:42 AMSerge to follow up with client.