DSXchange

At the risk of stating the bleeding obvious, when a job's status is Finished, I'd expect it to have stopped. So can you please be a bit more explicit about what the sequence does, and in particular why it was once entered without exiting?

But of course that's also true for the cat command.

How can a file contain NULL ?

Yes. Technically.

For such is the nature of a sequential access file - you must read past every byte to get to the next byte.

Through interaction with the grid management software.

And, sure enough, the dates in the data don't match the specified format string. The solution obtains immediately from the foregoing - you have to make them match (probably by providing a correct format string). You may also have to handle the empty (null?) date fields.

... or the same as a Filter command in the Sequential File stage.

Isn't technology wonderful?

Is there a TFPM-00201 message later in your job log?

Yes, this message can be ignored (demoted, perhaps).

Another choice is to define the structure completely in metadata, and apply the Drop On Import property to all fields that you don't require to be read.

There are a number of ways in which it can work. Typically changes to the database are captured by reading the transaction log (though triggers can also be used); these changes are placed onto an MQ series queue and a Change Data stage in DataStage can read from that queue. I have no idea what kind ...

Only by creating a routine to drill down through the sequence log to sub-sequence and job logs. This is a fairly straightforward routine to write.

Yes, but not meaningfully. For example you can transliterate (specify the sound of a Japanese character using English characters, such as "東" and "京" becoming "Tō" and "kyō") but there is no one-to-one correspondence between CJK characters and English characte...

Indeed check any directory pointed to by UVTEMP (in uvconfig) and TMPDIR (environment variable). And TEMP, if that environment variable is also set.

There is a neat little trick for running simple (non-interactive) operating system commands from the project directory on the server. First open the DataStage and QualityStage Administrator client. On the Projects tab select the project (in this case it may not matter which one). Issue your UNIX com...

The reason you're not getting to level 2 and deeper is that you have not written the SQL query to perform a recursive search. This is not easy to do. I agree with Andy - why not use the inbuilt search capabilities of the client?