Archives of the TeradataForum

Message Posted: Fri, 09 Jun 2005 @ 23:34:26 GMT

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

Hi,

a workaround, which we are using is:

Within a bteq-script.

     ------------------------------------------------------------------------
     .export report file=DATERANGE
     select cast( date-20 format date'YYYYMMDD')
            || cast ( date format date'YYYYYMMDD' ) ( Title '' );

     .export reset

     /* you will end up with a file with content like:  2005050120050520 */
     .import report file=DATERANGE
     .repeat 1
     using mindate (char(8))
           ,maxdate(char(8))
     select blabla
     where columndate between cast(:mindate as date format 'YYYYMMDD' )
                      and cast(:maxdate as date format 'YYYYMMDD' );

     .quit
     ------------------------------------------------------------------------

In this case you will see partition elimination.

Sorry, I dont have a TD in front of me, so there may be some syntax errors, but I hope you got the idea.

Greetings

Christian

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