DSXchange

* * REPOSTING * *

Try something like


where pCurrentDate is the date parameter formatted in required manner.

Try something like
where pCurrentDate is the date parameter formatted in required manner.

Siva,

I had started by attempting to understand your requirement and design.

Unfortunately your response does not assist.

So will leave it to others.

Individual job - your method

Sequence - userVariables

execSH

To start with, the commands and file names in the scripts.

Second the environment variables etc

To start with, the commands and file names in the scripts.

Second the environment variables etc

Dates cannot have '' as valid value.

Set individual values for them.

Priyadarshi, It is enough to delete the .ds files alone as the child will become orphans (even though it will consume space). The point myself, Ray and ArndW are pointing is w.r.t the limited knowledge of OP and guiding through rm outside the tool may result in some other damage. Also it is possible...

I assume you land the 7 outputs into a seq file and load them in a seperate job.

Can you explain your design !!

Do they point into same stage object ?

You need to 'join' lines 85 and 86 - thus the ending 'dsetlsof' in line 85 plus 't' in 86 becomes 'dsetlsoft'.

I hope you know the commands to do it.

Looking at the line raising error, it is your PATH setting that is causing the trouble.

Maybe sometime did not enable append mode and hence the 'o' in dsetlsoft resulted in newline. Just guess.

How are you initiating the job? i.e. via shell or sequence ?

Looks more like an interview questions to me.

Best ask the interviewer about what he / she means.