DSXchange

Hi,

Datastage PX:
Can we use the Development/Debug stages like the peek, tail , head in Dev only or we can use them during the UAT & Production environment too.
If No, why can we not use it?

The answer to "can we use these stages" is yes. What you are really asking is "should we use these stages in a production environment" and the answer to that is not always straightforward. In most of the cases you will not want to add any non-essential overhead to a job in production so you should remove these stages from jobs when development is complete (remove in DEV, then promote). Sometimes the results are needed for further processing, for example if a head or tail value is read from the DataStage log by some other process. I haven't had this happen to me yet, but can envision it happening.
Generally it is correct to state that a debug or development type stage shouldn't be found in production.

If you go through the orchestrate manual, you may find as most of these stages inturns uses the unix Head, tail... comands.
For special cases like, capturing header or trailer records, you can use these staegs (if yor are not proficient in writing scripts in unix.)