Archives of the TeradataForum

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

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

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