Pad char in Sequantial File stage. Where is it?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
splayer
Charter Member
Charter Member
Posts: 502
Joined: Mon Apr 12, 2004 5:01 pm

Pad char in Sequantial File stage. Where is it?

Post by splayer »

In the Advanced Developer's Guide, in "Using Sequential File Stages", it talks about the "Pad char" property in the Edit Column Meta Data box. I have DS 7.5. When I open the Edit Column Meta Data box, I don't see this property. Is it because of the version issue?
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Re: Pad char in Sequantial File stage. Where is it?

Post by rwierdsm »

SPlayer,

I'm running 7.5x2, and this is how I can get at the pad character property

- Go to the Columns tab of the properties of the sequential file stage
- double click on the row number column (the grey column with a number)
- highlight the Integer type or String type branch in the Properties box
- Pad Char is one fo the available properties

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
splayer
Charter Member
Charter Member
Posts: 502
Joined: Mon Apr 12, 2004 5:01 pm

Post by splayer »

Thanks rwierdsm. My DS version says just 7.5 but I'll try. Appreciate your help.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Instead of double click on the row number in the Columns grid you can also right click on the row, and choose Edit Row from the pop-up menu to get to the dialog.

You can also triple-click (!) on the row using the left mouse button, but you have to get the timing of a triple-click just right.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
splayer
Charter Member
Charter Member
Posts: 502
Joined: Mon Apr 12, 2004 5:01 pm

Post by splayer »

ray, Edit Row does not work. It brings up the Edit Column Meta Data dialog box but I don't see the Pad char property. This might be because I am on Windows 2003, DS 7.5.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Click on the Server tab in the Edit Column Meta Data dialog, and fill in the Padding character there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
alphac
Participant
Posts: 10
Joined: Thu Jul 20, 2006 3:33 am
Location: HK

Post by alphac »

If you want to apply to whole project, you may set environment variable APT_STRING_PADCHAR. Thats quite convenient in Parallel engine.
alphac
Post Reply