DSXchange

I want to get the list of all jobs in Datastage in a sequential file. Please let me know what command to run. or is there any way to achieve it through a datastage job itself

From a Job use DSGetProjectInfo function with = DSJ.JOBLIST and link this output to a file.
Command line -
dsjob -ljobs <Project>
or
$DSHOME/bin/uvsh "select * from DS_JOBS" > /FileName.txt

In a job create a single Varchar column called NAME. Mark it as key. Use a UniVerse or Hashed File stage to read from DS_JOBS. Constrain so that you only get names beginning with other than "\" or "/" - these are control records, recording the existence of categories and the next available job number.

You can also query by using ds command 'dssearch'