Hi
I need to create one job.In that I need to calculate record count of the file.
That count have to go to transformer stage.How can I create the job and calculate the count and need to send into next stage.Please give me suggestion
Sequential file(Source)------->Transformer----->........(stages)
Row count from txt file
Moderators: chulett, rschirm, roy
Rowcount
Could you please tell me where can i find filter command in sequential file stage? i am using DataStage 7.5.2
DSguru2B wrote:In the filter command of sequential file stage, put wc -l. Specify one column in the metadata. This will get your the row count of the file you specify.
Re: Rowcount
Thanks,DSguru2B.I got it.
reddy12 wrote:Could you please tell me where can i find filter command in sequential file stage? i am using DataStage 7.5.2
DSguru2B wrote:In the filter command of sequential file stage, put wc -l. Specify one column in the metadata. This will get your the row count of the file you specify.
Filter command in sequential file
Hi,
Click on the properties tab and then click on options.you can find Available properties to add box on right side.
Click on the properties tab and then click on options.you can find Available properties to add box on right side.
sshettar wrote:reddy12 , Could you please let me know where did you find the Filter command in the sequential file stage in PX