Modify Stage - Combining Commands

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
Raftsman
Premium Member
Premium Member
Posts: 335
Joined: Thu May 26, 2005 8:56 am
Location: Ottawa, Canada

Modify Stage - Combining Commands

Post by Raftsman »

Is there a way to combine the following command in the specification line of the modify stage.

CD = string_trim[" ",end](substring[3,6](CD))

I get an error.

The CD column is a VarChar type. I need to trim the spaces for the lookup stage. Even though I use substring, I must suppress the remaining spaces.

Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I've tried combining commands in a modify stage as well and have come to the conclusion that this is not possible.
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Post by seanc217 »

Yeah I have had the same results. I would like to see IBM expand this stage to be more useful.
Post Reply