Archives of the TeradataForum
Message Posted: Tue, 25 Feb 2014 @ 12:33:37 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|