logo  
Google
 

DB2 SQL-Error: -742

SQLState: 53004

Short Description: DSNDB IS THE IMPLICIT WORK FILE DATABASE

The WORKFILE clause cannot be used on a CREATE DATABASE statement to create a work file database for a DB2 subsystem that is not a member of a DB2 data sharing group. The system database, DSNDB07, is the implicit work file database. System action: The statement cannot be executed. Programmer response: To create the work file database for a DB2 subsystem that is not a member of a DB2 data sharing group, create database DSNDB07 without the WORKFILE clause.

 <-  BACK TO INDEX