DSXchange

3 stage variables: svYearValue In.DateString[1,4] svMonthValueShort FIELD('Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec',',',In.DateString[5,2]) svMonthValueLong FIELD('January,February,March,April,May,June,July,August,September,October,November,December',',',In.DateString[5,2]) Then construct yo...

What is your compile-time error message when you leave the header line in?

What error message are you seeing and is this schema used for both reading and writing?

I don't think a vertical pivot is useful here, since there are a number of lines which aren't used. I'd use a transform stage and stage variables to build up the output line from just those "keywords" which are relevant.

The structure seems to be:

{commandkeyword}": "{Freeform Value}

which would seem to be ease to parse. What are you trying to do with the values and what, given your example, would be a "different format" jill file?

Typically you would use an algorithm such as the following in a transform stage to ensure that you get a single unique number across any number of partitions in your job:

I recall that the IBM cpp compiler was single-threaded on a machine, i.e. if one person is compiling then other compile requests are queued - perhaps something similar was happening in your case.

*All* Jobs? Or just ones that have a certain stage type?

What is a "jill" file?

does this job have one or more transform stages in it? Can you "truss" the compilation process on the server?

The UVTEMP is used for DataStage (uv) internal storage. the TEMP setting is the one that applies to DataStage jobs.

even kill -9 from root won't help kill a process that isn't "listening" to signals. Are these processes waiting on a socket, i.e. try "netstat -a | grep dsrpc".

There are several ways to get into a zombie or defunct state. These usually boil down to where the process is in an uninterruptable system call and awaiting a response (i.e. communicating to a parent process). The UNIX "kill" signals are actually just interrupt requests and when a process ...

What is your OCI stage name? Has this job ever run and/or have any OCI-reading jobs run in this installation? Have you tried recompiling the job?

...Is there any other way.... Web console is not there in my client machine. Thanks, Actually, it is an explorer-based application, you just need to connect to it with the correct URL, i.e. "http://my.server.machine:9080" and use your DataStage user login and can manage sessions (assuming...