Q&A BY TAG 'DB2'

You must sign in to ask a question. If you do not have an account, you can register here

DB2 TABLE column with data type packed decimal conversion issue
answered 20-09-2021 01:51:15 -0400

I am connecting to a DB2 database. one particular table contains a column with data type - PACKED DECIMAL. the base view displays junk characters for this column. is there a way to convert the data type of the column on the fly or in the VQL? OR i...

Answers: 1

DB2 Packed decimal

DB2 for i statistics
answered 25-05-2021 17:27:52 -0400

Trying to gather statistics for a table in DB2 for i, and Denodo 8 is telling me "It is not possible to gather statistics from the system tables of the data source: Gathering statistics from system tables is not supported for this database". Has anyon...

Answers: 1

DB2

DB2 enable query acceleration
answered 24-12-2020 01:33:24 -0500

I have a need to connect to DB2 by enabling query acceleration. I followed the IBM docs https://www.ibm.com/support/pages/enabling-query-acceleration-ibm-db2-analytics-accelerator-odbc-and-jdbc-applications-without-modifying-applications To enable qu...

Answers: 1

DB2

DB2 - firstdayofmonth with an Analytical function
answered 14-04-2020 15:25:18 -0400

Database: DB2 I created a view with a date compare in the where clause field1 >= addmonth(firstdayofmonth(current_date()), -2) Then used an analytical function in the same view row_number() OVER ( PARTITION BY field2, field3 ORDER BY field4 DES...

Answers: 1

DB2

DB2 - WITH UR
answered 14-04-2020 15:13:08 -0400

Database: DB2 We are having a performance issue with a query and our DBA suggested to use "With UR" clause at the end of the query. At this time, the view in Denodo is built using the UI and I am not able to add this in where clause and I don't see an...

Answers: 2

DB2

Joining Large Tables
answered 31-01-2020 19:35:22 -0500

There are 11 views in the join. Out of which, six views have rows in the range of 33 to 84 Million. 2 views in the range of 2 to 4 million and the remaining 3 in the range of 220 to 850K rows. It is all simple joins between tables, but due to the size,...

Answers: 1

DB2

DB2 on AS400
answered 18-11-2019 18:02:44 -0500

Connection established to DB2 on AS400 with jt400.jar. Query execution is failing with below error [JDBC ROUTE][ERROR] Received exception with message '(PWS9801) function rejected by user exit rpogram PUSEXTPGM in DPSMLIB The class name to register u...

Answers: 1

DB2

Query Simplification
answered 22-10-2019 09:05:11 -0400

Hello, I have a scenario where I need to "Simply a Query" based on selection. For example I have two base views, first one named "bv_first_view" (with field names - id, name, age, address) , second base view named "bv_second_view" (with field names - ...

Answers: 4

DB2 Query Simplification