Archives of the TeradataForum
Message Posted: Mon, 12 May 2008 @ 17:52:51 GMT
| 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.
Victor
| 
