Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: ACCEPTable in Fastload / BTEQ
From:   David Wellman

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023