- Posts: 68
The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…
def command = "sqlldr control='"+ __ctx__.getVariableValue("../realPathOnServer") + "/data_%x{$REF/tech:workName()}x%.ctl' log='"+ __ctx__.getVariableValue("../realPathOnServer") + "/data_%x{$REF/tech:workName()}x%.log' userid=%x{$REF/ref:target()/tech:jdbcUser()}x%/%x{$REF/ref:target()/tech:jdbcPassword()}x%@%e(rhino){"%x{$REF/ref:target()/tech:jdbcUrl()}x%".replace(/^jdbc.*:@(.+):(.+):(.+)$/, "$3")}e(rhino)%"
@%x{$REF/ref:target()/tech:serverName()}x%
Thomas BLETON wrote: Hi Nicolas,
The official template includes the serverName property in this expression.
Here is the end of the line :This expression refers to the "Physical Name" of the root database node in the metadata.@%x{$REF/ref:target()/tech:serverName()}x%
Maybe your template version does not have this expression ? Or do you think it is not correct ?
sqlldr userid/password@tns_alias