Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to read multiple files at different directories using a
single Sequential File stage in DS Enterprise Edition

Answer Posted / venkata ramana

To read given number of files, one can use follow below

In the sequential file stage, Use
Read Method =File Pattern
File Pattern=`ls /* | head -<Number of files to be read>`

For example, I had 5 files, with similar pattern (as
date*.txt), in working folder say "/data/working/". If we
want to read three files out of these five files, one can
use following command:
`ls /data/working/date*.txt | head -3`

Just modified Venkat's Answer based on tested job.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is "fatal error/rdbms code 3996" error?

1187


How many types of sorting methods are available in datastage?

1020


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2175


why do u need the IOS upgradation in a FC switch

2221


What is ds designer?

1030


How do y read Sequential file from job control?

15789


how to add a new records into source?

1934


What is ibm datastage?

914


Define Data Stage?

1037


Where do you see different stages in the designer?

1034


What are the different options associated with dsjob command?

1370


How many types of views are there in a datastage director?

1230


What is quality stage?

937


how to export or import the jobs in .ISX file

1132


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2549