DSXchange

This shows some interesting support issues.

Through which plug-in stage are you attempting to import the table definition?

Try using the Orchestrate orchdbutil utility - it's more robust.

Try \x1F

... but that's closer to Oracle's SOUNDEX than to Oracle's LIKE

You need Upcase() function to achieve case-insensitivity and Matches operator to effect comparisons including wildcards. Sample:

That, sir, was a terrible thing to say!!!


(I know of no such plan.)

Specification: OutputColumn = handle_null(InputColumn, newvalue)
Specification: NOWARN

OK, here's what happened. The company that hosts DSXchange re-imaged the operating system on the server and, whatever it is they did, no email is now leaving the server. Whether from DSXchange or from DCS Strategies. This has impacted DCS Strategies' business, so stern words have been had with the h...

But you can access with new Manager/Designer connections?

Can you access project properties with Administrator?

It can't be fixed, it wasn't broken. It's working as documented.
Page 239 of Parallel Job Developer's Guide version 8.0 says DB2 and Oracle only.

Use a UV stage with a single Integer column whose Derivation is COUNT(*). Table name is the name of your hashed file (you may need to create a VOC pointer). The Selection tab contains your WHERE clause. Voila!

8,388,608

Source: HELP CREATE.FILE command issued at TCL prompt

Given that the Master Scheduler appears to be outside of DataStage you will need to code something to get the values out of the DSParams file. Alternatively, you could construct a job sequence that the Master Scheduler executes without passing any parameters, and the job sequence can much more easil...

Looks like "they" will have to let you write to the C: drive, then!

Ultimately any, because you can run any executable from the operating system command line. But callable is another question. DataStage is not one product, it is three - or four, depending on how you count. So, for example. the mainframe edition generates COBOL so can readily call COBOL functions, bu...