Saved DataStage Jobs path

amit_haldar · Post by **amit_haldar** » Wed Apr 05, 2006 10:58 am

Hi,
I am a new user of Datastage. I have a queery. When we are saving the datda stage jobs or sequence, it gets saved in form of some file in the server . I want to know where is this stored. actually I want to run a sequence through a shell script. So I want to know the path where the jobs is stored so that I can run the file from shell script

ArndW · Post by **ArndW** » Wed Apr 05, 2006 11:02 am

Jobs are not stored in editable UNIX or Windows file objects, they are stored as records in hashed files (tables) in the DS repository, which uses a derivation of the UniVerse postrelational database.

You can do a project export into XML format to get all your DataStage information into an editable text file; but risk breaking jobs by making modifications to that file.

amit_haldar · Post by **amit_haldar** » Wed Apr 05, 2006 11:22 am

Hi,
Thanks for your reply. So can you please tell me a way to run a job sequence using shell scripts. we have Datastage server edition installed over here.

Thanks in advance

quote="ArndW"]Jobs are not stored in editable UNIX or Windows file objects, they are stored as records in hashed files (tables) in the DS repository, which uses a derivation of the UniVerse postrelational database.

You can do a project export into XML format to get all your DataStage information into an editable text file; but risk breaking jobs by making modifications to that file.[/quote]

ray.wurlod · Post by **ray.wurlod** » Wed Apr 05, 2006 4:12 pm

The command line interface dsjob can be used to execute a job sequence. This command is fully documented in the Server Job Developer's Guide (which you have in your Docs folder on the machine where DataStage client software is installed).

Search the forum for some good examples of how to use dsjob from a shell script.