Page 1 of 2
About DSUTILITY
Posted: Mon Jan 08, 2007 5:47 pm
by vijaykumar
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
Posted: Mon Jan 08, 2007 5:50 pm
by us1aslam1us
You can do that through DataStage Manager. You can export the Job to a particular location in the form of .dsx or .xml file.
Posted: Mon Jan 08, 2007 5:54 pm
by vijaykumar
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
Posted: Mon Jan 08, 2007 5:57 pm
by vijaykumar
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
Posted: Mon Jan 08, 2007 6:00 pm
by narasimha
You can use dscmdexport
Search for related posts.
Posted: Mon Jan 08, 2007 6:13 pm
by us1aslam1us
Check this particular post, Anand has given a script :
viewtopic.php?t=98137&postdays=0&postor ... t&start=15
Posted: Mon Jan 08, 2007 7:22 pm
by vijaykumar
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
Posted: Mon Jan 08, 2007 7:26 pm
by narasimha
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
Posted: Mon Jan 08, 2007 7:40 pm
by I_Server_Whale
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.
Posted: Mon Jan 08, 2007 9:53 pm
by vijaykumar
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
Posted: Mon Jan 08, 2007 10:25 pm
by DS_SUPPORT
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
Posted: Mon Jan 08, 2007 11:48 pm
by ray.wurlod
If DSUTILITY is a DataStage utility, what is the generic term for a file utility?
Posted: Tue Jan 09, 2007 8:37 am
by DSguru2B
Is that a quiz question?
The answer is FUTILITY
(notice the answer in caps)
Posted: Tue Jan 09, 2007 8:50 am
by chulett
Oh please, don't encourage him.
Posted: Tue Jan 09, 2007 8:53 am
by DSguru2B
Just having a little fun