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.
Hoew to populate blank Spaces in Seq File.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
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.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
ambasta
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi Arnd,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 ...
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.
ambasta
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sometimes you just have to tolerate tedious.ambasta wrote: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.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
The only alternative is to hack the Repository, which is only for the arrogant and foolhardy.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.