DSXchange

Convert() is more efficient than Ereplace() for single character substitution. You can gain further efficiency by initializing a stage variable (call it svLF) to Char(10) and not providing a derivation for it for each row. This means that the Char(10) function is evaluated only once. Convert(&qu...

You can also use the AT command.

DataStage EE MVS does have the ability to call routines on the mainframe, though you do need to tell DataStage where the library, in which the routine code is, is. I do not know of any way out of the box that DataStage server edition can call mainframe routines directly. There are probably (very exp...

"=string" tells the Modify stage to use the value of an input column called string, but it can't find an input column of that name. In any case, you should not use "string" as a column name, since it's a reserved word. Look up the correct syntax for a Modify stage substitution expression and correct...

The UNIX command sort -u is the most efficient imho.

From the Administrator client select one or more contiguous commands from the history pane and click Save. You will be prompted for a name under which the paragraph will be saved. From the TCL prompt use the .S name n m command to save a contiguous set of commands from the command history stack. Use...

That set of tables is NOT the set of tables you would find in the Repository. It is the set of tables that support the DataStage Engine, found in the Engine account (not in any project, though a small number of them are also visible from projects). The Repository has four sets of tables (hashed file...

If you can't download it, get your support provider to get a copy for you.

This forum is not intended to be a substitute for "official" support functions.

Why can't you download it?

A "paragraph" is the "UniVerse" (DataStage) equivalent of a shell script. It must be executed within that environment (hence from the Administrator client).

Yes, stdout got diverted away from the client connection. I usually only use this command in a telnet session. You could build them into a "paragraph" in a telnet session, then execute tha paragraph from the Administrator client.

It's non-first-normal-form, and not in the public domain. The nearest you can get is by opening doc_tool.mdb using Microsoft Access and getting it to analyze the relationships. But this is not the same as the UniVerse Repository - what doc_tool.mdb takes 29 tables to do the UniVerse Repository does ...

Check in Director client, Options from Tools menu.

Usually that kind of message indicates that the job has been run with a maximum number of rows set on the Limits tab in Director or with a -limit option on the dsjob command. Is either of these the case here? Another possibility is that someone issued a stop request, that happened to stop the job at...

Yes.

Depending on your target, row splitter alone may suffice. The other two are irrelevant to your present requirement. A link collector may still be useful.

No. DataStage reports what DataStage did; that is, the number of rows it actually sent to Oracle. Your design is not capturing any failures so there is no way within DataStage for you to know how many records were successfully updated. If you are capturing failures (through a Reject link in a Transf...