Page 1 of 1

parameter concatenation

Posted: Thu Mar 18, 2010 3:41 am
by rkdatastage
Hello Friends
I need a suggestion from you.

I had a requirement like concatenating 3 parameters into 1 parameter and had to pass it to a sequence.

Any thoughts please.

example : i had 3 parameters like databasename,schemaname,tablename.
I had to pass this values to one parameter like
databasename+schemaname+tablename


Thanks in advance

Regards
RK

Posted: Thu Mar 18, 2010 3:45 am
by ArndW
When calling a job from a job sequence you choose what parameters to pass, so doing what you are asking is a simple task.

Posted: Thu Mar 18, 2010 4:04 am
by rkdatastage
Hi ArndW

Thanks for your response

I am able to solve my problem , i just forgotten the string concatenation operator. (:).

like databasename:schemaname:tablename