DSXchange

DS Friends,

I have an Issue at my work.Please help me if you have the solutuion and suggestions to solve my problem

My issue is .. I have a job that process on .txt file. This file contains more tham Million records. I need to set a parameter to job to stop after processing certain number of records.. say after 70000 records.

This number of records always varis, I need to set a parameter that lets the job know to stop after processing these many number of records.

How can I achive this in Datastage.

Thanks
VKR

In the Sequential file stage, you have a property under Options "Read First Rows".

Set the value of this property to a job parameter and you should be good to go.

ddevdutt wrote:In the Sequential file stage, you have a property under Options "Read First Rows".

Set the value of this property to a job parameter and you should be good to go.

Hi,

Thanks for your response.Could you pelase tell me how can we set ReadFirstRows value as a job parameter.Please explain me.
Is it like setting value to the option in the stage itself or can we set that as a parameter.
Thanks In Advance.

VKR

Click on the small right-facing arrow-head next to the Property, Insert Job Parameter and then select New... if you need to create a new one for this.

Yes you can pass parameter to "Read First Rows" option in a sequential file property.

Insert the parameter in the value tab of "Read First Rows", example: #minrows#
where "minrows" is a parameter declared in job properties either with a default value or could be passed when prompted.

-RG