Archives of the TeradataForum
Message Posted: Thu, 01 Jun 2000 @ 20:19:06 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|