DSXchange

Now, I know that a Routine Activity in a Job sequence fails if it returns any value other than 0. True - but only if you are allowing the Sequence to 'automatically handle activities that fail'. In that case then any non-zero return value is considered a failure, be it a higher number or a value li...

Substring wont. Agreed. But if the target is a database with char field it will fill in spaces to honour the length. That's exactly what is happening. I guess converting char to varchar would be the right solution. Any thoughts? Which is exactly what I was saying. And yes, you'll need to use varcha...

Or have AutoClass do the 'file watch' and only run the job if/when it shows up.

Oh, I see... InLink.MyField = "CAB ", not InLink.MyField[2,3]. (never mind, guess you were still editing)

Question still stands - you trim this and then put it where? What kind of field?

Is that a trick question? How can a three character substring = C-A-B-space?

And if your target field is a 4 character char field, it will add the space back after you trim it.

You are looking for a SQL solution, I assume, and not a DataStage one. You haven't specified a database - Oracle?

Bring up the online help from inside Designer (Help/Help Topics) switch to the Index tab, type 'BASIC Tasks' and press enter.

No, not 'machine level language', more like pop or intermediate code. BASIC is interpreted by the various flavors of the runtime engine in place per O/S. All such transformations, derivations, etc are directly BASIC code, compiled right in with everything generated by the other objects on the canvas.

Voted 'yes' as I think it's a good idea in principal, but... something else to maintain, get out of sync and/or not get set properly by people. Especially those that don't come back and bring closure to their topic.

Upgrade. Seriously... why still running such an old version? Or I guess see if you can get your hands on this 'Axcel pack'.

Without it, if you absolutely need to run the same job multiple times simultaneously then go the copy route.

ray.wurlod wrote:But it IS a different question

Exact same question that should be in a different *forum*.

There's no 'pack' needed for multi-instance jobs... unless it was different back in the 5.x version than it is now. Yes, the help for this is in the Director help, but there should be more to it than that. No, there's no other way to run the same job multiple jobs simultaneously. Yes, you could crea...

Wouldn't be from that. 'Design time information' is basically the source, the stuff that shows up when you open the job in Designer. All you need are the executables in order to run the job - and you've obviously got that. How was the job moved to the project? The old style 'Release' process would d...

If you need help with the concept of a surrogate key in general, Google or Wikipedia is your friend. If you are thinking you can use CRC32 to generate surrogate keys, forget about it. See the linked post in the answer to your other 'crc32' post.

Welcome! :D

Short answer is - it doesn't. For a longer answer, check this recent post. For many answers, try searching the forum.