DSXchange

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..

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.

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.

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

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?

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.

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