DSXchange

Another possibility is, as mentioned, to pre-process the file in unix, though it will depend a bit on the field content. For example, if the field to be used in the lookup is the second field (I could pick the first but have conciously chosen the second to illustrate the point) and the fields in the...

Hi Nripendra, I suspect you may have posed a question that is too broad. For example, if you are trying to trim all trailing spaces from all fields where the fields are separted by perhaps a comma, possibilities exist in to do this very efficiently on the unix command line. If you are trying to trim...

Okay, so that serves me right for dipping my toe into the DSEE forum!

I hope you aren't back in Oz Ray because if you are, you posted that reply no later than 6:45 a.m.!

Such is the beauty of unix is that there are many ways to skin this cat. The csplit command will achieve the same effect, on the premise that you want the first 1/8th of the rows in the first file, the next 1/8th in the second file, etc. The computation of the number of lines can easily be achieved ...

Ray, I can't disagree as to which code is more lucid. But I would suggest there is an alternative that makes better use of Unix's capabilities (after all, dsquestion has identified that the server is Unix). The following solution is based on an awk script which, to my mind, is cleaner than having to...

I don't know whether they will work for DS 4.x, as they have only been used in anger against DS 6.x & DS 7.x, but one option for you may be to try either this thread or this one . Both threads provide DS jobs that allow different dumps of DS Director job log. The first thread (you can ignore the...

(Discusion taken off-line via private messaging to diagnose issue. Will post conclusion).

But Craig, my reply was (like my forum moniker) short and to the point

Try this thread: viewtopic.php?t=95633.

David

The routine is in the folder \Routines\Custom\JobLog. Ensure it is compiled before the job. The job will be located in (I think!) \jobs\Util\Admin.

Shout if you can't find it in there.

David

A newer zip file has been added that now contains all of the required DataStage objects (in XML format, for import via DataStage manager) to simplify getting the spreadsheet and objects in one hit. David http://home.clear.net.nz/pages/david.manley/professional/excel/schedule_profiler/images/timeline...

Clarification: the input for the spreadsheet is the file that is created by the DataStage job JobLogAnalysis, not that from JobLogDump.

(Thanks to Sunshine2323 for the comms via messages).

David

Thanks - I understand the behaviour now.

And the one character name was an accident (honest John). When I registered I got a bit ahead of myself and ended up with a single character (it was going to be djm) and of course now I'm stuck with it (and maybe the is genuinely a )!

David.

I am seeing puzzling behaviour for the forum search functionality and I am wondering whether anyone else is experiencing something similar. Forum Search (a) enter "job log" (without the quotes), select the "Search for all terms" option and invoke the search. I see no successful h...

Hmmm. Okay,
(a) which version of Excel are you using
(b) What did you use as your "reference" for the import? (I'm wondering if there is a character in the value that makes it stumble).

David.