DSXchange

The DEBUG statement really relates to UniVerse rather than to DataStage. It causes execution to be transferred to the source code debugger for UniVerse (the name of the debugger is RAID) and hand manual control to you. Unfortunately, DataStage routines are invoked from DataStage jobs, which run as b...

A lot of critical information, such as locks and semaphores, are maintained in shared memory. Failing over memory contents is impossible AFAIK.

In both the quote character and delimiter character fields you can use the three digit decimal ASCII code value of the required character. For example, to use Tab as the delimiter, specify 009 . If NLS is enabled you can also use the four digit hexadecimal Unicode code value of the required characte...

The absolutely fastest way is to add zero to the number.

DataStage arithmetic always returns the shortest possible string.

This will also remove trailing zeroes after the decimal point, which was an unstated part of your requirement but indicated in one of your examples.

Did you mark the parameter value with # characters using ExecDOS? In the Input Value field you need something like this:

Welcome aboard. If any of your routines executes a call to DSLogFatal() or an ABORT statement that will cause the abort condition to occur. If a before/after subroutine sets its ErrorCode argument to a non-zero value the job will also be stopped. In your case, none of these applies. The error messag...

If you look in the status bar you will see the word Filtered . You can open the Filter using Ctrl-T, or right mouse click in the list view background, or from the menu. There you will see that the default setting is the 100 most recent entries. The idea is to limit the amount of data that have to be...

Which particular XML plugin are you using, and what are you attempting to do with it?

The factr that there's an Oracle error code in this message indicates that DataStage sent the SQL to Oracle via the driver, but Oracle has complained about it. Use oerr -10695 to get more information about exactly what the error is. Was there any further text in the error message, or in a subsequent...

Iconv(string, "MD2") will generate the "implied decimal place" you require.
Read about MD conversions in on-line help or in the BASIC manual.

Remember, also, that there is only one data type in a text file: text. So you can use substringing and other techniques where appropriate.

If you can mount the disks, for example via SAMBA, then they are accessible. In older versions of DataStage you may need to enable NFS via the ALLOWNFS configuration parameter. Or, as Ken suggests, yoy can create a shell script that retrieves the file to the local machine (perhaps using rcp , perhap...

I answered this about 18 months back for another poster who was new then. Go herefor that responnse

Assuming that the ".B program" that you have is a valid one, it needs to be placed in the DSU_BP.O directory. Syntax of the CATALOG command will then be CATALOG DSU_BP progname.B LOCAL This creates an entry in the VOC file of the project whose key is progname.B, which may not be exactly what you wan...

Make your own clone of the DATE.TAG Transform and/or of the Routine it calls. Or simply create your own expression (or Transform, which is a pre-stored expression). For example: (TheDate = Oconv(Iconv(TheDate, "DYMD"), "D-YMD[4,2,2]")) This returns 1 if ht...

There are two commands within the DataStage Engine (~= UniVerse) environment for capturing output. COMO captures output into a file in the &COMO& subdirectory in the project. DIVERT.OUT allows output to be directed more generally. In the examples below &UFD& refers to the project directory itself. C...