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
14
votes
2 answers

how to perform 'SELECT TOP X FROM TABLE' type queries with DB2 / dashDB

I would like to perform the equivalent of SELECT TOP 1 ... query in db2 / dashDB: SELECT TOP 1 * FROM customers How can I achieve this?
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
4
votes
2 answers

How to connect Power BI to IBM DB2

Currently, I am trying to query data from IBM DB2 and then present it in Power BI. However, I notice the information that Power BI needs is different from what I got from the IBM DB2. The information that Power BI needs is: The connection…
Yipin
  • 61
  • 1
  • 5
4
votes
1 answer

cURL and password containing colon

I am working on OpenSuse, and I try to do a data upload toward a dashDB Local environment through cURL utility. When I use a user/password with a simple password (no 'special' characters), it works well, but when the password contains a colon it…
Steph
  • 47
  • 1
  • 8
4
votes
3 answers

Spark JDBC to DashDB (DB2) with CLOB errors

I am working to connect my spark application to DashDB. Currently, I can load my data just fine. However, I am unable to save a DataFrame to DashDB. Any insight will be helpful. var jdbcSets = sqlContext.read.format("jdbc").options(Map("url" ->…
Aaron B
  • 173
  • 7
4
votes
1 answer

How to connect dashDB (on Bluemix) with Object Storage (on Bluemix)?

I am using Public Bluemix. I have provisioned a dashDB service instance using my IBM ID in Bluemix. I have also provisioned a Object Storage service. I would like to load files from Object Storage into dashDB. When I try to define a load job in…
Aditya Dutta
  • 55
  • 2
4
votes
1 answer

Executing DDL in compound SQL using DashDB (DB2)

I need to execute a DDL command (CREATE TABLE) with other SQL commands. See the code snippet below: CREATE TABLE test AS ( SELECT duration AS NUM1 FROM event WHERE duration IS NOT NULL ) WITH NO DATA; INSERT INTO test ( SELECT…
matheusr
  • 567
  • 9
  • 29
3
votes
4 answers

How to change timestamp in Db2?

I have created a table called 'Chicago crime data' I need to do some queries on it but the table wont load. The message i get is (timestamp format does not match data in the column 'UPDATEDON') What is populated in the Date column is MM-DD-YYYY, I…
Marls
  • 31
  • 1
  • 2
3
votes
3 answers

SQL select only one item which meets condition

I have a very narrow table: DATA, ID, LAT, LNG, TIME. (https://gyazo.com/52b268c00963ed12ba85c6765f40bf63) And I want to select the newest data for each different ID. I was using query like SELECT * FROM name_of_table WHERE TIME >…
WutchZone
  • 154
  • 1
  • 3
  • 13
3
votes
1 answer

How can I use a column named _id from a dashDB table?

I have a database in Cloudant where the document ID is _id. After replicating this data from Cloudant to dashDB I have 2 separate tables that I want to join using this _id column. In Run SQL I tried the below, but this would not run. What am I…
Margriet
  • 35
  • 6
3
votes
2 answers

Can db2 import or load be used to populate DashDB?

I'm looking to bulk loads millions of rows into a DashDB database. After connecting using the DB2 CLI, I enter a command like: db2 import from rowsToImport.csv of del insert into MY_TABLE with results: SQL0551N "DASHXXX" does not have the…
Hunter Medney
  • 381
  • 2
  • 10
3
votes
1 answer

Is there any way I can restore a DB2 backup file onto IBM DashDB?

I am trying to restore a DB2 backup file into my BlueMix DashDB service. How do I go about doing this?
Michael Noh
  • 33
  • 3
3
votes
2 answers

How to pass two parameters to dashDB query element of Node-Red from IBM Bluemix

I'm trying to pass two parameters into sql query from dashDB object in Node-Red flow editor on Bluemix. My parameters are stored in msg.fromDate and msg.toDate and I want to enter them into "Parameter Marker" of dashDB node. When I only use one…
Marcin Labenski
  • 61
  • 7
3
votes
1 answer

Why does Bluemix dashDB operation throws a SqlSyntaxErrorException with SQLCODE=-1667?

I'm getting this error even though I am not trying to edit the table/column: com.ibm.db2.jcc.am.SqlSyntaxErrorException: The operation failed because the operation is not supported with the type of the specified table. Specified table:…
MisT.
  • 33
  • 4
2
votes
2 answers

Add Java/JRE/JVM in Python Flask Cloud Foundry/IBM Cloud application

I am running a python flask application in a Cloud Foundry/IBM Cloud-environment. In my application I try to connect to DB2 Warehouse on Cloud with the IBMDBPY-package. This packages needs a package called jaydebeapi to be able to run. For the…
danielo
  • 770
  • 2
  • 13
  • 32
2
votes
1 answer

Enabling Automatic Client Reroute for Availability when using DB2onCloud(aka dashDB for Transactions) HA plan

Currently DB2onCloud in IBM Bluemix has as HA plan, in order for apps to seamlessly connect to the database during planned maintenance or if there is failover, how can we do that at an application side?
Pandu Ranga Rao Mutyala
  • 36
  • 3
1
2 3
…
15 16