Joined: 03 Apr 2008 Posts: 82 Location: United States
Hi All.
This is the formatting I need to do through SYNCSORT.
Input file, variable block(max 180)
rec structure:(comma separated,length within brackets)
field1(2),field2(3),field3(3),field4(3) or
field1(2),field2(3),field3(3),field4(3),field5(3)
input rec can be either of the two(not both together).
if its type 2, output file structure will be(fixed bloc,180)
KUMA/R/field2field3/D/CPfield4field5-field1
if its type 1, output file structure will be(fixed bloc,180)
KUMA/R/field2field3/D/CPfield4-field1
Joined: 03 Apr 2008 Posts: 82 Location: United States
Hi.
Input VB file as I said:
Input file, variable block(max 180)
rec structure:(comma separated,length within brackets)
field1(2),field2(3),field3(3),field4(3) or
field1(2),field2(3),field3(3),field4(3),field5(3)
input rec can be either of the two(not both together).
Sample:
CO,AAE,AMS,MRS (type1)
Or
CO,AAA,ATL,PPT,QLA (type 2)
if its type 2, output file structure will be(fixed bloc,180)
KUMA/R/field2field3/D/CPfield4field5-field1
if its type 1, output file structure will be(fixed bloc,180)
KUMA/R/field2field3/D/CPfield4-field1
Output will be:
KUMA/R/AAAATL/D/CPPPTQLA-CO (IF TYPE2)
KUMA/R/AAEAMS/S/CPMRS-CO (IF TYPE 1)
KUMA/R, /D/,/S/,CP,-CO are to be hard coded from sort card