DSXchange

True... not sure why I went down the script path, but either is valid and would use the same techniques with the caveat Ray mentioned for the job approach.

"Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small." First suggestion would be to look for this situation, find out where you are...

Just build them together as one line, formatting like that is just for peoples and will not affect any XML parser. If for some reason you really think you need to do this, concatenate a <CR> between the two elements:

Or just simplify the triggers. Does your routine actually ever return a negative number? Do you need to handle a zero differently than a non-zero response? Seems like the answer is no if all of these links feed into an ANY sequencer. Use two triggers and let me know what happens: Link 1 - OK (Condit...

No, but if you told us about the problem you were trying to solve by this, perhaps a better approach could be proposed.

Odd... so 'netstat' is hanging on that server? I would bring that to the attention of your Admins, if you haven't already.

This can happen, typically when using the 'Delete every run' option. Something happens, the delete/recreate silently goes awry and you lose the hidden .Type30 file in the directory that tells it it is a dynamic hashed file. It then defaults back to a Type 1 (19?) where every record becomes a separat...

And how exactly would one call the routine in the Execute Command stage? That's the question. Routine Activity stage, sure, that's what it is there for but there really isn't any approved mechanism to run server routines from the operating system that I recall seeing. I think Ray or Kim may have pos...

You were doing fine up until that last little bit. Getting the first part is easy and a simple script can get a list of the job names in a project then iterate through them to check and record the status of each. All that using 'dsjob'. Write the results out to a flat file and then either load it to...

Funny, but I don't really think "ETL" when I see "SAS" but hitting their website reveals that it is one of their offerings: SAS Enterprise Data Integration Server is what I assume you are referring to, yes? And there is an "Enhancement Wish List" forum which I've been t...

I don't believe so, from what I recall of the documentation either are valid with the difference that I noted above.

Why not first load the keys into a work table and then join them to your source table in the DB2 stage?

If it is disabled, you should be able to go to the Administrator, select that Project and enable the option that is something like (off the top of my head) 'Enable job cleanup from Director'.

You need to either fully path it, add the DataStage "bin" directory to your PATH or (as noted) run it from where it lives.