how to find no.of records in sequntial file itself?

Answer Posted / varma

Option1: You can use wc –l <<filename>> | awk '{print $1}'
in “Execute command” stage to get the row count.

Option2:-Read the sequential file and after the stage
finishes successfully, you can get the link count using
DSGetLinkInfo(DSJ.ME,
DSJ.ME, “Yourlinkname”,DSJ.LINKROWCOUNT)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1953


how to implement scd2 in datastage 7.5 with lookup stage

5306


What is the process of killing a job in datastage?

663


Difference between server jobs & parallel jobs?

755


What is the purpose of pivot stage and types of containers in datastage

710






How do you register plug-ins?

691


Differentiate between validated and Compiled in the Datastage?

762


Define orabulk and bcp stages?

788


What are the some differences between 7.x and 8.x version of datastage?

861


Differentiate between data file and descriptor file?

701


What is the difference between account and directory options ?

718


How do you import and export the datastage jobs?

826


What are the different common services in datastage?

826


why do u need the IOS upgradation in a FC switch

1959


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1741