Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


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 (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

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 (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.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Planned for future release
Created by Guest
Created on Feb 14, 2025

HPU 'FASTU-DELIMITED' output format delimiter issue

See this idea on ideas.ibm.com

We are in the process of converting CA DB2 Fast Unload jobs to IBM HPU and got the below issue for atleast 16 Batch jobs and impacting the migration to IBM DB2 tools. Faced the delimiter issue with IBM HPU as below :-

CA Fast Unload output -

'000R50495013 ',3,'NM1','0FEPNM','0102 ','O''BRI, PATRICK','O''BRI '

IBM HPU Output format -

'000R50495013 ',3,'NM1','0FEPNM','0102 ','O'BRI, PATRICK','O'BRI

HPU does not repeat the character string delimiter where it is used within the character string data. HPU delimited output should repeat the character string delimiter where it is used within a string to point out that it is not the end of the string and not a delimiter in that case.
This is the standard behavior of the Broadcom DB2 Fast Unload Utility and also standard of the IBM standard unload utility to ensure that the reload of the data with the IBM DB2 Load utility is working correctly.
The IBM Load utility is able to handle these double characters. Without it, unpredictable results will occur during the load.

The problem also applies to format ‘DELIMITED’ and ‘DB2U-DELIMITED’, not only ‘FASTU-DELIMITED’.

Request you to consider this for HPU.


Thanks,

Vishwa



Needed By Quarter
  • Admin
    SOO KIM
    Reply
    |
    May 1, 2025

    An enhancement which will address this particular issue will be included in the next release of HPU.

  • Guest
    Reply
    |
    Mar 20, 2025

    Hi Team,

    For information. As a temporary way we have validated the below with some data it worked and validating with more data.

    As in idea provided example:

    First during HPU unloading Chosen an different delimiter as |.

    |O'BRI, PATRICK|

    Then replaced with SORT single quote as two single quotes.

    |O''BRI, PATRICK|

    Then replaced with SORT pipe as original default delimiter single quote.

    'O''BRI, PATRICK'    

    Thank you, Regards,
    Bharath Eluri

    //******************************************                                                          
    //STEP1 EXEC PGM=INZUTILB,REGION=100M,                        
    //           PARM='DL02,HPU'                                  
    //STEPLIB    DD DSN=DB2SYSD.DB2TOOLS.HPU.SINZLINK,DISP=SHR    
    //           DD DISP=SHR,DSN=DB2DL02.DSNEXIT.TEMP              
    //           DD DISP=SHR,DSN=DB2DL02.DSNLOAD.TEMP              
    //           DD DISP=SHR,DSN=DB2DL02.DSNLOD2.TEMP              
    //SYSPRINT   DD SYSOUT=*                                      
    //SYSABEND   DD SYSOUT=*                                      
    //SYSPUNCH   DD SYSOUT=*                                      
    //SYSREC1  DD DSN=&&TEMPDS1,                                  
    //            DISP=(NEW,PASS),SPACE=(CYL,(410,410),RLSE),      
    //            UNIT=DTA,DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760)
    //SYSIN      DD *                                              
    UNLOAD TABLESPACE                                              
    DB2 YES                                                        
    LOCK NO                                                        
    SELECT *                                                       
    FROM DSN81310.EMP                                              
    OUTDDN SYSREC1                                                
    FORMAT FASTU-DELIMITED SEP ',' DELIM '|' NULLVAL ''            
    LOADDDN SYSPUNCH                                              
    //******************************************                                                          
    //STEP2    EXEC PGM=SORT                                      
    //SYSIN    DD *                                                
     OPTION COPY                                                  
     INREC FINDREP=(IN=C'''',OUT=C'''''')                        
    /*                                                            
    //SORTIN   DD DSN=&&TEMPDS1,DISP=(OLD,DELETE)                  
    //SORTOUT  DD DSN=&&TEMPDS2,                                  
    //            DISP=(NEW,PASS),SPACE=(CYL,(410,410),RLSE),      
    //            UNIT=DTA,DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760)
    //SYSOUT   DD SYSOUT=*                                        
    //*                                                            
    //******************************************                                                          
    //STEP2    EXEC PGM=SORT                                        
    //SYSIN    DD *                                                  
     OPTION COPY                                                    
     INREC FINDREP=(IN=C'|',OUT=C'''')                              
    /*                                                              
    //SORTIN   DD DSN=&&TEMPDS2,DISP=(OLD,DELETE)                    
    //SORTOUT  DD DSN=U552071.HPU.R003,                              
    //            DISP=(,CATLG,DELETE),SPACE=(CYL,(410,410),RLSE),  
    //            UNIT=DTA,DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760)  
    //SYSOUT   DD SYSOUT=*                                          
    /*                                                                                                         
    //******************************************