DSXchange

Just a comment on the way we chose to implement things, Kim. No need to throw vegetables.

I think you have to use it if you have sequences. You need to abort the current sequence and notify the parent sequence that a job failed in the child sequence. Yes, you need to do the notification but we use the "WarnToLog" version instead of the Abort. The child sequence needs to notice the job f...

It helps when you let people know important things like that up front.

Try this:

Actually, one position is off by one and you need quotes: substr(input,9,2):"/":substr(input,6,2):"/":substr(input,3,2) or input[9,2]:"/":input[6,2]:"/":input[3,2] Only substring dates if you have complete confidence in their validity. ...

Didn't mean to imply that the longer answers might somehow be different... just a longer way of saying "no".

The short answer is no.

There are longer answers out there as this has been bandied about fairly recently. I'm sure a search would turn them up if I could think of an appropriate keyword or two...

You've probably found what there is - a VersionControl.pdf that covers all of the basics. There's also online help from inside the tool itself, but I think it prety much regurgitates what's in the pdf.

If you have some specific questions that don't seem to be covered there, fire away.

A question then: some of my jobs do a truncate on a given table - is it possible the DS ignores doing a truncate before inserting rows? No. It (the truncate) should also be logged, from what I recall. The only time I've seen people get in trouble with this is when multiple links write to the same O...

Just trying to find out if anyone knows what the "default poll time" is for this stage - ie, how often it checks to see if a file is there or not there. The manual shows that "poll delay time" for the function it calls (DSWaitForFile) can be overriden but the Sequencer code doesn't allow that. In th...

Can't say that I've ever seen anything like this. More details might help...

What are you doing a reference link against - Hash? ODBC? Some native DB stage?
Are you using Custom SQL in your lookups?
How are you checking for success of your lookups?

That's true and I probably should have pointed that out. I was specifically looking for the status and other bits of information from jobs that actually ran, typically looking for errors. If, as Ray mentioned, a job was branched around or for any other reason not executed, you wouldn't find it that ...

Were you ever able to use the OCI stage or is this your first time trying? Load Library errors typically mean the changes required in the "dsenv" file have not been made or are incorrect. Did you setup the appropriate $ORACLE_HOME and make changes to your Shared Library Path environment variable as ...

You are looking for the dsjob command. It is documented in the Server Job Developers Guide under Command Line Interface and has been discussed quite a bit here. Search the forum and you'll find several examples of "wrapper" scripts you should use in conjunction with it instead of executing it direct...

From what I recall (it's been awhile) reading hash files from BASIC takes two steps:

1) a READNEXT to get the Key
2) then a READ using the Key to get the data associated with that key

Seems like you may be only doing the first step. Might be prudent to post your code...

I would certainly think you can. I've done it in a routine so I assume something similar can be done in a script. Don't have time right now for a long-winded explanation, but you are on the right track... Use the equivalent of DSGetLogSummary to get the log messages from the Sequencer Job run. Loop ...