Statements (DDL and DML)

Showing 89

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 1 year ago in Db2 / Statements (DDL and DML) 0 Future consideration

2 VOTE

Locally defined functions within stored procedures and user defined functions

Since Db2 10.1 it is possible to define locally defined types and procedures. In many situations locally defined functions are missing.

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

1 VOTE

Add varchar(max) and nvarchar(max)

We are frequently moving data between MS-SQL server and Db2. When data are moved from Db2 to MS-SQL there are no issues. But when data are moved from MS-SQL to DB2 we have frequent problems with varchar and nvarchar data types for data types where...

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

3 VOTE

Start Commandline-Script in Stored Procedure

Executes external commandline-scripts from stored procedure. The stored procedure call should work like following: select * from (VALUES '`sh /tmp/test.sh`') AS TEMP(Testoutput); With the script i check if new created tables or views from developm...

almost 2 years ago in Db2 / Statements (DDL and DML) 1 Future 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 2 years ago in Db2 / Statements (DDL and DML) 0 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

about 4 years ago in Db2 / Statements (DDL and DML) 1 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

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

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

1 VOTE

The change 'Primary Key Name' is added!

Currently, I know that there is no function to change only the 'Primary Key Name' of Db2. Especially in the case of Primary Key, Unique Index is also created when it is generated! Since the primary key name cannot be duplicated, there is a problem...

10 months ago in Db2 / Statements (DDL and DML) 0 Future consideration

Please enter your email address

FILTER BY CATEGORY