Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Feb 2010 @ 16:17:31 GMT

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

Subj:   Re: How to pass database name as parameter
From:   Baig, Mohammad

Dear Khan,


     .SET TARGETTABLE  TO   'my Table ';

This is exactly the way right now getting handled in our system... But this is not the dynamic way of passing parameter...

Coz the databasename is getting hard coded using .SET statement. If suppose the databasename is different in dev,sit and prod environment You have to change it in each environment to execute it..

So what I am trying to do is.. I want to pass these values which you hardcoded, through a file directly..

One way I found in MLOAD to do this is using .ACCEPT

Problem using MLOAD:

But if there are only some DML statements in the script then MLOAD is not giving any log. It will just say If the script completed successfully or not.. it won't tell how many rows affected by that DML statement.

Stats are perfect for MLOAD in case of file loading to the table as we will be using WT, UV, and ET tables, but not for DML statements.

Problem using BTEQ:

Stats are perfect with BTEQ for DML statements but the problem is don't know how to pass parameters to bteq.

I hope I am clear with my issue.. your help will be greatly appreciated.

Thanks & Regards

Mohammad Usman Baig

  <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