Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 12 May 2008 @ 17:52:51 GMT

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

Subj:   Re: How to get prompt for input variable
From:   Victor Sokovin

  Usually in Oracle we can use the & character to prompt a user for a value like " where column_name = &user_value".  

  Then it will ask for value so I need to get the same functionality with in the bteq script....  

Bteq does not prompt anybody for anything not does it accept command line variables. It must have been developed by Spartans.

Standard recommendations are:

1. pass parameters via database tables;

2. write wrapper script with $variables and parse it before you submit it to Bteq.

Check out the online archives of this Forum to find many examples.


  <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: 27 Dec 2016