DSXchange

Have you tried a reject link on the stage?

I did a quick test job before replying to your post, and I am also on Solaris and it did correctly return a 1 and a 0. Are you sure that your file has data in it, as the "-s" option handles non-existing and zero-length files the same way.

It is the only documented way to copy a project.

How long does it run before you get this message?

There is no need to go into the (undocumented) tables, the routine DSGetJobInfo() is documented and will return this information to you.

I suppose you could do a "dsjob -logdetail ..." and use sed to find the occurrence of the timestamp string and then look back to the nearest "Event Id: " string, but that is about all you could do from the command line. If you wish to do this in a routine you could use DSGetLogSummary() and DSGetLog...

I mentioned ODBC in my post, check that out with Lotus Notes.

Add "Execute_Command_0.$ReturnValue=0" to the 'exists' output of the execute command stage to do this. Preferably switch to using the "wait for file" activity.

no easy command line, but the good news is that there is ODBC connectivity to Lotus Notes!

I think you've got a fair idea of the advantages and disadvantages already. With V8 you get better search and metadata handling; so if y project is split you will have to take care of replication of common elements across that project boundary. 3000+ Jobs and associated objects is quite a bit and my...

Ok, that means the compile cleaned up after itself.

Do you have any PX jobs with transform stages that compile correctly? If you create a simple dummy job with a row generator -> transform -> peek stage does that compile?

You can use an external source to do this. First you need to figure out what the UNIX or Windows command will be that reads the mailbox. What mail system do you intend to read?

I'm not sure which files Ray wanted to look at, but I was looking for source or object code and would be in the ""/apps/Ascential/Projects/edw_stage/RT_BP4334.O" directory. Is there a .C or .so file in there?

The refresh of the director log turns out to be coded directly and doesn't use the UV query mechanism at all, so the indices aren't used and there is no query optimizer involved either. It basic does a SELECT... The abyssmal performance of the director with lots of objects has been an enhancement GT...

What about the ""/apps/Ascential/Projects/edw_stage/RT_BP4334.O" directory?