Menu principal                 [Fechar]
Introdução
Divisões
Identification Division
Environment Division
Data Division
Procedure Division
Comandos CICS
VSAM - File Status
Quadros importantes
SQL - Structured Query Language
Outros programas
Rotinas prontas
Palavras reservadas
Introdução ao Oracle
Sites de busca
Sites interessantes
Meu e-mail

SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -741

A database-type DATABASE IS ALREADY DEFINED FOR MEMBER member-name

Conclusão: A CREATE DATABASE statement was issued for a WORK FILE or TEMP database, but the database can not be created because one is already defined for the named DB2 subsystem or data sharing group member.

database-type
WORK FILE or TEMP

member-name
Name of the DB2 subsystem or data sharing group member that already has a database-type database.

Ação do sistema: The statement cannot be executed.

Resposta ao Desenvolvedor: Verify the identity and validity of the existing database-type database for the named DB2 subsystem or data sharing member. The existing database can be altered or dropped if necessary. If the existing database is dropped, resubmit the CREATE DATABASE statement.

SQLSTATE: 55020

© Copyright IBM Corp.