Archives of the TeradataForum
Message Posted: Fri, 15 Sep 2006 @ 21:08:55 GMT
Hi, recently I had a trouble, making a FastExport the use a single SQL. The problem was that the statment used a Single-AMP step. And FastExport crashed.
I looked in old messsages and I found that the only possible solution were use a BTEQ Export.
But in my case, I couldn't use a BTEQ EXPORT.
So, I found this solution:
The original query:
select description from Table where field1 = ID; -----> Where ID was the UPI from the Table.
The working query:
select description from Table where field1 between ID and ID;
I hope that helps somebody...
Castelli, Emanuel Alejandro
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|