ERROR: "DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION" OMWeb Viewer 12.1
search cancel

ERROR: "DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION" OMWeb Viewer 12.1

book

Article ID: 45471

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

Trying to create the database tables using the DDL supplied by RO71688 DB2 DDL DOES NOT WORK WITH EXPLICIT TABLESPACES and getting

DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE.

Environment

  • Output Management Web Viewer 12.1
  • DB2 V10 CM

Cause

DB2 V10 CM is in Conversion Mode instead of NFM and the required function is not available. Please note that you must be at DB2 Version 9 NFM or higher. 

Resolution

Complete the migration from Conversion Mode to DB2 10 NFM

Workaround:

Use the internal Derby database until the conversion has been completed.  Then use RO74120 NEED CONVERSION FROM INTERNAL DATABASE TO DB2 to convert from the internal Derby database to DB2.