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 <
; Select * from ABC where thedate > myvt.from_date and thedate <


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: 28 Jun 2020