Hi,
I have a requirement. I have to extract data from DB2 table which is largevarchar in DB2. the Maximum size of the field is 32K. The source data for this field is split into differect records and stored. When we extract the data, we have to concatenate them and store in a Hash File or Seq File for further Processing. Is there a way to store the data in a Hash File, since the size of the Output field will be large and dont know whether can store in a hash File or Text file.
Someone help me Please??
Cheers,
Victor
Typical Problem with Extraction
Moderators: chulett, rschirm, roy
Typical Problem with Extraction
Victor Auxilium
Hash files can store really large records. If you use dynamic files then there is a large record option when you create it. Do a search. Ray explained how to use it. You could always use a type 19 hash file which is a directory at the OS level so each record is a DOS or UNIX file. These can be huge and not really slow down Universe too much.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: