DSXchange

You can get a few tips going through the posts on this forum. I believe chucksmith has a few white papers and other tips on his website.

Vijayrc said whatever Ray said, just in different words. That is infact, one of the major differences.

chulett wrote:Of course, our friend means Len(in.Col) <=20 not 10.

yet again another rescue. I was working on a similar issue at my end and that length was 10. Somehow that number lingered in my head and hence the typo. Thanks Craig

O ok. I see now. Thanks guys.

Transformer stage. Use constraint as Len(in.Col) <=10 for your regular link and a second link (reject) use constraint Len(in.Col) > 10 and capture the records in a file.
You can abort after 1 row for the second link.
My advice, dont abort the job. Send out a notification or something.

Whos Tony ???

As advised earlier. It can be anything that is meaningful. If you want to stick with running numbers then you can even do something like export JobInstances = "1 2 3 4 5" for myInstance in $JobInstances do dsjob -run PROJECT JOBNAME.$myInstance done for five instances. You can put anything...

gsym wrote:As far as I can ascertain, the first day of the first week starts on Jan 1st of the year.

Confirm that from your BA. If thats the case, then you can use my code.

No. Dont just do it like I suggested. If there is a business requirement to it then get that and then tackle it. If its just calender days then you can do it as I suggested.

You are right. "x" is whatever you want the instance to be. 1,2,3 or sunday, monday, tuesday etc. My implication was that your complete jobname will be "JobName.1" for the first instance, "JobName.2" for second instance and so on.

Yea. I read your post after hitting the reply button on my end. But if the OP needs the week of the year going by calender date and not a business date, my way should work . For other dates, more information is needed.

No such conversion code but not hard to do it.
If going by calender weeks, you can do something like

I have one more question. The jobs are run in a UNIX script which is itself run by Autosys. Since the whole process is automated, what should be my approach to assigning values to 'x'? How do you pass the job names? Suffix the job name with the Instance value. Basically your jobname will now be "Jo...

That sleep command advice was only for your own satisfaction to see if both of them really run at the same time. IF you want to run two instances give the dsjob -run command without the -wait and -jobstatus options, one after the other. This way it will run them simultaneously one after the other an...

Did you make this particular column with that humongous derivation a nullable column? Another point, nulls arent really populated in a flat file. You will just see an empty value.