Originally posted by: SystemAdmin

Hey Guys,
I know that this is a very stupid question, but I'm still building my knowledge in WTX, I have worked before with it but never knew why this happens this way, here's the problem, I have created a test map,with a very simple type tree ,the type tree contains very simple items (integer, date, Text) but when I added the decimal I had an error in the imput map when I tried to test, its always a problem with the size, I know that the size of the item includes Separators and sign while my number doesn't contain a sign, it contains a fraction
e.g.
0000000000.00
so total of 19 digit , 2 for places, and 16 for whole number
I have included the map, the type tree, and the sample input

I'm using WTX 8.2.0.2

Thanks a lot
Hany Harraz
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: janhess

In Grp1 set Format to Implicit and in Item TransAmount set Pad to No.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Thanks a lot janhess for your fast reply, I know that this would help to prevent the error from coming up, but I need TrnasAmount to be padded when used in an output card, and I know that when all of my items are of a fixed size and padded to a fixed size then I should make my group explicit, won't that make the performance better?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

Define a different Item for youtr output TransAmount - it's a different data definition.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I'm not following you, let me ask my question another way lets say that TransAmount is represented like this
xxxxxxxxxxxxxxxx.xx and I need it to come out this way in an output message, lets say that the incoming message has a field for transamount like this xxxxxxxxxx.xx, its missing 6 characters , so I use the padding option to complete the output message to meet my requirements so the output is *xxxxxx*xxxxxxxxxx.xx
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: janhess

So TransAmount has padding=yes for the output item - call it TransAmount_Out and defins a separate output group using this.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

ok, that I understand, but I don'ft understand why do I have to create a new Item for the output just to enable the padding?
can't I use the padding for an input? or is it just a bug?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

I think it's a bug. It was ok at earlier versions.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Oh, Thats why it was working with me in 8.1, thanks a lot for your help, but here comes another question, why do I need to use padding while if I set the minimum to some number, it pads automatically to that number. unless of course I want to use the minimum for validation and output the number padded to the max
thx a lot janhess you have been of great help, I was gonna bang my head to the wall, I didn't know that it was a bug
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: NancyR

If your input group containing that field is not fixed and the output group containing it is fixed, you can set Apply pad to Fixed Group. Then the WTX engine will not expect the field to be padded in the (not fixed) input group and will pad it in the (fixed) output group.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: janhess

I thought there was something I'd missed.
The Apply pad Fixed Group is on the TransAmount Item by the way.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

thx a lot this might help , if TransAmount is included in different groups, but actually its the same message used for input and output, it used to work in 8.1, but I'm having trouble with it in 8.2
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: janhess

If you do the above it's the same definition for input and output.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Sorry for the late reply, but I was on holiday, then got an engagement abroad, where the customer doesn't provide an internet copnnection !!!, anyway regarding what you said, its correct, in order to use it for input and output I will be the same definition, and thats what makes it hard, because for the output i'm gonna pad, but since there is a problem with padding when using it in an input card, i will have to separate them, but I was trying to solve it with minimal work possible,
thank you guys
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Help!
How to define the decimal data to DB2?
Like as below fixed-record(total 11 bytes)

BQ 52.00

The attachment is about the test data & map & type tree & SQL command to create the table.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender