#sql statement

5 More DB2 SQL Performance Tips

START Analytics Career

SELECT from INSERT, UPDATE whenever possible.  This feature is great for getting the values associated with identity, sequence, and any other database column keys while doing an INSERT or UPDATE SQL operation. This capability provides for the capturing of generated key values needed to be returned to the application during an UPDATE or INSERT statement.  Instead of executing…

DB2 Zo/S – Common Error Codes

+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…

As I have mentioned in one of my previous articles I am slightly disappointed in MySQL prepared statements, so I decided to look to theold and proven ways to improve the speed of the MySQL interaction. But what is even more impressive this approach allows even reduce hardware utilization.