Page 1 of 1

Concatenation function to be used in transformer?

Posted: Mon May 05, 2008 11:27 pm
by raam_datastage
I need to concatenate two string fields.what is the equivalent of : in parallel edition?.Is concatenation possible in modify stage?

Posted: Mon May 05, 2008 11:31 pm
by devidotcom
As far as I know concatentation is not possible in modify stage

Posted: Mon May 05, 2008 11:32 pm
by raam_datastage
Column export stage is one way to do this.But are there any concatenation function available which can be used in transformer?

Posted: Mon May 05, 2008 11:34 pm
by raam_datastage
Column export stage is one way to do this.But are there any concatenation function available which can be used in transformer?

Posted: Mon May 05, 2008 11:36 pm
by devidotcom
Yes in transformer we can do it but without any function just use :

String1:String2

Posted: Mon May 05, 2008 11:38 pm
by BugFree
Concatenate is same ":" in parallel as well. You can do it in a transformer stage. Not sure about Modify though.

Posted: Tue May 06, 2008 1:23 am
by krisna
In transformer we can use ":" for concatenating two strings.

The modify stage alters the record schema of its input data set. The modified data set is then output.

I think modify stage cannot be used for concatenating.

Posted: Tue May 06, 2008 1:24 am
by krisna
In transformer we can use ":" for concatenating two strings.

The modify stage alters the record schema of its input data set. The modified data set is then output.

I think modify stage cannot be used for concatenating.