DSXchange

Stage types are independently versioned. That means that the OCI9 stage you use in version 7.1 of DataStage is the same OCI stage that you use in version 7.5 of DataStage. Open the stage type in the Stage Types branch of the Repository and discover that the OCI stage is at version 1.1.

Probably not. When a server job aborts it halts at that point. You can make sure that the file is not moved either by checking the "only execute on successful completion" check box where you identify the after-job subroutine in job properties, or by testing for the interim status of the job within t...

Welcome aboard. :D You can obtain training from the vendor (assuming that you are in India go first to this site ) or from some third party providers. DSXchange is a technical forum and user community. It is not (presently, at least) in the business of providing beginner-level training. We are perfe...

You're in a transformation function. That is your Routine type. I can tell because you are setting a value for Ans. In a transformation function you must use the Return() function (with a value), not the Return statement (which is used in internal subroutines in before/after subroutines). You might ...

There's no location of a hash file because there's no such thing.

It's a HASHED file.

Convert them to "".

More efficient would be to initialize a stage variable to Char(9):Char(10) and use the stage variable name as the first argument to Convert().

Open the table definition in your Repository. Choose the Layout tab. Choose the Parallel option. Right click in the background and choose Save As...

Three separate output links from a Transformer, Filter or Switch stage.

I do not have DSSetParamFile available in my Repository. Can you please advise whether this is an user-defined subroutine? If it ships with DataStage, can you please advise in which category it is to be found?

Parallel jobs do support before/after subroutines.

These are well explained in Appendix A of Parallel Job Developer's Guide

Welcome aboard.

There are several solutions, which a search will reveal.

Lots. They can be found in the readme that ships with version 7.5.2. The biggies are the six additional activities in job sequences, an SQL builder in certain database stage types, a Stored Procedure stage, an HTML report available from Designer, a file/directory common dialog with Windows 2000 look...

If you are talking about DataStage job logs, they are not stored in files at all. They are stored in database tables in the Repository for the project. Like with any database product, the structure is irrelevant to you. You can access its contents with DataStage/SQL, with the Director client, with t...

Welcome aboard.

A hash file is a tool for shaping a block of hash. It does not store anything.

You may be enquiring about a hashed file.

Its pathname is wherever you created it.