DSXchange

Out of a sense of morbid curiousity, the same kind that causes people to slow down and look a little closer at a messy accident, why are you going through all this who-ha when (as noted) a simple button push will accomplish the same thing for you?

Nope, it wasn't missed and has got nothing to do with a lack of grants - Arnd noted the problem: The UNLOCK is not a command in the DataStage projects, it is only found in the master UV account. By default, the 'UNLOCK' verb only works when logged into the UV account, not any of the project accounts...

Huh... good to know it's so darn smart. I usually stick with the explicit codes. In any case, the answer that it is just "too complicated" to contemplate is the wrong answer - it's really not and this (meaning date manipulation and math) are fundamental DataStage ETL 'stuffs', something everyone nee...

I posted something in the past on the issue - I don't recall the exact character, seems to me to have been a single quote or comma rather than a pipe. What I see in 7.0.1 is you put in a long filter command, close the stage and reopen it and the command has been truncated at the offending character....

Ok... cool. Let me see if I can turn up the magic polynomial.

As always, thanks for your help with all this Arnd.

Well... bad word, bad word, bad word. So, my only option here is to pitch my stuff and somehow switch to the same Java class 'they' are using? Great. In that case, I might as well revisit the original methodology that got me to this mess - MD5 Encryption. Farg. Any pointers on where to read about 't...

The 'M' in 'DMY' is for a numeric month. You should be able to try a couple of difference things off the top of my head... Try "DDMBY2" as 'MB' is the abbreviated month name. Or just a "D2" all by itself, as the default format of 'D' is 'DD-MON-YYYY' and the two at the end tells it a two digit year....

The goal is not to be portable, per se. This is all part of a larger processes where two disparate processes need to apply this same algorithm to a matching set of data - and get the same answer. My end is the ETL / BASIC end and the other end is written in Java. If we can't "come to terms" and - fo...

Maybe then a trip down the Ascential Support yellow brick road is in order? Perhaps the Wizard will be able to help us?

Specifically, home grown routines / scripts and a freeware piece of software called blat would do the trick on Windows.

Thanks for looking at this, Arnd. So, is the implication that a common 32-bit polynomial seed could possibly get us the same results?

Now the job is trying to update nearly 20 millon records, it aborted because of following error 'snapshot too old: rollback segment number 2 with name "RBS_1" too small'. I asked DBA, he told me that is because I tried to select and upate the same table. That is contributing to the problem, but it'...

Woohoo indeed. Got the auditors off my ass.

I just had to do something very similar to this for the SOX auditors making the rounds. Sourcing from two of the 'special' hashed files that make a VERSION project a Version Control project got me what I needed - APM_BATCH and APM_VERSION to be exact. Imported the metadata, poked around for awhile a...

Recently went through a bit of pain (with some help from my friends) to get a routine working that takes a string, chunks it up, CRC32's each chunk and then does an "MX" conversion of each CRC32 value to hex. The hex values are concatenated together to form a UID of sorts. In testing methodologies '...