Archives of the TeradataForum

Message Posted: Tue, 25 Feb 2014 @ 12:33:37 GMT

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

Hi ...

I'm converting a Stored Procedure from what contains multiple All Amp operations into a series of Single Amp operations.

Good progress so far, but one area remains problematic :

I receive a series of Country/Account value Pairs in through the Interface, in one long string. I then chop these up and Insert each Value Pair into a Temporary Table. ?Up until this new Single Amp change I was also de-duping the input string by ensuring that, were there to be any duplicate values in the string, I only take one of the duplicates.

Thing is, de-duping is an inherently All Amp type operation, it seems to me - no good for what I'm now doing.

The only other thought was to use a SET Table in order to avoid total duplicates, butthis only results in both of the duplicates being discarded.

Any thoughts on how to proceed ?

As a last resort I could get the invoking Java app to de-dup before Calling the Stored Procedure.

Regards

David Clough
Senior BI Database Designer
BI Competency Centre

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