Archives of the TeradataForum

Message Posted: Thu, 01 Jun 2000 @ 20:19:06 GMT

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

Hi Howard,

How're you doing? Ok I hope.

Sorry, but only Multiload, FastExport and Tpump have an ACCEPT command as part of the script language.

Closest you'll come to that functionality with Fastload and Bteq is;

- Fastload: (as you're an MVS site) use the Database statement to allow your script to point to different databases. This does however mean that your error tables will be in the same database as the target table (which may not be exactly what you want). The Database statement can be in a seperate PDS member which is concatenated between the logon statement and the main script (there's no ".RUN" command either).

- Bteq: something similar, use a Database statement to set your default database for the script and never hard-code database names in your scripts (except perhaps for DBC).

Outside of the products themselves, you could use a TSO clist or REXX exec to 'pre-process' the script and substitute in the required values - same functionality as many sites do running from UNIX.

Cheers,

Dave

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