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
How to parameterize records in a File
Moderators: chulett, rschirm, roy
Re: How to prametartise records in a File
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.
Set the value of this property to a job parameter and you should be good to go.
DD
Success is right around the corner
Success is right around the corner
Re: How to prametartise records in a File
Hi,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.
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