DSXchange

Users are not added in WAS. The only reason for opening global security was to tell you where the user registry is: operating system, LDAP or (custom) internal user registry in Information Server. Once you have that knowledge you can add users. Then, using the web console for Information Server, you...

Use Advanced Find to perform a deep dependencies search then select the result and effect a Multi Job compile from the right-click menu.

Would this be the Distributed Transaction stage?

What does 'strong' mean in this context?

DataStage can do either and, indeed, can make the decision about which one to use using cost-based optimization.

DataStage now (8.7) has a Data Rules stage, so I guess you can say that it's now strong in Rules.

Whatever that may mean.

Do you have the job open in Designer as well as in Director? A minimized Designer, perhaps? One with a modal dialog box that doesn't have focus?

The short answer is that you must find out how the characters are encoded in the mainframe-sourced file.

The main thing you will need to fix is the ability to return more than one row from the lookup. This is a simple check box. That having been fixed you could use a Transformer stage loop. A range lookup using a Lookup stage requires both the low end and the top end of the range to be specified. Your ...

Try stopping and re-starting the agents.

Have you disabled auto-refresh in Director client? If so, refresh manually and see whether the job status values are updated.

As noted you cannot do this in the out-of-the-box rule set - you would need to make a copy of that rule set then edit the Pattern Action Language script file.

Do your own detective work. Create a small test job that only performs the inner, TimestampFromString(), function. Does that work properly? (You could check with an IsValid() function, for example. If that's OK, then check the names of the outer, HourFromTime() function. If you have that right, then...

Choose "Server Routine" from the New menu.
Add DataStage BASIC code.
Save.
Compile (within the Routine dialog).

Experiment to find out whether operational metadata (OMD) capture cascades from the controlling sequence. If not, submit an enhancement request. A check box for enabling/disabling OMD capture in individual Job activities might also be useful; one that overrides the setting from the controller.

You need first to extract the time from the timestamp using a function such as TimeFromTimestamp(). You can apply HourFromTime() to that result.