Teradata SQL parameter syntax

Question

Is there syntax which allows a parameter marker in the middle of a table name? For example, consider the queries

    sel * from t?x

and

    sel * from t?x_blah.

Both execute as

    sel * from t1

if the user inputs 1. In the first query x = 1 and in the second query x_blah = 1. I would like to modify the second query to set x = 1 and execute as

    sel * from t1_blah.

Is there a way to do this?

Thanks!

Andrew · Answer 1 · 2014-07-01T14:54:00.637

1

A question mark parameter marker can only be used for data values, not object names. So, the short answer is no.

Here's some info from Teradata:Clicky!

edited Jul 01 '14 at 14:54

answered Jul 01 '14 at 14:24

Andrew

8,445
3
28
46

score 1 · Answer 2 · answered Jul 02 '14 at 07:42

1

What's your client tool?

SQL Assistant supports parameters for object names, but there's no way to get the expected behavior (as you probably noticed).

The only solution might be using Dynamic SQL within a Stored Procedure.

answered Jul 02 '14 at 07:42

dnoeth

59,503
4
39
56

I'm using SQL Assistant but, unfortunately, I don't have create procedure privileges. – XXP Jul 02 '14 at 19:05

score 0 · Answer 3 · edited Jun 13 '18 at 11:01

0

A ? works in Teradata SQL Assistant. It will ask you to enter the parameter:

select ?x from ?y;

When you run it, SQL Assistant will ask you for the parameters x and y. If you put 10 instances of ?x in your code, SQL Assistant will only ask for x once.

edited Jun 13 '18 at 11:01

robjwilkins

5,462
5
43
59

answered Jun 13 '18 at 09:59

Peter

1

1

That's correct, but doesn't answer the original question *Is there syntax which allows a parameter marker **in the middle** of a table name?* – dnoeth Jun 13 '18 at 11:06

Teradata SQL parameter syntax

3 Answers3