DSXchange

kduke wrote:He has no life like the rest of the top posters.

ArndW wrote:For me the TCL has always denoted "The Command Line" but I am sure that the "T" letter has some more official meaning.

Actually, they all do. Terminal Control Language.

Just put the number that represents the ASCII value of your delimiter on the Format tab when it's not a printable character. In this case use 009 which is the TAB character.

My question is ,The output of the routine was in row by row format so can i use LF as new line character(as a delimiter). Nope. Your sequential file has that as a delimiter but an array doesn't. I'm not sure an array will work in this situation, with these 'Loop' stages. You could try setting it to...

Possibly - but it would be LinkName.NOTFOUND instead.

As noted, only equal comparisons work in a Hash lookup. You check for 'not equal' by looking for the failure of your equal check. Typically. There will be an Output Link boolean variable called NOTFOUND that will be TRUE or you can check to see if your key value is null after the lookup - hash misse...

Yes, it can be as simple as using the two stages you mention. You might want to let us know what exactly you've tried, what doesn't seem to be working and whatever error messages you've gotten so far. As to the log, there's nothing special created elsewhere by the stage - just the normal job run inf...

You need to understand that hash files do not support duplicate key combinations and resolve all differences via Destructive Overwrite. This means that the last version of the key written to the hash is the winner and the one that you'll pull out later. Resort your data such that the desired 'first'...

Doh! Lost track of where I was... didn't realize we were talking parallel.

Hmmm... in 7.0.1 'ToolVersion' is also 4. Perhaps it will be 'ok' as long as nothing specific to 7.5 is used.

Welcome aboard Adriano. Probably the simplest answer is 'no'. You may be able to get away with it on simple jobs or routines, ones that you know don't use any functionality specific to 7.5, but... components are automatically upgraded during import, not sure what would happen if it thought they need...

The category information you get back should be what you are calling the "full category information" - i.e. all levels.

Once it clicks that you can do it, you'll never go back. It becomes useful in all kinds of situations. Equivalent to the "If @INROWNUM = 1" approach without the extra overhead of the check and assignment on each row.

Rather than Export (which is a function of the Manager) do you really mean Promote from Version Control? So, you are trying to promote a version of a job back into development? Shouldn't normally be a problem. Usually the only thing people forget is to uncheck the 'Read Only' option. Biggest questio...

True - for the kind of messages that escape your checks and actually get logged. The primary focus of the question, however, was logical rejects under the control of the job... the kind of stuff that (typically) never makes it into a log. A combination of techniques could be used to cover all the ba...