Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Feb 2003 @ 20:46:42 GMT


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


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

Why not instantiate a volatile table with the dates on it, then execute the remaining statements or macros against it - either serially or in a multi-statement request?

Bteq < myvt.from_date and thedate <
myvt.to_date
; Select * from ABC where thedate > myvt.from_date and thedate <
myvt.to_date;

.quit
EOF

If you are trying to timestamp a bunch of functions (esp when they run over the midnight boundary) - the method I use for batch systems, is that I have a init script, which logs on to the database, fetches the date, writing it into a file. When I exit the script, I load the date into a global variable and reference it throughout the remainder of my KSH scripts. ${LOADDATE}

Sam - catch me on IM for more details.



     
  <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