Convert Packed format to viewable format using file-aid

1 post / 0 new
Anonymous
Convert Packed format to viewable format using file-aid

I have a file which has packed data in it, need to send the data to client in viewable format.

I could figure out a way of doing this but wanted to explore other options as well.

 

I did the following.

File Aid--> Option 5 (Print) --> Option 1 (Data file) -->

Provide the following inputs (highlighted)

 

Specify Print Information:
  Print format    ===> V                   (F = Fmt;V = Vfmt;C = Char;H = Hex)
  Show            ===> FORMAT              (Format; Number; Offset; or Picture)

Specify Print Dataset or HFS Path Information:
  Dataset or path ===> 'INPUT.FILE.PACKED.FIELDS'
  Member name     ===>                     (Blank or pattern for member list)
  Volume serial   ===>

Specify Record Layout and XREF Information:
  Record layout usage      ===> S          (S = Single; X = XREF; N = None)
  Record layout dataset    ===> 'LAYOUT.LIBRARY'
  Member name              ===> LAYOUT    (Blank or pattern for member list)
  XREF dataset name        ===>
  Member name              ===>            (Blank or pattern for member list)

Specify Selection Criteria Information:    (E = Existing; T = Temporary;
  Selection criteria usage ===> N           M = Modify; Q = Quick; N = None)
  Selection dataset name   ===>
  Member name              ===>            (Blank or pattern for member list)

 

 

Press Enter to get the following screen and provide the following inputs

 

File-AID ---------------- VPRINT - JCL Specification --------------------------
COMMAND ===>

Output Format           ===> F         (P = Print; F = File)
Records to print        ===> ALL       (Number to print; ALL)

PRINT - Output Format Options:
  Page Order            ===> 1     (1 = Across then down; 2 = Down then across)
  Even page per set     ===> N     (Y = Yes; N = No)
FILE - Output Format Options:
  Dataset name          ===> 'OUTPUT.FILE'
  Disposition           ===> NEW   (NEW; SHR; MOD; OLD)
  Headers               ===> Y     (Y = Yes; N = No)

Specify Batch JCL Information:
  Sysout class          ===> *

JOB Statement Information:
  ===> //JOBCARD
  ===>
  ===> 

 

Press enter and then submit the batch job.

 

The output will be received in file OUTPUT.FILE

You can FTP the file and import in excel and share.

Sponsored Listing