Not enough room in ustring for decimal[13,2].

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

Not enough room in ustring for decimal[13,2].

Post by just4u_sharath »

Project:CN_7-FI_N1_QA (EDRP001)
Wodetitd_Wodettrn_T10_ldr: Error when checking operator: When binding input interface field "OVRHD_DISTRIB_XCL_AMT" to field "OVRHD_DISTRIB_XCL_AMT": Implicit conversion from source type "decimal[13,2]" to result type "ustring[max=13]": Not enough room in ustring for decimal[13,2].
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hmmm "1234567890123" is displayed as "12345678901.23". How many characters is that?
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

Not enough room in ustring for decimal[13,2].

Post by just4u_sharath »

char / -00000044215.22

source and target using decimal 13 2
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The string needs two more characters than the precision - one for the sign and one for the decimal place designator. So you need ustring[max=15].
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply