About DSUTILITY

vijaykumar · Post by **vijaykumar** » Mon Jan 08, 2007 5:47 pm

Hi Gurus,
Is there any utility which runs from my operating system and is used to export all the jobs which i created and are present in the repository.
plz Gurus help me, i created some jobs, my team lead wants me to export those jobs using operating system utility.plz help me.

cheers;
vijay

us1aslam1us · Post by **us1aslam1us** » Mon Jan 08, 2007 5:50 pm

You can do that through DataStage Manager. You can export the Job to a particular location in the form of .dsx or .xml file.

vijaykumar · Post by **vijaykumar** » Mon Jan 08, 2007 5:54 pm

Hi Gurus,
My requirement is different, i want a operating system command, my operating system is windows.
i have designed 3 jobs, i want to export all the jobs, is there any operating system utility. plz help me.

cheers;
vijay

vijaykumar · Post by **vijaykumar** » Mon Jan 08, 2007 5:57 pm

Hi Gurus,
As utility ds-report projectname jobname which helps in generating report, similarly is there any utility which helps me in exporting all the jobs which i created .plz Gurus help me.

cheers;
vijay

narasimha · Post by **narasimha** » Mon Jan 08, 2007 6:00 pm

You can use dscmdexport

Search for related posts.

us1aslam1us · Post by **us1aslam1us** » Mon Jan 08, 2007 6:13 pm

Check this particular post, Anand has given a script :

viewtopic.php?t=98137&postdays=0&postor ... t&start=15

vijaykumar · Post by **vijaykumar** » Mon Jan 08, 2007 7:22 pm

Hi Gurus,
Thanks Very much.
i used DSExport USERNAME PASSWORD PROJECTNAME JOBNAME PATHNAME.
when i run this command , its successfuly exporting, its exporting the entire project not a individual job.
Its not taking jobname into consideration.
even with the pathname i have a problem.
i created a folder in c-directory inorder to export all the jobs into that directory but individually.
i specified DSExport USERNAME PASSWORD PROJECTNAME job1 c:/hash
job1 is the jobname
hash is the foldername which i created inorder to dump the exported jobs.
Its just working.
i altered and i gave DSExport USERNAME PASSWORD PROJECTNAME job1 job.
Now its working, it simply created a .dsx file, the name of the file is job1 job.
Plz help me why is it ignoring pathname and jobname which i specified, instead it is dumping entire project.
plz help me Gurus, am i going in wrong way.

cheers;
vijay

narasimha · Post by **narasimha** » Mon Jan 08, 2007 7:26 pm

Vijay,

I thought you had corrected your cases while posting!

Please make your posts more readable.
Use Proper case. I know you are in a hurry, but don't strain others, who have to read your post

I_Server_Whale · Post by **I_Server_Whale** » Mon Jan 08, 2007 7:40 pm

Until now, always hurts my eyes

to read your unformatted, case-ingnorant posts.

You are making it difficult for yourself and others by not posting in the right format.

Please make sure that you break your post into decent paragraphs and ALSO use the right case at the right time.

Again, FYI;
When you are referring to yourself, you should be using 'I' always, instead of 'i'.

HTH,
Whale.

vijaykumar · Post by **vijaykumar** » Mon Jan 08, 2007 9:53 pm

Hi,
I used DSExport USERNAME PASSWORD PROJECTNAME job1 c:/hash
Where job1 = name of the job
hash is foldername which i created inorder to dump the exported jobs.
Its just working.
It simply created a .dsx file, (ie) job1 job.dsx
Plz help me why is it ignoring pathname and jobname which i specified, instead it is dumping entire project. Plz help me Gurus.
Sorry i didn't use the correct format.

cheers;
vijay

DS_SUPPORT · Post by **DS_SUPPORT** » Mon Jan 08, 2007 10:25 pm

Use the same code which is mentioned in another post

Code: Select all

C:\Progra~1\Ascential\DataStage7.5\DSExport.exe /U=Username /P=Password /H=HostName /JOB=YOUR JOBNAME ProjectName C:\hash\a.dsx

ray.wurlod · Post by **ray.wurlod** » Mon Jan 08, 2007 11:48 pm

If DSUTILITY is a DataStage utility, what is the generic term for a file utility?

DSguru2B · Post by **DSguru2B** » Tue Jan 09, 2007 8:37 am

Is that a quiz question?
The answer is FUTILITY (notice the answer in caps)

chulett · Post by **chulett** » Tue Jan 09, 2007 8:50 am

Oh please, don't encourage him.

DSguru2B · Post by **DSguru2B** » Tue Jan 09, 2007 8:53 am

Just having a little fun