Hoew to populate blank Spaces in Seq File.

ambasta · Post by **ambasta** » Wed Oct 11, 2006 11:09 am

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.

samsuf2002 · Post by **samsuf2002** » Wed Oct 11, 2006 11:56 am

select the Null field value option in sequential file in format tab set it as ' ' with no. of spaces depending upon ur col width

ambasta · Post by **ambasta** » Wed Oct 11, 2006 1:02 pm

samsuf2002 wrote: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 column level,that is very tedious.Is there any other way out.

ArndW · Post by **ArndW** » Wed Oct 11, 2006 2:18 pm

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 explicitly declare the lengths.

ambasta · Post by **ambasta** » Wed Oct 11, 2006 2:24 pm

ArndW wrote: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 FIELD VALUE as ' '.but this is not working for me.

ArndW · Post by **ArndW** » Wed Oct 11, 2006 2:27 pm

I just re-read the post and realized that I misunderstood the question regarding nulls vs. normal padding. My mistake. I'm not at a DS enable computer now, but I was fairly certain that the row attributes have some setting letting the string be padded. If someone else doesn't give a solution I'll see what that setting is tomorrow.

ambasta · Post by **ambasta** » Wed Oct 11, 2006 2:32 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Oct 11, 2006 2:48 pm

ambasta wrote:
samsuf2002 wrote: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 column level,that is very tedious.Is there any other way out.

Sometimes you just have to tolerate tedious.

The only alternative is to hack the Repository, which is only for the arrogant and foolhardy.