Archives of the TeradataForum
Message Posted: Fri, 23 Dec 2005 @ 12:15:50 GMT
<-- Anonymously Posted: Thursday, December 22, 2005 16:32 -->
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)?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|