Page 1 of 1
Execution of API Calls from DS Admin Command line
Posted: Wed Apr 16, 2008 3:24 am
by 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.
Posted: Wed Apr 16, 2008 5:43 am
by 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.
Posted: Wed Apr 16, 2008 7:01 am
by chulett
Read the Command Line Interface chapter in either Developer's Guide, you'll find both 'dsjob' and the internal API documented there.
Posted: Thu Apr 16, 2009 11:23 pm
by 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?
Posted: Thu Apr 16, 2009 11:49 pm
by ray.wurlod
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 '\\%';