DSXchange

Nope, just move'em. However, if they are account based, you'll need to do something to create their VOC record pointer.

Him is me.

Dude, it's the first reply you got to your problem here.

There is a Filter option in the Director that supports wildcards you can use. That or something like this in the Administrator:


This also supports wildcards.

Based on what - the job name?

It holds 'configuration' information about the job who's number is in its name. Works much like the other RT_ directories / hashed files like RT_TEMPnnn, RT_LOGnnn, RT_BPnnn etc etc.

You'd need to send the email(s) then call the Terminator, is that what you are doing?

ps. It's a Sequence job (no 'r') the Sequencer is a specific object in a Sequence job.

Please delete the other post, the one with the well thought out subject of 'datastage', before someone replies to it. Please.

Never mind, it's TFL. [sigh]

No, it's not.

Never mind the fact that your question makes absolutely no sense.

The job design that stupid Craig guy posted.

As new versions are released, they fix things that weren't working right and generally tighten up any loopholes. Hopefully without create too many new ones. This really wasn't "running fine" in the old version, you were getting away with something you never should have been able to. That :1 is a bin...

chulett wrote:You need to define what 'process it' means. That and answer Ernie's questions.

At least you answered Ernie's questions.

Here's a snippet from one of mine, should get you started. You'll need to flesh it out but this is the meat of it: # Execute via Sql*Plus capturing output $ORACLE_HOME/bin/sqlplus <user>/<pwd>@<instance> >/tmp/check$$.out <<!! @<sql_file> quit; !! # Grep for errors and set status to Good if none are...

Your DBAs would be the best resource for something like that. Or try searching the forums for 'sqlplus' to see if one has been posted. Maybe even Google would turn something up.

That can only work if the target table is partitioned and each instance loads a specific partition, I believe.

Searching for your error - XML parser error on input line - returned quite a number of matches. All say the same thing - permissions problem. For example:

http://www.dsxchange.com/viewtopic.php?t=87807