DSXchange

DSguru2B wrote:I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.

Target is already CHAR and it is Fixed Width file.

is there any option available in sequential file,such that it will automatically populate those many no of blank spaces!!!!

DSguru2B wrote:Specify it as char in you job itself. That should take care of it.

Thanks a lot for your kind suggession,but i am having source data as decimal and decimal value is coming for that column.

Thanks Ray,
Itried using this using cahr(8) this is taking balank spaces but when i tried with char(7)it is also giving me the desired result.


Thanks.

Hi Ray, when i am multiplying that data with 100 it is returning me zero. Now what i have done is ...defined target column as char(7,2).then data is coming like[ 00005.20]{data followed by blank space}.first i am taking substring[2,5] and then concating with substring[8,2].it is giving me the desire...

Are you able to find the solution.if yes! please let us know how we can do that???

No Issues Arnd, whenever you will get a chance to look into it please give a trial and let me know the solution??
Thanks.

If you define your output columns as fixed char with the appropriate widths, DataStage will implicitly perform the character conversion and add the space padding. But in order to do so you need to exp ... Hi Arnd, Output column is fixed as this is a fixed width file having CHAR.i am setting NULL FI...

select the Null field value option in sequential file in format tab set it as ' ' with no. of spaces depending upon ur col width Thanks for your kind Input,but i am having this constrain for around 100 field.All fields are having different length,this means i will have to set Null Field Value at co...

Hi All, I have two jobs.First job is Oracle to Dataset and 2nd is from that dataset to sequential fixed width file.In oracle field is having datatype numeric(15,2) and data is 5.2 I am writing this to dataset and converting it to numeric(7,2)in dataset i am able to see data as 00005.20.in next job m...

Hi All,
Source is oracle and Target is Sequential fixed width file.if any null data is coming then we need to populate those many no. of blank spaces as it is defined in file.I have having this constrain in around 100 fields.what to do???
can anyone plz help me???

Thanks.

When ever I import metadata where datatypes are CHAR, I uncheck the unidata option and that works for me. It might work for you as well. Also, when you are trimming the data and sending it to Lookup stage, what is the datatype of that column in the Lookup stage? From Source Char(4) is Coming and i ...

Hi, I am performing a job from file to Repository,I am doing lookup from one table as the target is having referencital integrity on it.Suppose I am getting data (1 --one followed by three space)from source file..i m trimming and sending it to the lookup stage where this data is getting rejected and...

If this space is coming in dataset,it is ok for me.but when i m writing to sequential fixed width file this blank space is also taking one space.this i do not want..can you plz suggest me any alternative.

Thanks in Advance.

Thanx for ur kind suggession. I think you are mistaken,[ 000010000024.350] is taking 13 places for integer,as there is a blank space before 0 at the starting place. later my reqirement is to write this dataset into a fixed width file having length(15,3)but my file is also occupying 16 places instead...