DSXchange

Lower it. That value is high enough to not even make any sense, I'm afraid.

Brand new... on what version of Windows?

I would get rid of the Nested Condition and do two things: first link a RANOK trigger to a Sequencer, that gives you your graceful end of the line with an option to even log that fact, should you so desire. Then run an Otherwise trigger from the JA to the NA stage which will catch everything else.

You can use DSGetProjectList() to get a list of Projects on the server.

Does it need to be a 'server routine'? Doing this at the command line via a shell script would be another possibility. Get a list of projects, iterate through the list and then get a list of jobs from each project. then iterate through that list to get their most recent start/end times. All via opti...

Stage variables in a transformer is the first thing that comes to mind. Or the use of the MOD() function. Of course, running this on multiple nodes could complicate the solution, depending on how that needed to be handled.

Knowing where you 'ran the query' will make a difference. Anything other than sqlplus will format the date for you... assuming this is a DATE and not a VARCHAR2 or CHAR field. Absent of any formatting by you in the select, sqlplus will just use the default NLS_DATE_FORMAT. And again if they are DATE...

At this point, I'm a little lost as to what your actual question / issue is. Do you need help creating the first 'audit job' that inserts the record? Or are you looking for help with the second part where the current record is updated? Or do you need help with both? I'd also be curious what you've t...

In Kim's signature line on all of his posts there is a link to his website... it's all there.

COALESCE isn't really appropriate in this scenario, more like NVL or ISNULL in a CASE statement. OK... you would normally use coalesce() with a series of columns to return the first non-null value. In pondering this, are we also saying it can be used with column and a fixed value? Say: COALESCE(MyCo...

FYI - if you did actually have spaces in the filename and need to use a wildcard, assuming I recall my "long file names" rules you should be able to do something like this:

$ D:/IBM/InformationServer/Server/PXEngine/bin/orchadmin rm "D:/rldm psdw/rldm/dataset/"*.ds

Try it without the quotes around the dataset name. Those are only needed when the pathname includes spaces and they are masking the wildcard.

chandra.shekhar@tcs.com wrote:Can you tell me what's an OP ?

Original Poster.

Yah... or that.

Since it shows "Multi Instance Job: N" in the log, I'd guess that the second invocation id isn't being passed and you're actually running the 'base' job. Hard to say for certain since you edited the log before posting it here.