Archives of the TeradataForum

Message Posted: Fri, 01 Nov 2002 @ 17:26:13 GMT

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

Hi Reddy:

In reality, you can use a .import in the FastExport job. However, when doing this, it is intended to have one or more of your input fields referenced in the WHERE clause of your SELECT. Then, every time FastExport reads a record, it substitutes the data into your SELECT and executes it.

In other words, if you read 5 records, your SELECT is executed 5 times (once per record). This is normally done to allow for the extract of specific rows based on a variable value. Many times the data coming into FastExport identifies a specific row by its primary index.

Unlike MLoad and TPump, there is no .DML label in FastExport. All SELECT statements are executed serially based on the sequence they are coded in the script.

So, since your script has no WHERE it simply reads a record and selects all columns and rows over and over again (once per record).

Hope this helps,

Mike

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