DSXchange

Hi All ,

We have nearly 1000 copy books . we import all copy books manually .

Could you please provide suggestion to automate the below process.
1. Flattening
2. Schema generating from flattened table definition as below.

Sample Schema file :

record
{final_delim=end, record_delim='\n', delim=',', quote=double}
(
CNTRLNO:decimal[16,0] {packed, default=0, quote=none};
SFFXNO:int16 {binary, big_endian, default=0, quote=none};
USERID:string[64];
FILLER:string[1834];
)

Thanks in Advance,
Manoj