Archives of the TeradataForum
Message Posted: Thu, 18 Jun 2009 @ 20:53:51 GMT
<-- Anonymously Posted: Thursday, June 18, 2009 15:58 -->
I am trying to see how to set the databasename and tablename in a bteq in such a way it is replaced at run time:
I know it can be done in utilities like MLOAD & EXPORT
.SET DBWORK1 TO 'AAAA' ; .SET DB_NAME TO 'BBBB'; BEGIN IMPORT MLOAD TABLES &DB_NAME..ABCXYZ WORKTABLES &DBWORK1..WT&ABCXYZ ERRORTABLES &DBERROR1..ET& ABCXYZ &DBERROR1..UV& ABCXYZ
The databasename will be replaced at runtime.
I want to do it in bteq. This way when the code is moved across different platforms (DEV/SIT/UAT/PROD) code doesn t have to change.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|