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

Where do the datastage jobs get stored?

1208


How to read the length of word in unix?

1374


How to manage date conversion in Datastage?

1132


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2369


Can you define merge?

1115


What are the repository tables in datastage?

1301


Differentiate between datastage and datastage tx?

1045


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1738


What are the stages in datastage?

1081


root tree will find which is server job and which is parallel job?

1963


what is 'reconsideration error' and how can i respond to this error and how to debug this

2621


what are the errors,warnings in datastage

2689


how to implement scd2 in datastage 7.5 with lookup stage

5601


Differentiate between validated and Compiled in the Datastage?

1268


What is a datastage job?

1011