Statements (DDL and DML)

Showing 91

SQLCODE SQL0302N should give hint which parameter is too long.

Scenario: prepared statementsError: host variable too longProblem: SQL0302N should give a hint which parameter is affected. Details:Using prepared statements with parameter markers such as INSERT INTO TESTTAB (COL1, COL2) VALUES (?, ?)"); DB2 thro...

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

10 VOTE

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

3 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 ...

almost 2 years 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.

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

about 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....

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

over 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...

almost 6 years ago in Db2 / Statements (DDL and DML) 1 Not under 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...

9 months 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...

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

Please enter your email address

FILTER BY CATEGORY