Archives of the TeradataForum
Message Posted: Fri, 02 Dec 2005 @ 16:01:57 GMT
| Subj: | | Re: Using Variable in bteq |
| |
| From: | | thomas.buehlmann |
I do not believe this is possible, i.e. one of those things I would have wished for many times. In my personal opinion this is one of the
shortcomings of the tool, i.e., making bteq scripts inherently not migratable or difficult to migrate across environmets. Something to keep in
mind when embarking on the bteq train.
The best workaround I have seen is to use a wrapper shell script that either does a search/replace of well known variables (possible if you
have a well dfined set of variables that need replacing) or end up with a here-doc in Unix, where the environment does the variable
substitution.
In either case you have to be careful to think about possible side-effects to ensure that the variables and the variables only are
replaced.
-tb
| 
