Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: How do I get values into a BTEQ script w/o an IMPORT file?
 
From:   James Grogan

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016