Posted: Sun Dec 29, 2002 9:36 pm
One approach would be to pre-process the downloaded file to unpack the packed fields and thereby to produce a second file, which can then be processed.
DataStage can - in a separate job - do the unpacking. For example, read the entire row as a single column, isolate the various actual columns using substring or other techniques, apply appropriate Transforms (there are several in the sdk) or functions (mainly Oconv or Iconv) to the packed fields to unpack them. Run the resultant rows into a Sequential File stage to get a "regular" text file.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
DataStage can - in a separate job - do the unpacking. For example, read the entire row as a single column, isolate the various actual columns using substring or other techniques, apply appropriate Transforms (there are several in the sdk) or functions (mainly Oconv or Iconv) to the packed fields to unpack them. Run the resultant rows into a Sequential File stage to get a "regular" text file.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518