RE: Query Problem

Barry — Wed, 11 Jul 2007 06:54:57 GMT

That's an invalid syntax for Teradata. You cannot code a subselect within the SET clause of the UPDATE statement. Instead, you need to create a derived table and then use the column from the derived table in your set. Something like:

update tn
from tabl_name
,( sel id as SCI
From cycle_Calendar
Where cde ='AC'
And id = (sel Min(id)
From cycle_calendar
Where cde = 'AC'
And ST_cde = -20)) dt
set id = dt.SCI

Hope that helps.

Query Problem

spsingh — Tue, 10 Jul 2007 12:56:22 GMT

update tabl_name
set
id = ( sel id as SCI
From cycle_Calendar
Where cde ='AC'
And id = (sel Min(id)
From cycle_calendar
Where cde = 'AC'
And ST_cde = -20))

When I execute this query, I get Syntax error. Expected something between '(' and 'sel'

Teradata Forums / Teradata / Training / Query Problem / Latest Posts

RE: Query Problem

Query Problem