Returning to setting variables. snippet from previous discussion does not work on current teradata platform.

Database
Enthusiast

Returning to setting variables. snippet from previous discussion does not work on current teradata platform.

Create volatile Table TEMP As

(

Select

'1060401' (int) startdate,

'1060431' (int) enddate

) ;

When executed get error 'Something expected between ) and ;'.

What is missing?

I want to use a script and it needs variables. The approach might satisfy the requirement, but does not work. Did it ever work?

2 REPLIES
Enthusiast

Re: Returning to setting variables. snippet from previous discussion does not work on current teradata platform.


Create volatile Table TEMP As


(


Select


'1060401' (intstartdate,


'1060431' (intenddate


)


WITH DATA


;


Teradata should start a search to find the person who has not fallen foul of this!

Senior Supporter

Re: Returning to setting variables. snippet from previous discussion does not work on current teradata platform.

you might also check dieters post on global and session parameters

http://developer.teradata.com/blog/dnoeth/2011/03/global-and-session-level-parameters-in-sql