Page 1 of 1

Unix command in datastage using External filter stage

Posted: Tue Jun 10, 2008 4:01 am
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.

Posted: Tue Jun 10, 2008 4:21 am
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.

how to use properties for external filter stage.

Posted: Tue Jun 10, 2008 4:32 am
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.

Posted: Tue Jun 10, 2008 6:02 am
by ArndW
Sure, you can do that. Change the command to "cut" and add the arguments "-d ','-f 2"