TAILIEUCHUNG - Common DB2 SQLCODE Values

Let’s go back in time almost three decades ago back to the wild and woolly 1980s! And watch as our favorite DBMS, DB2, grows up over time. Version 1 Release 1 was announced on June 7, 1983. And it became generally available on Tuesday, April 2, 1985. I wonder if it was ready on April 1st but not released because of April Fool’s Day? Initial DB2 development focused on the basics of making a relational DBMS work. Early releases of DB2 were viewed by many as an “information center” DBMS, not for production work like IMS. Version 1 Release 2 was announced on February 4, 1986 and was released. | DB2. . Developer s Guide A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z os Common DB2 SQLCODE Values SQLCODE SQLSTATE Description 000 00000 The SQL statement finished successfully. 100 02000 No rows found to satisfy the SQL statement. 117 01525 Number of values being inserted does not equal number of columns in the table. -101 54001 SQL statement is too complex. -104 42601 Illegal symbol encountered in SQL statement. Usually this means you have a syntax error somewhere in your SQL statement. -122 42803 Column function used illegally all columns not applied to the column function must be in the GROUP BY. -150 42807 Invalid view UPDATE requested or an invalid INSERT UPDATE or DELETE was requested on a transition table during a triggered action. -305 22002 A null was returned but no indicator variable is available to assign null to the host variable. -501 24501 Must open a cursor before attempting to fetch from it or close it. -502 24502 Cannot open a cursor twice without first closing it. -510 42828 The table specified by the cursor of the UPDATE or DELETE statement cannot be modified as requested. -530 23503 Invalid foreign key value supplied for the specified constraint name. -532 23504 Deletion violates the named referential constraint. -545 23513 INSERT or UPDATE caused a check constraint violation. -552 42502 User is attempting to perform an operation for which he or she is not authorized. -803 23505 Insert violates uniqueness constraint. -805 51002 The DBRM or package name was not found in the plan. -811 21000 Must use a cursor when more than one row is returned as the result of an embedded SELECT statement. -818 51003 Plan Package vs. load module timestamp mismatch. The DBRM in the executing plan or package was not created from the same precompilation as the load module. -904 57011 The specified resource is unavailable. Determine why and retry the request. -911 40001 The current unit of work has been rolled back. -913 .

• Cơ sở dữ liệu
• SQL Techniques
• Distributed DB2
• DB2 Performance Monitoring
• DB2 Utilities
• DB2 In Depth
• DB2 Performance Tuning
• DB2 Application Development
• Fundamentals of Database Systems
• Database Systems
• Programming techniques
• Database programming
• SQL Triggers
• Views in SQL
• information technology
• materials informatics
• computer synthesis
• Microsoft SQL Server 2000
• SQL Server 2000
• teaching techniques
• programming languages​​
• programming techniques practiced
• framework
• Ado
• net 3
• entity framework
• entity SQL
• Cơ sở dữ liệu
• Lecture Database
• Data modeling
• Constraints as assertions
• Beginning SQL
• Server 2005 Programming
• Normalization Techniques
• Advanced Normalization
• Hardware
• Computer Science
• Network Administration
• software
• tips for using the computer
• installation experience
• computer repair
• software programming
• SQL programming
• computer programming
• computer applications
• windows tricks
• windows programming techniques
• programming Java
• lập trình SQL Server
• lập trình database
• lưu trữ dữ liệu
• dữ liệu hệ thống
• lập trình máy tính
• lập trình phần mềm
• different non linear
• optimization techniques
• illegal adulterant
• multiplier provides
• multipliers require
• electronically obtained