Archives of the TeradataForum

Message Posted: Sun, 02 Mar 2003 @ 20:47:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sam

The answer to this couldn't be as simple as executing all the elements of your querty as an MSR, could it?

In a straightforward BTEQ using IMPORT, this would work (forgive the poor syntax - this just serves to explain the point)...

IMPORT DATA DDNAME=xxxx

Using (d1 char(10))
select a,b,c from table_x where date_fld = :d1 (date,format'yyyy-mm-dd')
;update table_y set x = {somevalue} where y = :d1
;
.QUIT
(note the MSR)

but this wouldn't...

IMPORT DATA DDNAME=xxxx

Using (d1 char(10))
select a,b,c from table_x where date_fld = :d1 (date,format'yyyy-mm-dd')
;
update table_y set x = {somevalue} where y = :d1
;
.QUIT

Only the first statement can grab the imported data value, unless you use an MSR to push the imported value into all relevant requests.

Hope this helps. If not, or if I've missed the point completely, apologies.

BRgds

James

	<Prev	Next>		<<First	<Prev	Next>	Last>>