DSXchange

Every Char is VarChar (if needed) within DataStage server edition.

RT_LOG40 is recoverable.

Create a new job, so that it has an empty log.

Delete any content from RT_LOG40.

Then copy the following three files from the new log to RT_LOG40.

DATA.30
OVER.30
.Type30

That's in the DS_AUDIT table.

A search of the forum will yield the column names for this table and examples of how to query it. Clearly there may be more than one modification, so date/time modified and by whom are stored as multi-valued columns.

How "odd" are the jobs? Seriously, Version Control is a good tool for promotion because of the control it allows you over the target environment (read-only, recompile, etc.) and the ability to include other folders (for scripts, etc.) in the process. Version Control for DataStage is not, however, a ...

How about a Nested Condition activity within the loop? This could check the time and make the decision either to run the job stream (outside the dark period) or to jump to the end of the loop (inside the dark period).

You are unlikely to have overloaded the hashed file, otherwise you would have received error messages indicating this fact, and you have failed to mention any. By default a hashed file can contain 2GB of data, and can be adjusted to accommodate much more. I'd be looking at the Informix end. Exactly ...

Assertion: DataStage BASIC does not have an expression evaluating function. Now that I understand the requirement, I'd suggest going out to the UNIX expr command to evaluate these expressions. Beware, however, that the expression elements have to be separated by spaces, and any operator meaningful t...

Same day where I am, but Craig's is about eight hours ahead of Manoj's.

Add a THEN clause to the OPENSEQ statement and execute WEOFSEQ therein.

Move the main loop outside the scope of the OPENSEQ statement as a result (or duplicate it within the scope of the THEN clause).

No. Depends on how many connected client sessions. One developer can have many of these. Each will have one dsapi_server process, but each can fork more than one dsapi_slave process. They should all go away once there are no connected clients. Therefore the answer to your question if there are no co...

Don't even contemplate it. This (vmdsrpos.dll) assumes a whole lot of things to be available in memory. Use dsjob instead. Or read the chapter in the developer's guide on using the DataStage API.

Search for SIGSEGV on the forum. Then try to track down which string is bigger than the permitted size.

The dsjob command does not have an option to return a list of jobs in a category. I think you've "lucked out" on this requirement.

Welcome aboard. :D Your reading has been inaccurate. It's not just not recommended, it's not possible. A running job can not change its own parameter values. You need to pre-process that file in an earlier job (or routine) to extract the values, then load those (in a job sequence) into the parameter...

I have to get the ... The obvious alternative is that you don't have to. DataStage does it anyway; it's all in the job log, primarily in events for "active stage finishing". Don't even consider capturing these data while the job is running; it will destroy your throughput. In an after job subroutin...