IBM Mainframe Forum

DSNE610I NUMBER OF ROWS DISPLAYED IS 0                                         
DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN           
         UNAVAILABLE RESOURCE. REASON 00C900A3, TYPE OF RESOURCE 00000200, AND
         RESOURCE NAME SMDB026 .SMTS026                                       
DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE                               
DSNT415I SQLERRP    = DSNXRRC SQL PROCEDURE DETECTING ERROR                   
DSNT416I SQLERRD    = 102  13172746  0  13223106  -974970878  12714050 SQL     
         DIAGNOSTIC INFORMATION                                               
DSNT416I SQLERRD    = X'00000066'  X'00C9000A'  X'00000000'  X'00C9C4C2'
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0                       
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0       
---------+---------+---------+---------+---------+---------+-----
DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72   
DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1                 
DSNE621I NUMBER OF INPUT RECORDS READ IS 4                       
DSNE622I NUMBER OF OUTPUT RECORDS WRITTEN IS 26                       

CREATE TABLE ZCON026.TEST
(TESTVAR VAR(3),
NAME(VARCHAR(30),
PRIMARY KEY(TESTVAR))
IN SMDB026.SMTS026;

---------+---------+---------+---------+---------+---------+---------+---------+
INSERT INTO ZCON026.TEST                                                00010099
VALUES('001','THIAGO RIBAS');                                           00011099
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -540, ERROR:  THE DEFINITION OF TABLE ZCON026.TEST IS       
         INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX
DSNT418I SQLSTATE   = 57001 SQLSTATE RETURN CODE                               
DSNT415I SQLERRP    = DSNXOTL SQL PROCEDURE DETECTING ERROR                     
DSNT416I SQLERRD    = -550  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION           
DSNT416I SQLERRD    = X'FFFFFDDA'  X'00000000'  X'00000000'  X'FFFFFFFF'       
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION                   
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0                                       
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0                       
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72                 
DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1