Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2002 @ 02:00:39 GMT

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

I want to know the usage of INDICATORS

I have table, that contains 3 columns (name, phoneNo, Location). I am loading following data using Multi load script..

Raji;;Calif
Siva;2146739991;Texas
Raju;1234567890;Sandiego

NOTE: phoneNo Colunm is NULL In first record.... and ";" is delimiter

After that i used FastExport, and exported the same table to disk in INDICATORS mode...and i deleted all rows in that table...... and again by using Multiload i loaded same data(the one which we generated from FastExport) to table with following option in mload script

.layout mylayout INDICATORS;

after that i did sel * on that row... I got following output

Siva        2146739991 Texas
Madhu       4084216142 Calif
Raju        1234567890 Sandiego
Raji                 ? Calif

My question is in PhoneNo colunm in last row, why it is showing "?" in empty column...it should show NULL right?

THANX

Reddy

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