Where Do I find the 'dsexport' command?

chulett · Post by **chulett** » Wed Nov 19, 2014 3:00 pm

It's a client utility.

joycerecacho · Post by **joycerecacho** » Wed Nov 19, 2014 3:06 pm

Ok. And how do I do?

chulett · Post by **chulett** » Wed Nov 19, 2014 3:10 pm

Sorry, how do you do what? It's on your client PC rather than the server but it's still a command line utility. If you're not sure of the syntax you can do an exact search for it here and find plenty of examples.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2014 3:22 pm

C:\IBM\InformationServer\Clients\Classic\dsexport.exe

thanush9sep · Post by **thanush9sep** » Wed Nov 19, 2014 7:26 pm

My scenario, I access Datastage client from Citrix and do not have client installed in my machine.
In that case, you need to find some remote system where you can find Client installed and run your script
If not just try using istool utility ...
As far as dsexport, it is not available in your unix directory and that makes it impossible to take individual dsx using scripts

kduke · Post by **kduke** » Thu Nov 20, 2014 10:06 pm

There is a scripts.zip on raywurlod.com that has a lot examples on how to export jobs using dsexport.exe. Those might help.

chulett · Post by **chulett** » Fri Nov 21, 2014 8:13 am

Use the -ljobs option of the dsjob command, then iterate through the list that generates.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 21, 2014 3:51 pm

dsjob -ljobs projectname

Remember that the project name is case sensitive.

chulett · Post by **chulett** » Fri Nov 21, 2014 5:18 pm

Of course, wasn't implying that was the full syntax. I shall... rephrase. Revisionist history FTW!

ray.wurlod · Post by **ray.wurlod** » Tue Nov 25, 2014 3:28 pm

Code: Select all

CD %PROJECT_DIR%
%DSHOME%\bin\dssh "SELECT NAME FMT '40L', JOBNO FMT '5R' FROM DS_JOBS WHERE NAME NOT LIKE '\%';"

kduke · Post by **kduke** » Sun Nov 30, 2014 7:55 pm

In my scripts there is a dsjob -ljobs project that is commented out. See if you can find it. It needs the same connection information as the dsexport command as far as user and password and domain. It is the only way within the client.

joycerecacho · Post by **joycerecacho** » Mon Dec 01, 2014 7:28 am

Guys,
Executing the .bat I am developing, everytime that a job is exported a DataStage window open asking me to click 'Close'. If I have 100 jobs, it will ask me 100 times.

It says: "x read-only objects were ommited"

Is there any way to ommit this window? Otherwise the .bat makes no sense.

Thank you very much.

Best regards,
Joyce

priyadarshikunal · Post by **priyadarshikunal** » Mon Dec 01, 2014 11:12 am

try dscmdexport which should be in same directory however it will take entire project export.

kduke · Post by **kduke** » Mon Dec 01, 2014 12:20 pm

My scripts are on www.raywurlod.com now. Do an exact search for Autoit here to find out how to suppress the warning screen.

viewtopic.php?t=147125&highlight=autoit
viewtopic.php?t=132703&highlight=autoit

kduke · Post by **kduke** » Wed Dec 03, 2014 1:17 pm

It never worked me like that either.

Code: Select all

const $WinTitle = "DataStage" 

Local $pid = Run("DataStageJobDocsDriver.bat")

While ProcessExists($pid)
	If WinGetHandle($WinTitle) <> "" Then 
		WinActivate($WinTitle) 
		Send("{ESC}")
	EndIf 
	Sleep(10000)
Wend