Description Chunqiu Ji 2011-08-05 14:01:54 EDT

Created attachment 201001 [details]
fix patch

Client Concerns/Problem:                                                
RDz 8.0.1/RAD 8.0.1 Data Tools > Data Source Explorer view on a z/OS    
DB2 v9.1 NFM (new function mode) connection                              
and any Table such as for this ddl:                                      
                                                                        
CREATE TABLE "BOBDYTY"."EVENTS" (                                        
  "NUMBER" SMALLINT NOT NULL,                                            
  "NAME" VARCHAR(25) FOR SBCS DATA NOT NULL,                            
  "EVENT_DATE" DATE NOT NULL,                                            
  "LOCATION" CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,                  
  "FEE" DECIMAL(5 , 2) NOT NULL                                          
)                                                                      
AUDIT NONE                                                              
DATA CAPTURE NONE                                                      
CCSID EBCDIC;      

insert into  
values(1, 'aaa', CURRENT DATE, '123456789A123456789A',
10.1);

insert into "BOBDYTY"."EVENTS"
values(2, 'bbb', CURRENT DATE, '123456789A123456789A',
20.1);

insert into "BOBDYTY"."EVENTS"
values(3, 'ccc', CURRENT DATE, '123456789A123456789A',
30.1);                                                    
                                                                        
, in which there is a DECIMAL (m,n) column.                              
                                                                        
RC on the table > Data > Extract                                        
results in the error:                                                    
                                                                        
Extracting "BOBDYTY"."EVENTS"...                                        
Data extraction was successful.                                          
4 row(s) extracted.                                                      
One or more values could not be retrieved in the following column(s):    
FEE