Bugzilla – Full Text Bug Listing
| Summary: | Table Extract fails on DECIMAL (m n) column type or extract on null | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [Tools] Data Tools | Reporter: | Chunqiu Ji <cji> | ||||||
| Component: | DataTools | Assignee: | Brian Payton <bpayton> | ||||||
| Status: | RESOLVED FIXED | QA Contact: | |||||||
| Severity: | normal | ||||||||
| Priority: | P3 | CC: | bpayton | ||||||
| Version: | 1.6 | ||||||||
| Target Milestone: | 1.9.2 | ||||||||
| Hardware: | PC | ||||||||
| OS: | Windows 7 | ||||||||
| Whiteboard: | |||||||||
| Attachments: |
|
||||||||
Adding another problem with this bugzilla: The problem is: when a table column contains null data, run Table ---> Data ---> Extract, the extract output shows blank for the column that contains null data. The fix is to output NULL for the column that contains NULL data. The Table ---> Data ---> Load runs successfully on the data input that contains NULL. Created attachment 201593 [details]
dtp fix patch for extract on decimal and extract on null problems
The 2nd fix patch contains fixes for reported two problems: extract on decimal(m,n) and null.
Committed the change to the DTP 1.9.2 stream, tagged to v201109220530. |
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