Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: M-Load for Cross-Tab table
 
From:   Wayne Moran

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016