将光标移到/点击文章中的句子上,可以查看译文。      显示繁体中文内容    显示简体中文内容

Nested Parameters in Informatica
在Informatica中,嵌套参数

I want to see number of affected rows of my target table.for that, i can write a shell script in which i pass a parameter as $PM@numAffectedRows.However, if my target table name is parameterized and i want to pass that in the same shell, how can i do that?

Eg. $ParamTgtTable=myTable when i pass $PM'$ParamTgtTable'@numAffectedRows in the shell script, it echos myTable@numAffectedRows.if i pass the same without the quote as $PM$ParamTgtTable@numAffectedRows, i get $ParamTgtTable@numAffectedRows as my output.

Is there any workaround for this?appreciate your help on this.

时间: 作者:

pass 2 parameters seperately like $ParamTgtTable=myTable $PM@numAffectedRows=your_count

now create a third parameter as X=$ParamTgtTable$PM@numAffectedRows if didnt work try using single quotes (i dont have access to UNIX to test right now )

原作者:
...