Typical Problem with Extraction

asvictor · Post by **asvictor** » Fri Jul 09, 2004 2:37 am

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

kduke · Post by **kduke** » Fri Jul 09, 2004 6:26 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 09, 2004 4:55 pm

Can you not set the metadata definition to VarChar with a precision of 32000?