DSXchange

Where can I find the Last Compilation Date and the Last Saved Date for DataStage Jobs. Since our DEV/QA/PROD environment are all the same we move jobs from DEV to QA and PROD by just exporting the jobs with both "Job designs" and "Job executables" and then when we import it back ...

We have a sub-routine to do this which checks for the status of that particular job and returns a value and calls corresponding JobActivity based on the return value of the routines Trigger. So If I have 2 Server Job to run I would have job activity that would call the ServerJob linked to a routine ...

I am sorry I forgot the first step

rpt$ = Iconv(DSMakeJobReport(hJob,0,"LF"),"MCP")

where hJob is the job handle obtained by DSAttachJob() function

Here is the piece of code that I use hope it helps vJobBatchName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) vJobName = rpt$[(Index(rpt$,"STATUS REPORT FOR JOB:",1)+22),Index(rpt $,"Generated:",1)-(Index(rpt$,"STATUS REPORT FOR JOB:",1)+23)] vTimeStamp = rpt$[Index(rpt$,"G...

Another one of my dumb questions. :) Can we run SQL type queries on normal DataStage hash file ? Since I have very large hash files and opening them through Data Stage designer often freezes my client which results in locked jobs. So presently I have to do all this through ETL jobs to filter out the...

I am not an ADMIN which should be quite obvious by ny nick. How do I find the details (Created by, Date) for DataStage objects like HashFiles, Routines and Table Defs.

Thanks in advance.

Thanks a lot for the help -Craig quote: Originally posted by chulett [br]How are you working with the files now? Are their names passed in as parameters? Loaded one at a time? Wildcarded? If you already know the name of the file and have it passed in as a parameter, look at setting up a Stage Variab...

I have a job that receives files from different departments and they all have the same layout the name of the file is xxxFilename where xxx is actually the department code. In the output file which is actually a merge of all the department files i have a field DEPT_CODE that I want to populate from ...

I have a situation where I have to pass a parameter to the job based on the the first 3 chars of the name of the Input file. The question is can this be done by DStage ?

Thanks for the reply Wurlod, the reason why I want to do this is that we want to automate the process of cleaning up the log files once in 3 months Pl let me know if there is any other way to automate this process.

How do I delete JobLog from a DataStage routine ?