DSXchange

Posted: **Mon Dec 06, 2010 12:05 pm**

Do we need to change the sql_type in parallel?

COLUMN NAME: ID
SQL_TYPE: DECIMAL
LENGTH: 14
DISPLAY: 17

O/P 555

PARALLEL:

COLUMN NAME: ID
SQL_TYPE: DECIMAL
LENGTH: 14

O/P
000000000000555.

Posted: **Mon Dec 06, 2010 1:20 pm**

No. The leading zeroes are added when the value is displayed or converted to string to show that precision and scale are being handled correctly. The value is correct.

Posted: **Mon Dec 06, 2010 3:08 pm**

ray.wurlod wrote:No. The leading zeroes are added when the value is displayed or converted to string to show that precision and scale are being handled correctly. The value is correct. ...

Thanks