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

MCP

Converts unprintable characters to a period.

Syntax

MCP

Examples

The following example shows the effect of an MCP conversion code with the Iconv function:

Conversion Expression
Internal Value
X = Iconv("John^CSmith^X1-234", "MCP")
X = "John.Smith.1-234"

The following example shows the effect of an MCP conversion code with the Oconv function:

Conversion Expression
External Value
X = Oconv("John^CSmith^X1-234", "MCP")
X = "John.Smith.1-234"

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

Update timestamp Last updated: 2010-09-30