Updating a record in sequential file

sathishmca · Post by **sathishmca** » Sat Oct 18, 2008 3:39 am

Hi any one can you help me that i need to update a record in sequential file.

Ex:

existing record : 1 aa
new record from source is 1 bb

Now i need to update existing record(1 aa) should be change as (1 bb).

Thanks in advance..

ArndW · Post by **ArndW** » Sat Oct 18, 2008 4:50 am

Sequential files cannot be updated like tables. In order to change a sequential file in DataStage you will need to read it and write it to another, making whatever changes you require as the data is passed through.

ray.wurlod · Post by **ray.wurlod** » Sat Oct 18, 2008 5:17 am

Sequential files can be updated like tables if you use the ODBC driver for text files with an ODBC stage. This is a particularly useful combination if you are being paid by the hour.

nsm · Post by **nsm** » Sat Oct 18, 2008 4:43 pm

the other way I can think of is write the flat file to a hash and update the hash and finally overwrite the sequential file with Hash file.

Thanks
nsm

ray.wurlod · Post by **ray.wurlod** » Sat Oct 18, 2008 4:48 pm

By "hash" I assume you mean "hashed file". Your "solution" could also be implemented using a database table, but it rather defeats the purpose expressed in the original question, does it not?

nsm · Post by **nsm** » Sun Oct 19, 2008 3:56 pm

yes..I meant hashed file.

To use a database table you need to ask somebody to create a table and what I have seen is normally DBA team doesn't create tables for this purpose and the other way I could think of is what I have given.

I know its not really updating the sequential file but solves the issue.

nsm.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 19, 2008 6:26 pm

So does using the ODBC driver for text file, with much less hassle.