Reading input from a sequential file

Mohana Krishnan · Post by **Mohana Krishnan** » Wed Mar 05, 2008 4:11 am

Hi,

I need to read the data from excel ,and the excel will be placed in our server and with the timestamp, i need to get the latest excel and update oracle table. I m using Sequential file->Transformer->OCI
Now how do i know which is the latest excel in the server..?

please help me out.

Thanks.
Mohana Krishnan

ArndW · Post by **ArndW** » Wed Mar 05, 2008 4:44 am

You will need one process to determine the correct file to use, then passing that value to the DataStage job that reads the file.
There are many ways of getting the "latest" file; it depends if you do it by date-time created/modified or by the name. This would be a single UNIX statement, i.e. "ls /test/path/TestSheet*.xls -ls | head -1"

sachin1 · Post by **sachin1** » Wed Mar 05, 2008 5:20 am

regarding date and time you will not be sure, for that purpose using logic suggested by ArndW you create one fix named file for example

testdata_20080305.xls to testdata.xls. and use this fix named file in your job and after processing the file , remove fix named file.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 05, 2008 6:08 am

So you plan to put the Excel (.xls) file on a Unix machine? Good luck!!

Or is it a text dump (.csv or .txt file) that you plan to put on the Unix machine?

In either case you can work out which is the latest by checking the date/time accessed/modified, which the ls option suggested by ArndW uses to sort the file names. That's why a head -1 command selects the most recent.

Mohana Krishnan · Post by **Mohana Krishnan** » Wed Mar 05, 2008 9:58 pm

ray.wurlod wrote:So you plan to put the Excel (.xls) file on a Unix machine? Good luck!!

Or is it a text dump (.csv or .txt file) that you plan to put on the Unix machine?

In either case you can work out whi ...

We are going o place .xls file in the unix path. I could not able to see all ur coments.

Thanks,
Mohana Krishnan

ray.wurlod · Post by **ray.wurlod** » Wed Mar 05, 2008 10:09 pm

Premium membership costs less than 30c (Rs12) per day. Among other things it will let you read the five premium posters' contributions in their entirety. All revenue from premium memberships is devoted to defraying hosting and bandwidth costs incurred by DSXchange so, by taking up premium membership, you are helping to keep DSXchange alive.

chulett · Post by **chulett** » Wed Mar 05, 2008 10:15 pm

You'd need to purchase and leverage UNIX drivers that can read Excel files. For example, an 'adapter' from someone like iWay Software. Otherwise you'll need to export the data, do a 'save as' in a sequential file format like the .txt or .cvs formats, which can be easily processed.