Stack Overflow
Stack Overflow

Questions tagged [dashdb]

IBM Db2 Warehouse on Cloud (formally known as IBM dashDB) is a fully managed data warehousing service in the cloud.

For more information on IBM Db2 Warehouse on Cloud (formally known as IBM dashDB), visit here.

For more information on IBM Db2 Warehouse (formally known as IBM dashDB local), visit here.

226 questions
2
votes
1 answer

SQL how to highlight duplicates under some conditions

I need to mark dupliactes in the data buy only under some complex conditions. Let's say I have a table like this: col1 col2 1 a 1 a 1 a 2 #B 2 #B 1 a 3 #B 3 #B 2 #B 1 a 4 #A 4 …
Mike Pala
  • 766
  • 1
  • 11
  • 39
2
votes
2 answers

Unable to setup a DB2 / DashDB JDBC Connection in Apache Airflow

I'm trying to create a DB2 / DashDB connection using the Airflow UI. I have added the db2jcc4.jar driver and provided the path as well as the class name com.ibm.db2.jcc.DB2Driver.class I tried to run a simple query (in the ad hoc UI) and always get…
Bruno Faria
  • 549
  • 1
  • 6
  • 20
2
votes
2 answers

DashDB DB2 UNIQUE with NULL values

it does not seem to be possible to declare a NULLABLE column, and to create a UNIQUE constraint. Is there a way to deal with this case? I need a column that can contain NULL values or UNIQUE values. Maybe a trigger could do this? Thanks I'm using…
yelo3
  • 5,613
  • 5
  • 26
  • 23
2
votes
2 answers

How can I enable SQL Magics in Jupyter Notebooks on IBM Data Science Experience?

I am using a Jupyter Notebook on IBM Data Science Experience. Is it possible to enable SQL Magics/IPython-sql? How can I install it? I want to connect to dashDB/DB2 and run SQL statements.
data_henrik
  • 16,724
  • 2
  • 28
  • 49
2
votes
1 answer

JPA how to define @Table with ORGANIZE BY ROW

Is there a way to change specify a "ORGANIZE BY ROW" argument when defining a table with JPA? The code I'm working on is @Entity @Table(name = "ANSWERS") public class AnswerEntity { @Id @Column(name = "CLASS") private String…
Sari
  • 21
  • 1
2
votes
1 answer

How to migrate off SQLDB service on IBM Bluemix?

IBM is pulling the SQLDB service on Bluemix. Does anybody know how I can move my stored data, what are my options in terms of service?
Dan Pohlman
  • 25
  • 3
2
votes
2 answers

How can I change the Bluemix documentation?

I found that the Bluemix documentation is wrong in an example of the SQLDB service and I ran into an issue. I was able to fix it myself. How can I change the Bluemix documentation? How do I submit feedback and get the docs fixed?
data_henrik
  • 16,724
  • 2
  • 28
  • 49
2
votes
1 answer

How to connect to dashdb with node.js httpRequest

How can we connect to Dash DB using HTTP/Request module of node.js and execute R-script code. I am able to do it using Node-RED but like to do it programmatically. Right now I am getting this error: 0530 [App/0] ERR Potentially unhandled rejection…
user5440060
  • 23
  • 3
2
votes
2 answers

Cannot add Foreign Key on tables in DashDB / DB2 on Bluemix

When I create a table in DashDB (DB2) on Bluemix like this: CREATE TABLE DEPARTMENT ( depname CHAR (10) UNIQUE NOT NULL , phone INTEGER ) ; ALTER TABLE DEPARTMENT ADD CONSTRAINT DEPARTMENT_PK PRIMARY KEY ( depname ) ; CREATE TABLE…
remkohdev
  • 250
  • 3
  • 13
2
votes
1 answer

What is my password for R-studio in dashDB console?

I have launched the dashDB console and wanted to use R studio. After launching R studio from the console page, I'm prompted for the username and password. Where do I retrieve my credentials for R-studio from Bluemix or dashDB?
CharlesL
  • 942
  • 5
  • 14
1
vote
2 answers

for db2 on cloud, are things like runstats and reorgchk/reorg done automatically?

I am seeing some slow performance on a couple of my queries that run against my db2 on cloud instance. When I had a local db2, I would try these tools to see if I could improve performance. Now, with db2 on cloud, I believe I can run them using…
Chris Ratcliffe
  • 116
  • 1
  • 10
1
vote
1 answer

Why am I getting the "SQL0134N Improper use of a string column..." error with my query?

I am trying to get "unique types of crimes have been recorded at GAS STATION locations" from the table CHICAGO_CRIME_DATA on Juptyter Notebook. %sql select DISTINCT PRIMARY_TYPE from CHICAGO_CRIME_DATA WHERE LOCATION_DESCRIPTION = 'GAS…
user10927965
1
vote
1 answer

Db2 on IBM Cloud: How to get the table space?

I use DB2 on IBM Cloud. I got a message: Unable to allocate new pages in table space "XXXXX" May I know what's the table space for free plan and Flex plan? How to expand the space?
cy xu
  • 13
  • 2
1
vote
2 answers

How to change default database name BLUDB in IBM Db2 Warehouse on Cloud?

Whenever I create a Db2 service in IBM Cloud, it takes the default database name BLUBDB. I want to change to user specific name like TESTDB?
user70329
  • 359
  • 2
  • 5
1
vote
1 answer

Db2 Warehouse: How to load table data using the V2 or V3 REST Interface

I have instantiated a Db2 Warehouse on IBM Cloud and created a table in that Db2 instance. Now I want to load that table with data that resides in a local *.csv file. I am able to create a bearer token: curl -X POST…
josoft
  • 11
  • 3
1
2
3
…
15 16