ArndW wrote:CHAR(4) perhaps? ...
no.. it is char(6) , data is truncated even when i changed to char(10).
Search found 33 matches
- Wed Aug 01, 2007 10:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Become truncated while exporting from ODBC
- Replies: 12
- Views: 2817
- Wed Aug 01, 2007 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Become truncated while exporting from ODBC
- Replies: 12
- Views: 2817
- Wed Aug 01, 2007 5:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Become truncated while exporting from ODBC
- Replies: 12
- Views: 2817
Data Become truncated while exporting from ODBC
hi, In my project i am exporitng data from SQL to DataSet using ODBC Stage. The problem is while extracting from SQL using ODBC, the data is getting truncated in some of the fields. here is an example In SQL the value of Char column inst_month is '200601', but in the ODBC Stage when i See ViewData t...