DSXchange

Yes, and uv.rc is its old name - it's probably ds.rc and it's probably in a directory called something like /etc/rc2.d - that said, it's also probably a symbolic link back to the ds.rc in the sample directory. Depends how DataStage was installed.

A COBOL file definition (FD) contains "the file shown above". Therefore it's no surprise you can't import it using the file shown above. When importing a COBOL FD you must specify the start position of the "A margin" - of the level 01 item(s). What error are you getting when trying to import a COBOL...

Two environment variables, one to store the counter value, the other to store when it was last updated. If that was yesterday or earlier, reset the counter to 1. You can do this readily through a Routine activity or a before-job subroutine. Tip: store the date in YYYY-MM-DD format or DataStage inter...

Message handlers are not for job sequences: they are only for parallel jobs. You need to create explicit trigger(s) to handle the "Failure" (non-zero return value) if you are going to have the "automatically handle activities that fail" and or "log warning for activities that do not finish successfu...

Split the data using a Column Import stage then use a Pivot stage to generate your desired rows.

CDC comes at additional price. You can find out about it from your vendor or by searching the IBM website.

DataStage jobs are not stored in any readily retrievable form either. They are stored as object and configuration records in a database. At runtime these data are read and used to execute your ETL process.

Is this the em-dash or en-dash character? Or is it some other form of character? Arnd's solution is a good one if the right answer is to convert to hyphen. But what if it isn't? What if the users actually need Char(150) in the result? The fact that View Data can not handle the character should be im...

Before you even get to that you need to establish whether you can even call the mainframe DB2 stored procedure even once from DataStage running on UNIX.

If you can do it once, the rest is easy and has a number of solutions.

Memory for all tsort operators can be specified using an environment variable APT_TSORT_STRESS_BLOCKSIZE

The log gets cleared because import (when overwriting) actually clears the old job and writes the new. If you have a slow enough connection you can see this happening in the import progress display.

Version Control does not clear, but simply overwrites.

Does the Sheet1 in question have column headings COL1 and COL2 ?

Fourth time this question has been asked in the last two weeks.

Please Search before posting. It saves time for all of us.

A good place to start would be the Search option at the top of this page. The question has been answered quite recently.

Posting what you did (the precise steps) and what it was about your operation that leads you to assert your failure.

We will then be in a better position to suggest how you should add (should have added) a message handler.