Information icon IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
space Feedback

Oconv Function

Converts an expression to an output format.

Syntax

Oconv (expression, conversion [@VM conversion] ...)

expression is a string stored in internal format that you want to convert to an output format. If expression is a null value, null is returned.

conversion is one or more conversion codes specifying how the string is to be formatted. Separate multiple codes with a value mark. If conversion is a null value, it generates a runtime error.

Remarks

If you specify multiple codes, they are applied from left to right. The first code is applied to expression, then the next code is applied to the result of the first conversion, and so on.

The Status function uses the following values to indicate the result of an Oconv function:

0
The conversion was successful.
1
An invalid string was passed to the Oconv function. Either, the original string was returned, or if the string was a null value, null was returned.
2
The conversion was invalid.

PDFThis topic is also in the IBM InfoSphere DataStage Server Job Developer's Guide.

Update timestamp Last updated: 2010-09-30