Archives of the TeradataForum

Message Posted: Wed, 23 Oct 2002 @ 07:43:26 GMT

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

In a batchfile try this

for %%i in (c:\*.log) do echo %%i

It will echo the name of each .log file in the c:\ catalog.

I think a modification of this does what you want. You can use it to call another batchfile, which does the actually Mload stuff that you want, now that you have the source filename:

for %%i in (c:\*.log) do call mloadstuff.bat %%i

%%i is the current file name that matches the *.log pattern. You can tweak this a little bit to show only the filename without extension, this should give you some nicer tablenames.

Hope this helps!

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