Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Apr 2005 @ 22:16:55 GMT


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


Subj:   OVERLAP function and Stored Procedure
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, April 27, 2005 18:07 -->

Does any one know if OVERLAP function can be used in a stored procedure SQL Call ?

error :

SPL1027:E(L84), Missing/Invalid SQL statement'E(3857):Cannot use value (or macro parameter) to match 'stdt'.'.


Statement:

     insert into dbname.tablename select 0,0,0,0 from dbname.tablename
     where ( (date1, date2) overlaps  (:stdt , :enddt ) )

Procedure has two in parameters

     in xstdt char(8), in xenddt char(8)
     two local variables
       stdate date;
       enddate date;
     and are cast and set to the local variables
       set stdt = cast(xstdt as date format 'yyyymmdd') ;
       set enddt = cast(xenddt as date format 'yyyymmdd') ;

Any clues ??????


Any help appreciated!

Thanx



     
  <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