DSXchange

I know, I know... I try not to think of those days... all them switches and dials, blinking lights and spinning tape reels... [shudder]

DSguru2B wrote:1984 huh. I was still carrying around a sippi cup.

So probably not even on the planet when I started. [sigh]

They didn't ask for alternatives, they asked for help with the Modify stage. :? And while I'm here - please stop using Reply with quote every single dang time you need to respond. It's annoying when done for no good reason and means I constantly have to come along behind and clean up after you. Ther...

'cat' is one simple way. (Windows equivalent would be 'type')

Can't really help but wanted you to know I've moved your post into the 'all things services related' forum.

SURA wrote:Very first run you need this file to be created. For the rest of the run you don't want.

Default behaviour when writing to a hashed file.

Sure... just type "man rmsock" from the command line or stick it into Google.

So... you want to use this stored procedure in a job or replace this stored procedure with a job?

I think that falls into the category of "pet peeve".

Create it how? Empty or populated? Typically one would do that in the same transformer to avoid this very issue, the hashed file would have both an input link and a reference link to it.

Huh... wasn't sure how that empty string would test and thought that was the issue with it (apparently) not testing as expected, so thought it would be prudent to be explicit in the assignment of the result.

I just meant you can't let the derivation resolve itself, you need to wrap it in an if-then-else and say "if BLAH_BLAH_BLAH then @TRUE else @FALSE". Do that in a well-named stage variable and now you can just put that stage variable all by itself in the constraint. As an example, name the ...

... and a good reason to have your script check the job first and issue a RESET before the RUN if needed.

For doing group change detection on a "set" of columns, I've found the easiest way to do that to concatenate them all into a single delimited field. So rather than check A and B and C you check the unique combination - "A|B|C". Does that make sense? The rest is proper maintenance...

Yikes... I had to many many (many) years ago but had to give up on getting it to work. From what little I recall, we switched over to having Notes deliver the data to an Oracle table using NotesPump and we then sourced from there. Thankfully, it was a one-way street and I never had a need to try to ...