DSXchange

The Transformer stage itself can not pass the date to the the table; it can calculate the date as swades indicates. But to pass it to the table you will need the appropriate database stage type. You will also need that the data type of column B is compatible with Date.

When you upgrade to version 8.0 you will get the ability to open the locked job in read-only mode. Apart from that, you need to identify the other user and negotiate. I would not advocate force (Cleanup Resources) as the initial approach. From the list of locks you can determine the MAC address and ...

Welcome aboard. :D Step 1. Obtain documentation of server job. Step 2. Create parallel job that implements the same functionality. That's all there is. There is no migration tool. IBM and others will sell you consulting services to effect the migration, but it's mostly not done with tools. It's most...

Not possible.

Login in using Administrator client and as someone with Administrator privilege (dsadm or root).

There isn't, at least not in one place.

Some are documented in UniVerse manuals, some are totally undocumented.

Why not submit an enhancement request?

Get used to it. There is no Manager in version 8.0. All of the Manager functionality is subsumed into Designer (rather than just some of it, as is currently the case).

How is it possible to run job in parallel in server job?? Think about what you're asking. You want to run one thing in parallel? There are many options, but what are you trying to achieve? A job sequence can run any mix of server and parallel jobs simultaneously. A server job can execute job control...

DataStage is not a translation tool. Use a consistent mapping throughout. The other important aspect is that you use the correct map. Lacking other information, this choice is likely to be an educated guess. Think about ISO 8859-1 as a possibility.

I did not say impossible, I said unwise. Use a hex editor (for example UltraEdit or filepeek) to convince us that the delimiter characters are indeed 253. Please advise whether you have DataStage NLS enabled. If you do, then the "true" ASCII codes 248 through 255 may be being remapped to the Unicode...

Without knowing the current settings it is impossible to advise. That's why you have a DBA. Ask your DBA.

If they are Chinese-Japanese-Korean (CJK) characters are you sure you want to eliminate them? They are probably valid data. More likely you need to preserve them, would be my guess. This means that you need DataStage National Language Support (NLS) installed, configured and the appropriate character...

From Parallel Job Developer's Guide (version 7.5), Chapter 10 (Complex Flat File Stage): When used as a source, the stage allows you to read data from one of more complex flat files, including MVS datasets with QSAM and VSAM files. When used as a target, the stage allows you to write data to one or ...

Ya ls is supported. So I'm thinking... ls and put that list into a file, exit ftp, and run dos to real file line by line looking for my file name. If present do something else. This sound like a good plan? Yes, but there's a better plan. You can use UNIX utilities as well. For example you can use g...

This looks suspiciously like a job for the Pivot stage to me.