Unix command in datastage using External filter stage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
devesh_ssingh
Participant
Posts: 148
Joined: Thu Apr 10, 2008 12:47 am

Unix command in datastage using External filter stage

Post by devesh_ssingh »

Hi,

I want to use Cut command in Datastage job with External filter stage.

My command is
Cut -d ',' -f 2

but not able to use argument part of above command in External filter stage.

when I am running Datastage job getting following:

External_Filter_0,0: Wrapped Unix command 'cut -d ','-f 2' terminated with error, exit code 2.External_Filter_0

External_Filter_0,0: cut: invalid delimiter


Can anyone help me how to give argument part in External filter stage.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I am not sure what is happening in your case, I just wrote a simple test (row generator -> external command -> peek) and put in your cut command and it worked like a charm.
devesh_ssingh
Participant
Posts: 148
Joined: Thu Apr 10, 2008 12:47 am

how to use properties for external filter stage.

Post by devesh_ssingh »

ArndW wrote:I am not sure what is happening in your case, I just wrote a simple test (row generator -> external command -> peek) and put in your cut command and it worked like a charm. ...

I wanted to know how to use external filter stage properties so that it will recognize argument which i am sending.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Sure, you can do that. Change the command to "cut" and add the arguments "-d ','-f 2"
Post Reply