Archives of the TeradataForum

Message Posted: Fri, 23 Dec 2005 @ 12:15:50 GMT

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

<-- Anonymously Posted: Thursday, December 22, 2005 16:32 -->

Hello,

I am trying to add / drop partition using BTEQ / IMPORT-USING variable, Please see the SQL below

     .IMPORT REPORT FILE = .\daterange.txt ;          /*** Daterange.txt
     contains just one record [2005-12-012005-12-23]  ***/
     using (dropDate char(10), adddate char(10))
     alter table mytable modify primary index
     drop range between :DropDate and :DropDate each interval '1' day
     add  range between :AddDate  and :AddDate  each interval '1' day
     ;

      *** Growing buffer to 65473
      *** Failure 3610 Internal error: Please do not resubmit the last request.
                     Statement# 1, Info =173
      *** Total elapsed time was 12 seconds.
      *** Warning: Last request caused a problem on the DBC.
                   Do NOT resubmit the last request.

The same sql with the hard coded date values works fine in SQL Assistant...

Is this a known issue ? Does anyone have encountered this before and have any remedy (DR)?

Thanks...

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