Statements (DDL and DML)

Showing 89

InsteadOF SQL

It is common in the database world (DB2 but all the others I have worked with are the same) to have a separate product installed that generates code and submits it to the database for processing. Eventually, you will encounter SQL that doesn't per...

over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

8 VOTE

ALTER TABLESPACE ... REBALANCE STOP

Currently, ALTER TABLESPACE ... REBALANCE can be augmented with two optional clauses:ALTER TABLESPACE ... REBALANCE SUSPENDALTER TABLESPACE ... REBALANCE RESUME We need ALTER TABLESPACE ... REBALANCE CANCELorALTER TABLESPACE ... REBALANCE STOP I w...

over 5 years ago in Db2 / Statements (DDL and DML) 1 Not under consideration

7 VOTE

db2expln stopped working from db2v11.5.7.0 onward on HADR STANDBY

db2expln, doesn't write / update and tables on the database and it was working till db2 v11.5.5 on STANDBY RO enabled, from v11.5.7.0 it stopped working, many time there is a need to check explain out on STANDBY RO enabled

6 days ago in Db2 / Statements (DDL and DML) 0 Submitted

6 VOTE

Expanding limit of Maximum number of columns in a table - Db2

Hi, In Db2, currently we have the limit of 1012 as maximum number of columns in a table, We would request you to exapand this limit. thank you! Regards, Sankar

about 4 years ago in Db2 / Statements (DDL and DML) 1 Not under consideration

6 VOTE

Foreign key with on update "cascade"

As part of the SQL 92 standard, there is a referential action for foreign key that allows to update on cascade. The following link is the SQL 92 standard:http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt In the Section 11.8, there is the f...

over 4 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

6 VOTE

Support for application-period temporal tables defined as CTE

Support for application-period temporal tables in CTEs. To be able to join Temporal Tables and temporal CTEs with a FOR BUSINESS_TIME clause.

over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

5 VOTE

Add "IF EXISTS" syntax to all DROP statements

More and more SQL is stored in repositories and needs to be applied in odd places and orders. One syntax element that supports this is the "IF EXISTS" on a drop statement. This causes a statement to not count as a failure if it finds no object to ...

about 1 year ago in Db2 / Statements (DDL and DML) 0 Future consideration

5 VOTE

DB2LOOK schema flag adjustment

There are two useful DB2LOOK flags that are often used: "-z" for specific schemas and "-t" for specific tables. I can give a list of tables, but a SINGLE schema. There are use cases where I want to capture DDL for more than one schema (which break...

almost 4 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

5 VOTE

Add BEFORE and/or AFTER clause to ALTER TABLE

For the ALTER TABLE statement, it's relevant to add an "AFTER ..." OR "BEFORE ..." clause specifying where in the table the new column is to be placed. This statement component exists in DB2 for i and in certain other databases (like Informix and ...

over 5 years ago in Db2 / Statements (DDL and DML) 2 Not under consideration

5 VOTE

Real-time statistics with statistics profile can lead to deadlocks and lock timeouts

DB2 real-time statistics facility honors RUNSTATS options specified in the statistics profile, while performing synchronous statistics collection during statement compilation. If the statistics profile contains ALLOW READ ACCESS option, this can l...

over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY