Archives of the TeradataForum

Message Posted: Tue, 08 Oct 2002 @ 16:07:51 GMT

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

A checktable will report which tables are being multiloaded. Start checktable, do a "check all tables at level one;" with logging to a file turned on. At the end of the checktable it will say:

7 table(s) bypassed due to pending Fast Load.
0 table(s) bypassed due to being unhashed.
4 table(s) bypassed due to pending MultiLoad.
0 table(s) failed the check.
0 Dictionary error(s) were found.

So you know how many tables you're looking for. Then open the log file and search for the word Multiload to find each individual table. (This is all on Teradata for NT; hopefully it's similar if you're not on NT.)

--
Julie

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