Execution of API Calls from DS Admin Command line

[knockalok]

I have installed Datastage on window server both client and server. I am trying to execute API Calls like "DSGETPROJECTLIST", "DSGETPROJECTINFO" but they are throwing errors like "Verb DSGETPROJECTLIST is not in your VOC".
Actually none of API calls are getting executed.

So do we need to do any setting for API calls to get executed from DS Admin command line?

Or is it Syntex error? so for API "DSPROJECTINFO" what should be the syntex.

Any inputs on the same is really appreciated.

[ray.wurlod]

Welcome aboard. :D

Easy answer; these are functions. It's not possible to invoke a function from the command line in ANY product.

There is a command line interface (dsjob) that you can use from the operating system level that yields most of the functionality of the DataStage API. You can read about this in the developer's guide.

[chulett]

Read the Command Line Interface chapter in either Developer's Guide, you'll find both 'dsjob' and the internal API documented there.

[knockalok]

Suppose i wish to see all teh jobs lying in a projec t. What is the command in DS Admin command line to view. Is there any list of command to execute from universe database?

[ray.wurlod]

Code: Select all

DOS /C "dsjob -ljobs projectname"

The DOS command causes an operating system shell to be opened, the /C switch specifies to return when the command is done. If your PATH environment variable does not include the DataStage bin folder then you will need to specify the full pathname of dsjob.exe.

Another way, querying the local repository directly, is:

Code: Select all

SELECT NAME FMT '40L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%';