DSXchange

If you want the hundredths of seconds preserved simply append a decimal place character then the rightmost two characters from the original eight-character time.

There are known issues with auto-purge in versions 6.0 through 7.1 (maybe 5.2 also). Note also that the log is purged only if the job is run "successfully" (status is Finished or Finished (see log)). The only "fix" is to create the control record //PURGE.SETTINGS in each log hashed file. You can do ...

I believe murali is seeking either the RMM object or the DMNS object.

RMM = "read my mind"

DMNS = "do what I mean not what I say"

What I meant was that you should include this case in your test data. Does your routine work properly if the increment is negative? (Does it need to?) Try always to create re-usable components; in this case that suggests a second argument (milliseconds) for your function. Meaningfully named argument...

WHY is it not connecting? What error message is generated? The error messages are there you help you to diagnose causes. For example there may not be a telnet listener on the UNIX machine, or "they" may have changed the rules so that it does not use port number 23, or any number of other possbilitie...

What do you expect to get?
What do you actually get?

Your original approach is the most sound. Create a small job that runs a simple query, and detect the error information in that. You can use a Routine that inspects its log, or you can use link variables in the job itself. This is run in a job sequence that decides whether to run the main job depend...

Welcome aboard. :D Thanks for the illumination. The same is true if the database is Oracle and, I suspect, most others. For the DBA Red Brick offers a singularly useful OVERRIDE REFCHECK clause but in other databases you need to remove the FOREIGN KEY constraints to be able to truncate the table.

Execute the following commands to identify possibly corrupted storage.

I have written a server version of IsValid(). I shall post it in a couple of weeks (when I get back to DataStage work).

It is my belief (originally suggested by an Ascential technical person) that two consecutive Modify stages are slightly less efficient than a single Transformer stage.

Why does DS load other types of lookup into temporary lookup fileset? It does not load other types of lookup into a temporary Lookup File Set - this was a conceptual explanation. If you do not have an explicit Lookup File Set in your design, and you are not performing a sparse lookup, then the exte...

The other thread has "while" in the subject; this one has a comma.

DataStage TX 8.0 has been GA (generally available) for some time now, and we're getting the odd question about Hawk. It's almost time for 8.x to appear in the drop-down list of versions. Can I also suggest that 7.5 also appear? It has some version-specific features that differentiate it from the oth...

The count has been on the home page (as always) for all to see. It certainly indicates that the word has spread. What's even better is that there are more posters offering answers.