Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 358838

Summary: New Record Wizard: VARGRAPHIC and GRAPHIC data types in DB2 Express will be converted to unicode, which is unsupported
Product: z_Archived Reporter: Thomas Wu <wxwu>
Component: EDTAssignee: Zhi Zhu <zhuzhi>
Status: CLOSED FIXED QA Contact:
Severity: major    
Priority: P3 CC: zhuzhi
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
unicode error
none
DBCHAR(x) in RBD none

Description Thomas Wu CLA 2011-09-25 22:47:11 EDT 
Build Identifier: 20110923

VARGRAPHIC and GRAPHIC data types in DB2 Express will be converted to unicode, which is unsupported in EDT 0.7

Reproducible: Always

Steps to Reproduce:
1. Install DB2 Express with its sample DB.
2. New an EGL project.
3. Try to convert all tables in the sample DB to egl records file.

Actual results: VARGRAPHIC and GRAPHIC data types in DB2 Express will be converted to unicode, which is not recognized in EDT 0.7.
Comment 1 Thomas Wu CLA 2011-09-25 22:49:52 EDT 
Created attachment 203984 [details]
unicode error
Comment 2 Zhi Zhu CLA 2011-09-26 02:38:08 EDT 
Thomas, could you kindly check in RBD8 VARGRAPHIC and GRAPHIC data types in DB2 are converted to what data types? thanks
Comment 3 Thomas Wu CLA 2011-09-26 03:08:23 EDT 
Hi, Zhi. I couldn't found the "New Records from SQL Database" function in RBD8012.
Comment 4 Zhi Zhu CLA 2011-09-26 03:17:43 EDT 
Please use EGL-->Data Access Application, they play similar roles
Comment 5 Thomas Wu CLA 2011-09-26 03:45:02 EDT 
They will be converted into DBCHAR(x)
Comment 6 Thomas Wu CLA 2011-09-26 03:46:35 EDT 
Created attachment 203993 [details]
DBCHAR(x) in RBD
Comment 7 Zhi Zhu CLA 2011-09-26 20:33:45 EDT 
dbchar is not supported in current release, I suggest delaying fix for this bug
Comment 8 Zhi Zhu CLA 2011-09-27 05:27:35 EDT 
fix it in the future
Comment 9 Zhi Zhu CLA 2011-10-12 04:16:31 EDT 
Will offer warning messages for currently unsupported column data type and skip egl generation for the column
Comment 10 Thomas Wu CLA 2011-10-19 23:23:05 EDT 
Verified in build 20111019
Comment 11 Lisa Lasher CLA 2011-10-20 15:04:42 EDT 
I'm changing the target from Future to 070 Final.  This defect is fixed for now, within the restrictions of 0.7.0 functionality.  Support for additional data types will be tracked as work items for 1.0.