DSXchange

Any "hash solution" (cue Ray mentioning seven percent) would either need to be done with a Server job or a Server Shared Container in a Parallel job.

What database? For Oracle, you have CONNECT BY and I imagine other products have something similar.

Write a routine to invoke (off the top of my head) ExecSHSilent(), it won't log that information.

jwiles wrote:Transformer, for instance, can't generate rows of data out of thin air.

Actually, in a Server job it can.

If you want the syntax, you'll need to look that up yourself. Are you familiar with the concept of the "working directory"? If not, perhaps this might help. To implement, all I simply meant was this: cd /work CC -dalign -O -PIC -library=iostream -c test.cpp If the compiler is not in your P...

Why? All that matters is where you are when you run it, not where it is. Hence the notion of the "current working directory". Also, there are command line options to override where the object code is created and what it is named, use that if you insist in running this while parked in the b...

If you have an "extra" character at the end of a string, simply trim it. You can substring out one less than the length of the string or do the same with the Left() function. For the "ls -m" approach, I don't recall ever seeing it add an extra space in the delimited list, what UN...

The Sequential File stage.

Specifically: http://dsrealtime.wordpress.com/2007/12 ... -a-source/

No, by default it is created in the current working directory.

No-one can post the "correct syntax" without knowing what value you have in STATE_DESC for a failed lookup. As noted, null would be a good guess so if we're going to play the guessing game, try: IsNull(DSLink8.State_desc) for the first (failure) link Not(IsNull(DSLink8.State_desc)) for the...

As I'm sure you're aware there are a number of specialty tools that do this kind of best fit or fuzzy matching, including Quality Stage. I've interfaced to one or two in the past and really wouldn't want to have to take the "roll yer own in DataStage" road, that way leads to... madness. :w...

Yup, Google brings what seems to be the error and solution right up if you are feeling lucky.

You don't need an "EndStageName" but rather a stage name and for a Server job the stage you should point the function to is an active stage... which pretty much means a Transformer. How automatic/intelligent are you trying to make this routine? All I would suggest is a generic routine that...

I don't see anything that screams registry issue to me. You haven't addressed the concern the error message brings to the table:

Ensure that user xmeta can connect to the database xmeta on host abcd.co.uk and has create table,creat view,create index and create trigger rights.

Did you, does it?