orchdbutil

ramesh_inform · Post by **ramesh_inform** » Mon Feb 11, 2008 4:59 am

what is the use of "orchdbutil" ?[:)]

ArndW · Post by **ArndW** » Mon Feb 11, 2008 5:07 am

the orchestrate command "orchdbutil" is not normally called by users. It is called as part of the generated scripts that are run by DataStage jobs. You can call up "orchdbutil" from the command line to see the options, but be aware that it depends upon other settings and parameters as well.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 11, 2008 10:34 pm

Primarily to import table definitions more accurately than plug-in stages do.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 11, 2008 10:36 pm

Primarily to import table definitions more accurately than plug-in stages do.

jhmckeever · Post by **jhmckeever** » Tue Feb 12, 2008 12:40 am

If I'm not mistake, 'orchdbutil' is what's invoked in the background when you right-click a table definition and select 'Import' -> 'Orchestrate Schema Definitions ...'

Anyone want to confirm/deny this?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 12, 2008 1:34 am

Deny. It's not in the background - it's very much in the foreground, with only a wizard between you and it.

jhmckeever · Post by **jhmckeever** » Tue Feb 12, 2008 5:39 pm

Thanks Ray -

I wanted confirmation that the wizard employs the orchdbutil utility. I suppose I should have phrased it along the lines of 'the wizard generates the orchdbutil command line for you'.

J.