Archives of the TeradataForum

Message Posted: Fri, 15 Sep 2006 @ 21:08:55 GMT

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

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

Bye

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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