DSXchange

Indeed you must create your range map with this stage type, in a separate job prior to running the job that will use range partitioning.

In the Administrator client Command window or in TCL on the server or via a UV stage in a job execute the following command: SELECT NAME FMT '50L',CATEGORY FMT '25L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY CATEGORY, NAME; You can adjust the FMT widths to suit. If using a UV stage (connected ...

There are example routines supplied with DataStage that show how to do this. Take a look at them.

What exact version of DataStage are you using?

You're on the right track. Once you detect that a source record has been deleted (and there's lots of ways to do that), simply update the "active" indicator in the Data Warehouse.

Turns out some man pages had been removed, to "save disk space".

readCommFifo() is the function that reads the pipe through which the FTP'd data are streamed into your job design. Either something has gone wrong with that routine, or there is something wrong with (the syntax of?) the FTP command (as passed to the operator) itself.

There is at least a logical inconsistency between the records in DS_JOBOBJECTS, in particular in the record J\326\V0S101P3, which is a "pin" record (one end of a link). It is missing some information that it should have. It is unlikely that this is physical corruption. Can you try saving the job wit...

You can first promote the two subrecords using Promote Subrecords stage.

Not without substantially more information. What is the job design? What is it meant to do? What do you mean by "under monitoring"? Which stage is generating the error message?

But not in the man pages.

Thank you for the link.

ETL mapping document should be prepared by business analyst. It is a simple table containing five or six columns: Target Table Target Column Derivation Source Table(s) Source Column(s) Explanatory Notes As to your other questions, the only safe answers are "how long is a piece of string?", or "it de...

I suspect it's more to do with not having to spend lots of non-billable time re-creating what's been destroyed.

What document did you check? Try the Orchestrate User's Guide for full details.

When I did a man iconv on my Linux server it professed ignorance. Does this command come with UNIX or is it something you built yourself?

There's none of which I'm aware. You can, of course, create a custom stage, or perhaps use an External Source stage to execute a command to have Tivoli dump the information when it's required.