DSXchange

I have a utility available for mass-updating the auto-purge setting. This works for DS 5 and 6, don't know yet about 7. USE AT YOUR OWN RISK. The author makes no guarantee to results, and make sure you have your project backed up whenever attempting internal hacking. Paste this into a BATCH job, and...

When a hashed file "pre-load file to memory is Enabled", a warning message as the following is showed. This hashed file is very small (only three rows in it). It doesn't need 128M cache. The hash file will use the minimum amount of memory necessary to cache the file. It will not EXCEED this setting...

I would lay a bet on that the poster has not detached the current job handle and re-attached a new handle. You need a new handle for every run, and must detach the old if you want to RESET the job.

I did find a *neat* way to write a Python script which accomplishes exactly what I want. Thanks anyway. Well don't tease us. It's your obligation to share with everyone here anything valuable or beneficial to the community. Could you please post a summary of your solution, as well as the source cod...

If ISNull (BillingAddressesIn.BILLING_ZIP_CODE) then BillingAddressesIn.BILLING_ZIP_CODE = '00000' else Left(BillingAddressesIn.BILLING_ZIP_CODE,5) Should be If ISNull (BillingAddressesIn.BILLING_ZIP_CODE) then '00000' else Left(BillingAddressesIn.BILLING_ZIP_CODE,5)

remsh and rsh are OS programs for running commands on remote systems. From your Unix box, use remsh to execute dsjob on the Windows DS server.

Please search the forum. This has been covered in detail. Search for SCD, I'm sure you'll get a lot of hits.

Search this forum, there are a lot of examples and code posted.

In my experience, the database query usually dies with the STOP button, but sometimes it doesn't. I can't tell you when or why, I just know it happens on all databases. So, always check using ps after STOPping jobs. It's better to be safe than sorry.

Thanks a lot for the reply. Keneth, I have a doubt yet: when I run CLEAR.FILE &PH& the file .uvnlsmap remains in the directory, in that way it's a bit different from delete all files manually. I guess it doesn't matter if .uvnlsmap exist or not, it will be recreated when a job run again, Am...

If you have a query that does not release the DataStage thread, you will find a zombie process. If you stop a job, always check by doing "ps -ef|grep phantom" and look to see if a thread of a job is still running. Most likely you would have seen this. A "kill -15" on this process might release the q...

Yes, just keep in mind that read and write caching will prevent a subsequent row from "seeing" the preceding row if it's trying to reference it. You must not use caching if you need to reference a precedingly written row. If you don't care, then use write-delay caching, and if necessary, you can use...

Hi, I dont think CLEAR.FILE deletes any thing, it only clears the contents of the file i guess. With my limited knowledge on this topic But i checked the Basic manual here is what it says The &PH& directory is not a hashed file. It is of a type whereby all records in that "file" are really ...

1. Has this command the same efect than delete "manually" all files in &PH& directory? Yes 3. I found in this foro the following recomendation "regularly clear the contents of the &PH& and &SAVEDLISTS& directories and the directory whose pathname is recorded against the UVTE...

How about this: Job control routines allows INFINITE flexibility in doing what you want. Job sequencers allow INFINITE flexibility, as you only can do what the stages allow (within reason). Job control routines allow you to absolutely control job execution in ways that the sequencer can't even dream...