Statements (DDL and DML)

Showing 95

Add generated always for each row on update as row change SESSION_USER

Currently exists in Db2 to change current timestamp on INSERT and UPDATE with generated statement like: create table myschema.mytable (id int, last_timestamp timestamp not null generated always for each row on update as row change timestamp) inser...

about 2 years ago in Db2 / Statements (DDL and DML) 1 Future consideration

3 VOTE

Add ALTER COLUMN options to modify numeric column length and allow rename column names for ((bi)temporal) column organized tables

Db2’s capabilities to perform schema changes on any form of ((bi)temporal) column organized tables lacks behind it’s row organized counterparts. This prevents effective database schema evolution and therefore limits the use of column organized tab...

about 2 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

3 VOTE

Add support for INFORMATION_SCHEMA views

In our company we are using PostgreSQL, SQL Server, MySQL and DB2. All of database except Db2 support INFORMATION_SCHEMA views. There is pretty easy to write at least basic cross-database SQL to get info from database catalog tables except in Db2....

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

8 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 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

4 VOTE

Enabling readonly mode for database or user. (DB2 LUW)

Would like to see a db level and a user level parameter to enable readonly mode at database level or user level. Currently need to run set of statements to achieve this, which makes management difficult. A single statement to enable readonly mode ...

over 3 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

8 VOTE

ALTER TABLESPACE ... REBALANCE STOP

Currently, ALTER TABLESPACE ... REBALANCE can be augmented with two optional clauses: ALTER TABLESPACE ... REBALANCE SUSPEND ALTER TABLESPACE ... REBALANCE RESUME We need ALTER TABLESPACE ... REBALANCE CANCEL or ALTER TABLESPACE ... REBALANCE STOP...

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

3 VOTE

Population of V12 new added Catalog columns during activation of Function level V12R1M50 and avoid it later during executions of ALTER TABLESPACE because of contention of packages.

After you apply the PTF for APAR PI86123, the first ALTER TABLESPACE, populates any null attributes for objects created in function level V12R1M100 or earlier. When the one-time population occurs for an ALTER TABLESPACE statement, Db2 must quiesce...

almost 3 years ago in Db2 / Statements (DDL and DML) 1 Future consideration

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

almost 6 years ago in Db2 / Statements (DDL and DML) 1 Not under consideration

4 VOTE

Altering the default value of a global variable

Global Variables: A global variable can be created with a default value. Each session that uses it will then instantiate a version of that global variable, with the default value and any change in the value is limited in scope to its unit-of-work....

over 4 years ago in Db2 / Statements (DDL and DML) 0 Not under 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...

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

Please enter your email address

FILTER BY CATEGORY