DSXchange

Hi Ray,

I tried using it but compare stage only o/p one link.

Regards,

ray.wurlod wrote:So use Compare stage, which outputs both inputs.

Hi Ray, I thought of it but change capture stage o/p only one row and I will loose my before image these are the messages from MQ series with before and after images coming in unit of work. Regards Why aren't you using one of the change detection stages (Change Capture, Difference or Compare stage)?

Hi, I need to set the soft delete flag in the dB. Data is coming as below The data is coming as Key Image 123 1234 123 1234 124 145 124 0 154 0 154 0 In above scenario 1 has no change , 2nd is delete as it has before image and after image is set to '0' The third has no after and before image i.e. by...

Gurus, We are getting below error from stored proc stage sp_NRT_activity_log,0: *** glibc detected *** double free or corruption (!prev): 0x08270d40 *** All stored proc do is insert the column in DB or check if the key is present and returns the code P for present and I for insert. We are commiting ...

Hi, We are trying to reduce the warnings...but then also every time the data i.e. message is processed thru containers it add few lines to code and we are processing like 20-30 messages every 10 seconds. Regards, Out of curiousity, what is causing the log growth? If there are a plethora of warnings ...

Hi, We have only one job which will be always running in production..its a NRT job sourcing from MQ and populating DB2. As you said log purge only occurs during during succesful completition of job .....but in our case the job log becomes too big and only time we can clear is after 12-14 days i.e. j...

Hi,

We have a always running job and job logs become huge after 2-3 days.

Requirement is to clear the job logs automatically when the job is running.

We tried to set the automatic purge log after 2 days but it did not clear out the logs if the job is running.

Regards,

Thanks a lot Ernie...we got the patch from IBM and its working as expected.

Thanks again.

Rgds,

Hi,

Its the same problem...i have now one element in o/p link put the tags are getting removed...I wanted to retain the tags as it is

Peek_333,0: INSERT:192200905USAAO2008-06-20T19:49:46.0000002008-06-30T11:27:09.000000^ ^ 1996-05-01^ ^6 ^EMPE



Regards,

Gurus, Is there a way to parse XML tag from xml message i.e. without removing the tags. <msg <othertags <insert <col>........ </insert> <insert <col>........ </insert> <insert <col>........ </insert> <insert <col>........ </insert> </other tgs></msg> I need o/p as <insert <col>........ </insert> <in...

Hi,

I'm trying to use the field function in o/p derivation of pivot stage

FIELD(ERR1,'~',1)

and its giving error, can we use field function or any other equilent to it in o/p derivation of pivot stage.

Rgds,

Pivot stage would solve this nicely But its one row the i.e key src ERR_DESC 1 ABCD ERR1: ERR2:ERR3 To convert to 1 ABCD ERR1 1 ABCB ERR2 1 ABCD ERR3 And ERR_DESC columns error are decides on run time , we do not know how many errors will be there in a row at time of processing it may be 1 0r 10. R...

Gurus, We have error table structure as below. KEY SRC_CLM_NM SEVERITY_FLG ERR_DESC We are planning to reject the error to error table for invalid data or databease rejects. The problem is we need seperate row for each data problem i.e. a row got rejected due to 3 reasons like invalid date, key not ...

Hi Gurus, I'm in middle of designing the process and confused which stage to use i.e. Join vs Merge , i can achieve the result from both the stages but we will be processing loads of data and trying to join/ merge 7-8 links with same key value. I wanted to know which of the stage will use less memor...

Hi, We have source as MQ Websphere and we need to compare the before and after image we are using the below design -----Filter----Before----- CHANGE CAPTURE ----After------- As of now it works fine but in production job will be running in real time i.e. always polling from MQ for source data. Our co...