Archives of the TeradataForum

Message Posted: Fri, 21 Oct 2005 @ 14:55:02 GMT

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

The only reason someone might use an INMOD with FastExport would be when input was needed to determine which data to SELECT for the export. Then it would only be needed if the data came from a source that FastExport could not read directly - like ORACLE. Plus, even if it was ORACLE or as small as MS Access, one could use OLE DB as the AXSMOD and not be required to write an INMOD. Whatever floats your boat.

Even if you need input to substitute dynamically into the SELECT(s), depending on the amount needed, the .ACCEPT option is really good because then you can even substitute into the SELECT the name of the table and/or columns the SELECT should use. It is a very powerful tool indeed.

Now for the second part of your question: the INMOD simply reads the media it was written to access. The INMOD is called by FastExport, not the other way around. As the INMOD reads data and passes it to FastExport and it is incorporated into the SELECT and it is executed once per input record. The resulting data is all put into SPOOL until there is no more input data and the output from the SELECT(s) is put into blocks and sent back to the client.

Hope this helps you understand. Most of the time, there is no input to FastExport but it is good to have options.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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