IBM Support

PM72064: Retrieve SQL fails for a column of type TIMESTAMP with error SQL type ?UNKNOWN?

Fixes are available

Rational Business Developer 8.5.1
Rational Business Developer Fix Pack 2 (8.5.1.2) for 8.5.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment:
- Operating System: Microsoft Windows XP
  - Product name: Rational Business Developer 8.0.1.3
  - DB2 z/VM 7.3

Description of problem:
Retrieve SQL fails for a column of type TIMESTAMP with error SQL
type ?UNKNOWN?

Steps to reproduce:
1. Connect to DB2 z/VM from Rational Business Developer.
2. Have a table on your DB2 z/VM containing a table with a
column of type TIMESTAMP
3. Run Retrieve SQL against the DB2 z/VM
Expected Result:
Fields for all columns in the table are generated
Actual Result:
The field for the column of type TIMESTAMP is not generated.

Workaround:
Add a field for the column of type TIMESTAMP manually, after
using Retrieve SQL.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
In RBD8.0.1.3 or RBD 8.5 and before, EGL editor retrieve SQL
fails for a column of type TIMESTAMP with error SQL type
?UNKNOWN? when database connection for DB2 z/VM.

    



Problem conclusion


    

  • In RBD 8.0.1.4 and future, when connected to DB2 z/VM,
retrieve SQL will support TIMESTAMP type in the table

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM72064
    • 

  • Reported component name
    REQUISITEPRO WI
    • 

  • Reported component ID
    5724G3900
    • 

  • Reported release
    801
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-09-03
    • 

  • Closed date
    2012-10-08
    • 

  • Last modified date
    2012-10-08
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    RATL BUS DEV
    • 

  • Fixed component ID
    5724S5000
    • 



Applicable component levels


    

  • R801  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            08 October 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback