DSXchange

CLOPES wrote:Can i change a default value directly in the job or change it in the isx or build a routine to change it using a script shell ?

The first two are 'yes' but what do you have in mind for this script?

Off the top of my head, Mod() the record number by 9 and then use three sets of three values for the constraints: 1,2,3 to first file; 4,5,6 to the second and 7,8,0 to the third.

Me, I'd use Mod() to control the constraint.

Where exactly are these in the stage - in the body of the stage or before/after? I'd also be curious how many update statements will be generating these million updates. However, rather than sitting here and trying to puzzle out exactly what it is you are doing, we can probably just cut straight to ...

Each will promote any number of messages with the id you specify.

Ah... you never followed up your post on this issue in the Site forum. It's only been two days, as noted it is a manual process and you'll need to be a little bit more patient I'm afraid.

We used -jobinfo to do both. If my experience, if it throws an ERROR the job didn't exist. No ERROR, then look in the same output to see if it was RUNNING or FAILED and branch accordingly. Thinking about this not sure we ever had a situation where the job was not compiled... but if there was, I for ...

Can you be a wee bit more specific about what "there are multiple update statements" means exactly?

Whenever records pass along a reject link an alert (warning) is generated. You cannot change this. Seems to me what they are saying is that is the behavior they are looking for, however it is not generating the warnings. Not sure why that would be the case... unless it is something ODBC related. Wh...

manok87 wrote:we have a parallel job which reads from a oracle table does some transformation and again does a INSERT/UPDATE in the same table.

Emphasis mine.

I don't have much if any spare time at the moment. Hopefully you've been working on this, pondering / testing / something and not simply waiting for me... right?

Glad you found it. And yes, it can be frustrating when there are multiple problems and all you are alerted to is the first one.

Sam Ting.

Plenty of other posts in this forum with similar problems, so the suggestions in them may be something you should try... basically whom to contact. Question - how long ago was your payment made? Literally a month ago? Shouldn't take anyway near that long even though it is (as far as I know) still a ...

The Sequential File stage? Yes, the Filter is "pure UNIX" on a UNIX system and what you need is whatever command that will cause only the records you want to read to be sent to standard out... so perhaps grep in your case. Your other option, of course, is to read them all and then constrai...