DSXchange

For each logical processing node you can configure

one or more directories for temporary storage

one or more directories for permanent storage (e.g. file sets)

The DataStage Manager manual is where the configuration file is described in detail.

Had you been on UNIX you would have had another possibility, to use tr as a filter command in your Sequential File stage.

You want to Trim the "*" characters. Or you can convert them to "". In column derivation expressions in a Transformer stage use either of the following:

Don't tell me, tell Craig! His suggestion is based on the notion that your Repository indexing may have become incorrect; there is an option in the DS.TOOLS menu for repairing those indexes.

Have you chased this alleged "known issue" through support yet?

No. There are properties in 7.x DataStage objects that are not in 6.x, so that the 6.x imported would not understand them. No-one, as far as I am aware, has created a mechanism for hacking a DSX or XML file to remove the newer release components. If you can make a business case, you could submit an ...

The SEVERITY column in the log (which is a DataStage hashed file) is a virtual column based upon an ennumerated value in the column TYPE. Type Severity 1 Info 2 Warning 3 Fatal 4 Reject 5 Started 6 Reset 7 Error 8 Debug In theory, you could use an UPDATE statement to change TYPE from 1 to 2 (or even...

What stage type are you using?

The answer is different depending on whether it's an ORAOCI stage (which one?) or an ODBC stage.

Kim means the "correct" quote character. Alas, despite ODBC being a standard, different databases specify different quote characters. The ODBC standard - a Microsoft-published standard - specifies the double quote character (") for delimited identifiers. But MS Access (a Microsoft product) uses a ba...

The uvbackup utility is no better than regular UNIX backups for PX, because there's no internal "UniVerse" structure in the generated PX objects. For quick help, get to a TCL prompt on the server, and execute the command HELP uvbackup (there are lots of options, and the command is in lower case even...

Who knows? DataStage clients are a complex inter-relationship of executables, libraries, ActiveX controls and all kinds of other stuff. Like most Windows software! Version 7.x of DataStage is built on a .NET framework, and is thus slightly different. So, if by "solve" you simply mean that the proble...

I vaguely recall that was a known problem with some 5.x releases. Contact your support provider to follow it up with Ascential.

Might even be worth a search here, particularly in the Oliver archive.

@OUTROWNUM numbers the rows leaving a Transformer on an output link. When the keys form an unbroken integer sequence, the dynamic hashed file SEQ.NUM hashing algorithm is far more efficient than the default, GENERAL, hashing algorithm. Every UniVerse table is physically a hashed file. So, when you c...

Support may have asked you to do this already. To find out where the hang is, enable server-side tracing (either from the Administrator client or from the DS.TOOLS menu on the server). Next, open a Designer. You will get a warning that server side tracing is enabled. Open a job that contains a Trans...

Use a UV stage to access your hashed file!

The UV stage, too, supports multiple row returns from reference lookups.