DSXchange

It is a licensing issue, but maybe an indirect one. The value is a key to the DS_LICENSE hashed file, which is used to manage licensing. That it could not be written may be operating system permissions on DS_LICENSE (it needs to be writable by all DataStage users), or it could be that your T30FILE t...

... or is used in any arithmetic operation or function.

Just specify Append as the Update Policy property value in the Data Set stage.

The xxx part of the directory name RT_SCxxx is the job number from DS_JOBS. You must emplace Local.msh into the correct directory for that job.

This error is almost certainly related to permissions, probably to group membership.

This is stating the bleeding obvious, but are there any processes? That is, are there any connected clients?

The wraparound in the column is caused by the default display width in the file dictionary. The inserted character to trigger the wraparound is not @FM, so Nick's suggestion won't work. What you need to do is to override the dictionary specification with a field qualifier - in this case FMT to overr...

First, a sequential file has no data types, it contains only text. So it can only contain a "representation" of NULL, not a true NULL. Second, a key - by definition - can not be null. Therefore, you may need to re-think your design. If these columns have documented null representations, then the Seq...

One way you can do this is with a simple parent job sequence that executes your job sequence then reports its status.

Another way is via a Routine activity that captures the "interim status" of the job sequence. Read the help on DSGetJobInfo(), particularly the DSJ.JOBINTERIMSTATUS key.

So there appears to be a need for a PEPC (predict every possible contingency) stage?

DataStage with NLS enabled only uses its own, idiosyncratic encoding of Unicode internally, and therefore every interface to the "outside world" must have an appropriate character map. Typically the UNIX maps and the Windows map (for connection to the clients) will have different names for the same ...

Where - exectly - are you setting the rows per transaction property value?

U isn't performing the query. bpaje is.

Yes it does, but does not provide instant gratification. The dsdlockd process by default only wakes every 15 minutes, and it can take two or three cycles to clean up after a defunct process - the first cycle detects the potential for a lock problem, the second cycle checks that the problem is still ...

There are thousands of pages in the manuals that describe the stages. You want all that summarized in a post on a forum? It's not going to happen. Enrol on an entry-level training class (four days), which will provide you with a starting skill set and more confidence to answer questions. Etiquette N...