update flat file

nk_bastia · Post by **nk_bastia** » Wed Aug 19, 2009 3:49 am

I need to update flat file of 4GB without using database.

Design Structure like:

Source is Flat file
Target is flat file.
Lookup is flat file.

Please suggest.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 19, 2009 4:04 am

Update what ?

You have provided no information for others to assist in any way.

Provide your full requirement and design.

Who said you cannot use any database ?

ArndW · Post by **ArndW** » Wed Aug 19, 2009 4:21 am

Bear in mind that flat files cannot normally be "updated" in the sense of replacing line nn with another value.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 19, 2009 4:32 am

But you can simulate an update or use other mechanisms to make it happen.

ArndW · Post by **ArndW** » Wed Aug 19, 2009 4:35 am

Sainath, sure - that's what text editors and other applications do. But I think that the OP might imagine one could "update" records in a flat file via DataStage PX jobs and that won't work.

chulett · Post by **chulett** » Wed Aug 19, 2009 7:32 am

Exactly - they will need to write the changes out a new (updated) version of the flat file and then perhaps rename the new name back to the old name.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 19, 2009 6:25 pm

You can always "pretend" by using an ODBC driver for text files.

This is an excellent solution if you're billing by the hour!

(It is likely to be very slow on large files.)

dsedi · Post by **dsedi** » Thu Aug 20, 2009 4:05 pm

may be OP is asking about "File Update Mode"(Create/Append/Overwrite)