DSXchange

In Director select Schedule view, then (Ctrl-P) print the detail of all entries. You will then have a document containing what's queued with the parameter settings (though encrypted parameters will be encrypted!).

asitagrawal wrote:I cannot read ur reply as it is marked as 'Premium Content'.

For less than $1 per week you can read premium posts and bask in the contentment that you're helping to sustain this site.

777 has its own intrinsic dangers. When you get a minute review the groups to which developers belong and get them organized properly so that you can revert the permissions to 775.

These are internal names used by DataStage to identify objects in job designs. V = "view", the base job canvas is V0, the first container added is V1, the next container V2, and so on. S = "stage", the number is the ordinal number in which added to the job. P = "pin" = one end of a link. The pin num...

Welcome aboard. :D

This problem usually arises from not having write permission to a folder on the client machine, which is where the XML portion is managed. Check that you can write in the DataStage folder and its subfolders on the client machine.

Think of a hashed file as a local database table that is very fast for key-based access. The answers to all your questions should flow from that thought. Any database stage can feed a reference input link to a Transformer stage.

We need more in the way of specification. It is unusual to seek to display an interval as a timestamp; it is more usual to use hh:mm:ss with hh being permitted to exceed 24. For instance, what is your rule when the difference is more than 24 hours - how do you wish your output to appear? The essence...

Looks like a job for a Pivot stage following a Transformer stage to me.

Hash partitioning derives partitition number as: partition = Mod(hashvalue(key),@NUMPARTITIONS) hashvalue() is a function that generates an int32 result. Therefore, hash partitioning is totally dependent on the number of partitions, as I previously stated. Hashing is nothing more than a mechanism fo...

Look in your configuration file to determine which machine (fastname) is node1. Configure Oracle client software there. The shared library search path issue is not whether you can see them but whether DataStage processes can. Look at the "environment variable settings" in a job log - how is LD_LIBRA...

Hash partitioning is also totally dependent upon the number of nodes.

This prompt indicates that your SQL command is incomplete, and it's awaiting more. Append the missing trailing semi-colon to your statement and the prompt will not appear.

Both of those messages are totally clear. You have a node called node1 but there is no Oracle instance there. Configure one. The text of the second problem includes the diagnostic "the directory containing the library file is not on the library search path, or the library was compiled on a system th...

Do you take backups of your data? You should also have backup contacts for support. What if something goes catastropically wrong? Hindsight is such a perfect science! I'm sure, if you phone your local IBM office, they'd be able to put you in touch with your account rep. Suggest you're thinking about...

At a guess you have specified a field in a KEEP specification but not in the record schema for the output link. There's nothing automatic in the Modify stage - it gets its speed from its simplicity. But that means you have to do the work.