Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  

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'.'.


     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!


  <Prev Next>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023