Posted: Wed Dec 26, 2007 1:00 pm
I tried with a sample test the following
First i took a column name: Col1
Data type: Decimal
Data length: 15
First Stage variable name SONE: DecimalToString(DSLink4.Col1)
Second stage variavle name STWO: Length(SONE)
Third stage variable name STHREE: STR('0',9 - STWO)
The valus is passed to the target column name is FCol1
Data type: Varchar
Data lenth:30
i am getting the following output
source input:
123
target
000000000000123
It is not giving the actual result... what ever the input value ///it is reading and giving as an output...
the source column length is 15.. thats way it is giving 15 lenth...
i want only 9 lenth ....which is minus with the length of the column
i tried will all the options... this is immedeiate requirement to the client ... i am very new to parallel .... please help me on this
Thanks
Suresh
First i took a column name: Col1
Data type: Decimal
Data length: 15
First Stage variable name SONE: DecimalToString(DSLink4.Col1)
Second stage variavle name STWO: Length(SONE)
Third stage variable name STHREE: STR('0',9 - STWO)
The valus is passed to the target column name is FCol1
Data type: Varchar
Data lenth:30
i am getting the following output
source input:
123
target
000000000000123
It is not giving the actual result... what ever the input value ///it is reading and giving as an output...
the source column length is 15.. thats way it is giving 15 lenth...
i want only 9 lenth ....which is minus with the length of the column
i tried will all the options... this is immedeiate requirement to the client ... i am very new to parallel .... please help me on this
Thanks
Suresh