DSXchange

I would write a trigger that would fire upon every insert and it would go if pk is present, update the EFFECTIVE_END_DATE .

The port number might be different. You need to find that out from your dba what port number is for that particular instance.

Reference the macro DSJobStartTimeStamp as the default value for your date parameter while running from a job sequence.

Welcome Aboard
What do you have in this library?
Did you just try compiling with gCC +Z runctionname.c ?

Search on the "how to?"
This has been discussed gazillions of times.

Do an exact search on keywords "OLE server has failed"

Dont run the script that handles failed jobs at the same time as your regular run. It will create confusion. Keep it plain, keep it simple. Easier to manage and maintain. Run your failed jobs at the end. Or if you think it will be easier for you to manage a different job, go for it. Make sure you ha...

Need more info. What are you trying to do in your transformer. Are you using command line opertions like sed?

No. The autosys will just fire off your script which will do everything. Its at a lower level than what autosys can do. You will have to handle this within your script. "Pointing to the failed directory" means that you need to check in your script if the job failed, if it did then pass the directory...

"datastage_date" will be a parameter that you send in.
Its really strange that your system date is dummy

You can keep the same job just make it point to the 'failed job' directory. How you are going to do that depends upon how are you currently controlling your process. Are you using Job Sequence or a custom Control Job or a Unix script? Regardless, however you are specifying parameters currently, simi...

Read in the sequential file stage help pdf file about "File Pattern" in "Read Method". I would say its a better way to handle your requirement. It also takes in wild cards and processes all the files.

Usually the DataStage job developer takes care of parameter assignment. If a job fails. Just change the input file name which will have to be parametrized, and re-run that job. If you have to explore doing that with Autosys, you will have to talk to autosys folks to see how they can pass the paramet...

What i feel is there should be a file where DSN name,userid to oracle,password should be stored. Do we need to create a file like that. All of that would be parametrized at the end of the day. Then these parameters would be retrieved however you want to. Some store it in a file. Some prefer using D...

ray.wurlod wrote:Best practice, however, is to create hashed files for DataStage in one or more dedicated directories, and thereby to avoid cluttering up the account.

Very good piece of advice from Ray. Vijaykumar, you can pass the word onto your "friends".