DSXchange

Resolution Fix:

dsjob -logsum -type STARTED -max <n> <project> <jobname> | tail -2 | head -1 | tr '\t' '|' | cut -d"|" -f1 | xargs dsjob -logdetail <project> <jobname> | tr '\t' ' ' | grep " = " | tr '^' ' ' >/tmp/outt

I was waiting for more than 1 hour or even more in some instances.

-type STARTED -max <n> helped a lot. It's faster now.

Thanks a lot for your help, Craig !

Yes. I would need to do it from script.

I tried both of these options but in vain.

-jobinfo does not give current parameters passed.
-lparams and -paraminfo gives only default parameters stored. Not the current prameters.

Hi I am using below command to retrieve the parameter values passed during a job run. I need to collect this information for all jobs in project across multiple servers. dsjob -logsum <project> <jobname> | grep STARTED | tail -2 | head -1 | tr '\t' '|' | cut -d"|" -f1 | xargs dsjob -logdet...

Hi I am trying to export a job as XML using command line export. I want to export with default settings. That is, Output as externalized Strings in XML tab of the Export window. This is not working when doing via command line. I always get internal stored values. Do I need to change any registry val...

Hi I am trying to export a job as XML using command line export. I want to export with default settings. That is, Output as externalized Strings in XML tab of the Export window. This is not working when doing via command line. I always get internal stored values. Do I need to change any registry val...

wfis wrote:use /xml just before the target location

It works great.

thank you very much.

Hi

I need to export jobs in xml format instead of dsx using command line dsexport.exe

Appreciate the help.

Thanks
Theena

Hi.. The column delimiter is ~ The row delimiter is unix newline character. Some columns are text columns that contains newlines as datavalue. Actually we are redesigning our server jobs to parallel jobs. Server jobs - Sequential file has "Contains terminator option" which is being used. P...

Ok..Thanks..Will try that..

Is there any other option to handle newlines in the input columns in the file data in parallel jobs....


Thank you

No..The strings are not quoted in the input...

I was able to handle it in Server jobs. The Seq. file has contains terminator option in the columns tab.

But I could not find it in Parallel jobs.


Is this option present or any other option to acheive this?

Hi

I know how to handle newlines appearing inthe column datavalues in the seq. file stages in DS Server.

How to achieve this in DS parallel jobs Seq. file stage.

Is there anyother way to handle newlines in data.

Thanks
Theena

I have a following requirement: From seq. file, I need to load another seq. file with the below conditions: 1. Input file has one column SolutionNumber. 2. With this solution number, I need to lookup on database to query 15 columns. Lookup query joins 5 or 6 tables. If lookup returns multiple data, ...

I have a following requirement: From seq. file, I need to load another seq. file with the below conditions: 1. Input file has one column SolutionNumber. 2. With this solution number, I need to lookup on database to query 15 columns. Lookup query joins 5 or 6 tables. If lookup returns multiple data, ...