Archives of the TeradataForum

Message Posted: Mon, 30 May 2005 @ 10:01:32 GMT

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

The supplied sample data does not match the supplied definition. Either fix the data, or fix the definition.

Also SESSION should be SESSIONS

     A Sample Text File.....Data.txt
     Text File: (sample)

     |a2 |b3 |c3 |d1 |9
     |a4 |b3 |c3 |d1 |9
     |a4 |b3 |c4 |d2 |9
     |a3 |b1 |c2 |d1 |3
     |a2 |b1 |c4 |d2 |2
     |a3 |b1 |c2 |d2 |8

     0011 define delim0(char(1)), A(char(2)),
                 delim1(char(1)), B(char(2)),
                 delim2(char(1)), C(char(2)),
                 delim3(char(1)), D(char(2)),
                 delim4(char(1)), M(char(2)),
                 newlinechar(char(1))

          file = Dataset.txt;

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