All Forums Database
i5commuter 10 posts Joined 01/12
14 Feb 2012
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?
 

Jimm 298 posts Joined 09/07
14 Feb 2012

 

 

Create volatile Table TEMP As

(

Select

'1060401' (int) startdate,

'1060431' (int) enddate

)

WITH DATA

;

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

 

ulrich 816 posts Joined 09/09
14 Feb 2012

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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.