How to fix the Oracle error PGU-30606: TIP generation: missing multi-byte NLS name for string:?

In this post, you’ll learn more about the Oracle ErrorPGU-30606: TIP generation: missing multi-byte NLS name for string: with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGU-30606: TIP generation: missing multi-byte NLS name for string:

Reason for the Error PGU-30606: TIP generation: missing multi-byte NLS name for string:

Cause: The COBOL data field specifies character data in the the PIC and USAGE clauses which require translation with a multi-byte character set (MBCS), but no Oracle MBCS NLS name was specified. The MBCS-oriented PIC and USAGE definitions were selected from the PG DD to identify field conversion function calls. PGAU also issues messages 30601 for and 30602 for .

How to fix the Error PGU-30606: TIP generation: missing multi-byte NLS name for string: ?

You can fix this error in Oracle by following the below steps

Action: Use the pgddsxa.sql script to reproduce the selected rows and then either correct the mask and maskopts columns for the stated field in the PG DD to not require MBCS translation, or use the PGAU REDEFINE DATA FIELD NLS_LANGUAGE(nlsname) parameter to specify an Oracle MBCS NLS name for the field, or specify the NLS_MBCS(nlsname) parameter on the PGAU DEFINE TRANSACTION statement.