DSXchange

This post is a duplicate.

Call support. I think you found a bug.

There are not a lot people sharing jobs or routines. I have EtlStats which I share. Ken Bland has several jobs and routines which he shares on his web site. Do a search. There are lots of posts explaining mine and Ken's jobs. The same is true for hashed files. I think there is a FAQ on the subject a...

A quick patch would be to make @INROWNUM > 500000 a constraint.

Not really. You have to determine which is new in the job and then insert else update. These 2 need to be 2 different links.

It is not that smart. It just reruns the one job which failed. It will only do that once. If it fails twice it gets confused. You may need to redesign your jobs to take care of this situation or manually delete records loaded.

By the way use READ if you do not plan to WRITE to the file otherwise you will leave locked records behind unless you use a RELEASE.

There is a @TM between key fields. So

Key1 :@TM: Key2 :@TM: Key3

I what you need.

Sorry, series of jobs. I be tired.

Do a search for EtlStats. They give you routines and dsjob to get the stats but you need to put these together to get the results in a table. You can download EtlStats and it is a serious of jobs that will get row counts and put them in tables. It has examples of how to get log records and email the...

gateleys

I was just joking. I think the course has been describe lots of times. Any course with Ray as a teacher has got to be pretty good. I took the first course and learned a lot. I am sure it gets better every time he teaches it.

http://www.dsxchange.com/viewtopic.php?t=99349 might help.

Like Ray is not qualified. Give me a break!

Good job Kumar. You should pass me soon.

You have to do it in a shell script. There is an example in EtlStats. The shell script is called Email.ksh. It does use uuencode.