Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2000 @ 04:54:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sudarsan,

Do you have a fixed number of Prod_id columns? If YES, write a program to reformat the input file. On UNIX use awk, shell or whatever works for you. On MVS use whatever works for you.

     Old file                new file

     100 001 100 001 002 003
     100 002 101 001 null null
     100 003 102 001 002 null
     101 001
     102 001
     102 002

This will allow you to use M-Load.

Wayne N. Moran

	<Prev	Next>		<<First	<Prev	Next>	Last>>