DSXchange

I have to run a unix script to load the data into warehouse. Is it better to use after job subroutine or a sequencer that will call the script if the job ran successfully ?

Is there anyway we can get the End Time of the Job. We can get startDate and Start Time, but not End Date and End Time using DS Constants..? Any Ideas?

Thanks Guys..This Helps

Thanks Craig,

But when I am trying to run after job routine for row count, its giving compilation errors. Says DSAttachJob needs to be dimensioned. What I am trying to do is first Attach the job, then get job info, stagelist and then row count. But its not working...

I want to give a warning when the source file is empty but the job should not abort. Right now if I have an empty source file, the the job aborts as the source spage cannot read the file. Can anyone tell me how to handle this situation? My requirement is that the job should not abort but should give...

yeah thats true Ray, but thats the Client requirement....thats how they want. That was the first thing I suggested but they wanted it to be written in the file as soon as the job is executed.

Can you throw more light on this.

I have a situation where I need to log Job information in the file. There are DS routines that I can use ? And is it anyways I can run them afterstage or afterjob ? I want the timestamp, row count, job name..all these write into flat file in same job. And if someone can tell me in steps as to how to...

How to insert parameters automatically for the jobs, in sequncer. Here I dont want to enter parameters manually, it should happen automatically.
So do i have to design a job with that stores parameters in file ?

Thanks Craig, But my problem is the tables on which i m doing join, are different from the tables that I will use to find Sum. So how can i use all these tables in the Driving stage. I need to have some design where I have to use two different DB stages. Suppose I have 4 tables, where i need records...

Can anyone Tell me how to Design a job, where few coluns in the target files need Joins beweent table, few need Sum result and few need the record count for particular where condition in join. can you desin this within one job ?

Hello Everyone,

Can anyone tell me What is Hirerarchical Flat file ? and How to create a hirarchical flat file in DS 6?

Thanks