|
Archives of the TeradataForumMessage Posted: Thu, 18 Jun 2009 @ 20:53:51 GMT
<-- Anonymously Posted: Thursday, June 18, 2009 15:58 --> Hi all, 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. Please advice. Thanks.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||