DSXchange

Hi, Source is Oracle[decimal(15,3)] and target is dataset[decimal(15,3)]. from source 10000024.35 data is coming but when i m viewing in dataset it is stored as [ 000010000024.350],that means 13 integer and 3 decimal part.but length is defined as decimal(15,3).can anyone please help me. Thanks in ad...

if there are only two column u can do edit at column level.can u go to that column and place those many no of spaces as ur field length.try this and let us know.

Try NULL FIELD VALUE=' ' in sequential file.

I am not sure...can we have anything like char(7,2)in sequential fixed width file???.if it is so,then according to my requirement it will occupy 8 spaces as period will also occupy one sapce.

Hi,
My Requirement is...
Source is oracle [Decimal(5,2)] and target is sequential file[7,2].how can we populate it.
Ex..if data is coming like 123.45 then populate 00123.45.
is it possible to populate decimal value in a fixed width file???
Can anyone please help me.

Are u parameterising the connection details or hardcoding???if parameterizing then try to hardcode and see wat u r getting.

Hi Ray,
i can't find any function called FMT in parallel jobs.I think it is not available.

Thanx a lot ArndW for this kind help.
This is working for me.

Hi All, Can anyone please help me.. Source is having Varchar(10) and target is Char(10).My Requirement is... any length of data till length 10 can come from source,and i need to pad this data with leading zeroes followed by that data so that length in target side is remain 10. Ex. if data is coming ...

Actually the incoming column's dataype is Decimal(19,4) and target datatype is char(15) as i am writing to file.My requirement is to multiply input column by 10,000 and then populate it to fixed width file.this is the actual data that i am getting 000000000000019.0000 and my requirement is to popula...

Thanx a lot for your kind suggessions,but,unfortunately these functions are not working for me.Somehow i made this work,but i don't know how it is working. Ex..if i need last 14 element out of 19 then IN.Col[16,14] is working and if i need last 12 element out of 19 then InCol[18,12] is working. Can ...

Thanx a lot for your kind suggessions,but,unfortunately these functions are not working for me.Somehow i made this work,but i don't know how it is working. Ex..if i need last 14 element out of 19 then IN.Col[16,14] is working and if i need last 12 element out of 19 then InCol[18,12] is working. Can ...

Thanx a lot your kind suggessions,but,unfortunately these functions are not working for me.Somehow i made this work,but i don't know how it is working. Ex..if i need last 14 element out of 19 then IN.Col[16,14] is working and if i need last 12 element out of 19 then InCol[18,12] is working. Can anyo...

Thanx a lot your kind suggessions,but,unfortunately these functions are not working for me.Somehow i made this work,but i don't know how it is working. Ex..if i need last 14 element out of 19 then IN.Col[16,14] is working and if i need last 12 element out of 19 then InCol[18,12] is working. Can anyo...

Can anyone please help me getting syntax for substring.
My requirement is...
I have a column having data like 0000000000012345678(length is 19)and i want to populate it to the target side as 00000012345678(length is 14).how to do it??
is there any inbuilt function in parallel job???


Regards,
ambasta