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.
Do we need to change the sql_type in parallel?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.