DSXchange

What do you mean by "process" ?

Will the transformation logic be different based on the layout of run instance ?

Vijaydev,

Can you give some examples with pseudocode of how you expect your system to work.

Otherwise others will be just guessing and giving answers way beyond your requirement and imagination.

Can you cut and paste the sequence log. Even if your PH is almost full, waiting for hours is bit too much. Include a dummy echo statement between J1 and J2 to see when it is triggered. It will give you an indication of which activity is taking time. I guess either J1 has some post-job script or J2 u...

Are you happy to be left with any old file (with possible records) in case the new flow did not bring any row?

One possible solution in your case may not not to write to the output file directly.

Write to a temporary file and move it to expected name only if any record is written.

Already done.

ArndW wrote:Please do not double-post, particularly in the FAQ forum; before someone responds there please go and delete your post.

Doh !!

mandar84 wrote:As an alternative, try using $APT_STRING_PADCHAR enviroment variable in you Job Parameter list and set it to 0x20(space)

This is Server architecture and not PX. So no APT variables.

Infact it is to change FROM Unix TO DOS terminator.

Ray,

The main fields occur only once and 'additional attributes' occur multiple times. So it is not just wrapping the rows to columns.

Few questions to answer 1.) What is the error you receive ? 2.) Does the job run or does the dsjob itself falls over with incorrect properties? 3.) If the job runs, what is the value of this parameter from director? 4.) What happens if you set this parameter to something like blank? 5.) What happens...

Suresh,

If the conditions are constant, you can implement in transformer. But the query is to have 'variable' conditions.

If you open the job log in Director, what is the value of parameter B ? This will confirm whether the value is passed correctly to DataStage and whether it is a DS problem. I think it is a DS problem as you are using single quotes as part of the string. Rather try "AND 1 = 1" as value for B.

I am quite confused on how you arrived at each step.

Also how are you going to trap for any errors / mistakes. For example if the incoming record does not have NAME column, what must happen and how do you plan to do it?

Do to see whether value of environment variable A is available in the shell.