DSXchange

Welcome aboard.

It's not clear what your problem is.

Can you not place an OCI stage into the design?

Or, if you can, and the job compiles, runs and throws an error, what precisely is this error (details copy/pasted from the Director please)?

Of course. Don't automatically handle activities that fail. That alone will prevent the controlling sequence from aborting.

OK, ignoring the small minutes and seconds discrepancy, that's a 13 hour difference. Can you open the Administrator client command window and execute the command DATE (which will give the date and time from the server system from a DataStage perspective) and the command SH -c date (which will give t...

Reset can only be had from a controlling sequence. If you build a controlling sequence that does not abort, then it could run your master sequence as "reset if required, then run". That could well be the only job activity (or activity of any kind) in the controlling sequence.

What times are being displayed?
In Director are you showing the server time in the status bar?
(Tools > Options > View > Date and Time)

I'd try just replacing the column metadata first (delete and load). If that doesn't work, try replacing the stage.

OK, another little idiosyncracy that might be biting you is that you have to mark each phase as reviewed (whether or not that's true) before the product will allow you to move on.

I can't check 8.1.1 just yet - hope to have one installed next week.

Possibly yes, as mentioned in my post.

Premium membership is not expensive, at less than 30c (Rs12) per day. It is one of the ways that the hosting and bandwidth costs incurred by DSXchange are defrayed.

Check which SQL was actually used at runtime. When you switch to generated SQL the user-defined SQL is not discarded but remains a link property. Under some circumstances (not sure exactly what they are) DataStage can use the stored user-defined SQL. The workaround, if that is happening, is to repla...

Using Web Console for Information Server log in with suite administrator rights, choose the Administration tab, Users and Groups, Users. From the list of users select the user to be deleted (check the check box) and choose Delete from the tasks menu on the right hand side. Answer "Yes" to ...

Logging is more complex, because DataStage logs (where RTLogging/ORLogging direct logging to XMETA) fit into the more generic logging structure of Information Analyzer. That, in turn, is why the default logging view in Web Console for Information Server only lets you see the entirety of logged event...

Simplistic answer is that things that need to be sharable are in XMETA, things that don't need to be sharable are kept within individual products. Thus, for example, the data analyzed by Information Analyzer are kept in the IADB but the analysis results are kept in XMETA. Because nearly all design c...

Sparse lookups are notoriously slow (compared to other methods) because of the overheads involved (separate single-row queries against the database server, possibly exacerbated by network latency issues). Have you considered using a Join stage? Another possiblity is loading all the keys into a tempo...

Welcome aboard.

I believe you need also to have completed Table Analysis before these analyses become available.

It's not that kind of vector. It's a structure that might be produced or consumed by a COBOL file definition containing a single field that OCCURS multiple times. Both fixed-count (OCCURS N TIMES) and variable-count (OCCURS MAX N TIMES DEPENDING ON fieldname ) vectors are supported, though there are...