DSXchange

Great.

FMT will get you what you need for #2. For #3 I'd just define a seperate single character field in front of the numeric field and if-then-else a space or a '+' into it. Rule #4 seems to violate Rule #1, but if that's really what you need simply making the field a CHAR datatype will get you 'left ali...

Hmmm... call the script in the Filter? Nope, didn't try that. Off we go.

Does the darn Filter command in the Sequential stage not support wildcards? I need to process an unknown number of files in a directory using a wildcard pattern. Yes, all have the same metadata and there's no header row to worry about. Rather than use a Folder stage with its potential size issues or...

... and makes maintenance a PITA.

ArndW wrote:Even if you know UV and C and have done it before you will spend an inordinate amount of time to get it working. Still interested?

Never really was in the first place... one thing I don't have a plethora of time for this.

Thanks for all your help with this.

Thanks for taking a look at it, guys. Once I tumbled across the 'encryted then encoded' bit, I figured I was pretty well screwed for a full BASIC implementation. Can you expand a little on your GCI comment? This could be new territorty for me, depending on exactly what that turns into and what exact...

Thanks, what I have is on its way.

A couple of different ways... If you are loading them seperately, parents first in one job and then children in the next and you are hashing up the parent keys - a miss on the parent hash would indicate the child would generate the error if sent to the database. Use that information to logically rej...

Check again, there must be a mismatch between the number of columns defined in the stage and the number of parameter markers used in your User Defined SQL, that's what generates this error.

Well, dang. The plot thickens... turns out this isn't just Base64 encoding they are doing, the key values are first run through an 'MD5 encryption' algorithm and that result is returned as a Base64 encoded string. So, unless I can somehow end up with routine code to do both, I'm SOL. We see two alte...

Yes - display format.

I'm just parroting what I'm reading on the web. I think it's just six bits because 2^6 = 64 and the other two bits are always treated as zero. Where did I see that?... one sec...here for one.

Thanks Arnd. No, no math, I need to emulate something written in Java that concatenates certain key fields in a data stream and encodes it to create what they call a 'munge key' - a unique and replicatable identifier string for those key fields. The resulting string is passed out along with everythi...

I've been asked to see about the possibility of creating a DS routine to do Base64 encoding. Now, right off the bat be it known that I've never claimed to be a math prodigy but I know a few hang out here and was wondering if I could get any help. I've googled up the basics - converting sets of three...

Please don't hijack other people's posts. If you've got a question to ask, start a new post. Also read what the OP is asking - nothing about upgrading without reinstalling or having a new or expired serial number. At this point you are just guessing why they are asking about removing license keys, ...