Concat inserted parameter values into Arguments of Sequenc

dylsing · Post by **dylsing** » Mon Jun 19, 2006 2:22 am

Hi,

I have a email routine which I am activating in a Job Sequence using Routine Activity.

Because the routine requires me to input the email message as an argument, I would like to concat certain parameter values and a standard string.

For example (FILENAME and DATE are job parameters):
"The file name that was output is " + FILENAME + ", " + DATE

I have searched the forums and the help files and it really seems like it is not possible.

-Can I do something similar to the above in the argument value expression?
-If not, how can I achieve the same effect?

Thanks!

ArndW · Post by **ArndW** » Mon Jun 19, 2006 2:36 am

The DataStage server concatenation operator is the colon ":" character, not the plus "+" sign.

dylsing · Post by **dylsing** » Mon Jun 19, 2006 2:51 am

ArndW wrote:The DataStage server concatenation operator is the colon ":" character, not the plus "+" sign. ...

Hi hi,

thanks for the reply. I am aware of using the colon character ":" however does this mean that if I use this I am able to use the colon character in the Sequence Argument value expression to concat my string with the parameters?

ArndW · Post by **ArndW** » Mon Jun 19, 2006 2:56 am

In almost all cases where you can specify a parameter you can use the concatenation operator to put together constants and variables. You haven't specified exactly where and how you are doing this, so I can only answer that "yes, probably it will work".

dylsing · Post by **dylsing** » Mon Jun 19, 2006 3:12 am

ArndW wrote:In almost all cases where you can specify a parameter you can use the concatenation operator to put together constants and variables. You haven't specified exactly where and how you are doing this, so I can only answer that "yes, probably it will work".

1) I am doing a job sequence and in it there is JOB1 followed by a Routine Activity stage.

Sequence
----------------
JOB1 -> Email Routine Activity (contains an argument EmailContent)

2) If JOB1 succeeds, I will use the Routine Activity stage to call my email routine (generic one which I am required to use) to send out a particular message.
3) The argument EmailContent should contain a fixed string concatenated with the parameters.

- So the main question, will I be able to use this colon character in the value expression of EmailContent?

loveojha2 · Post by **loveojha2** » Mon Jun 19, 2006 3:21 am

Yes, that's what Arnd has mentioned.
You can have somthing like
Arg1 : Arg2 : Arg3 in the value expression.

dylsing · Post by **dylsing** » Mon Jun 19, 2006 3:26 am

Hihi,

I just realised this is possible when I tried tinkering around with another sequence I created.

Not a great question I must admit

so thanks for bothering to answer my question!