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
0
votes
1 answer

Connecting Bluemix DB2 on Cloud (DashDB) to IBM BPMoC

I'm trying to connect a database in the Bluemix DB2 on Cloud (DashDB) to IBM BPM on Cloud. Is this possible? I tried setting up a datasource in BPMoC using the data provided by DB2 on Cloud, but it is not able to connect: (Error…
ddbailie
  • 76
  • 3
0
votes
1 answer

Bluemix Services: Configuring WebSphere Application to use dashDB for Analytics

I'm using dashDB for Anayltics as a service for my Bluemix and I also added the SQL and data needed. But when I tried to start the application, I can't login. It seems that Bluemix can't find the dashDB... My question is, when you add a service to a…
Kael
  • 391
  • 1
  • 10
  • 21
0
votes
2 answers

Ibm analytics user logging data to DashDB, then sent to Watson Analytics

My name is Cristian and my task is to implement IBM Bluemix Analytics into an app (which was succesfull, since I get the data shown on my analytics service), then how do I transfer this data for every user into DashDB, and then into Watson…
Slow1mo
  • 9
  • 2
0
votes
1 answer

DSX "HELP: The JDBC driver for IBM dashDB/DB2 could not be found."

I am following an IBM demo notebook. I created a new notebook in a new instance of DSX I opened in Bluemix. DSX seems to have combined my existing DSX instance with the new one. When I try to connect to the dashDB instance, I get an error the…
JABrooks
  • 1
0
votes
1 answer

Dashdb round issue

We are executing the below query to get some aggregated data, the issue is for some of the rows the rounding is fine bit for some the rounding doesn’t work and shows 10 digits after decimal. The selected columns have integer as their datatype and…
Lohith Kumar
  • 1
0
votes
2 answers

How to export IXF and LOB files from dashdb

I need to copy some tables in one dashdb database over to separate dashdb database. Normally I would export the CSV file from one and load it into the other using the Web console, however one table in particular has a CLOB column and so we will need…
jpwsutton
  • 170
  • 3
  • 8
0
votes
2 answers

Connecting to DashDB on Bluemix using Bluemix PHP App

I'm failing to connect to the dashdb on bluemix using php. I tried troubleshooting and I think that my error is within the function $conn = db2_connect( $conn_string, "", "" ); What values do I need to put in the empty inverted commas? Please…
Dave
  • 15
  • 1
  • 7
0
votes
1 answer

Creating a new table along with join statements in Run SQL in IBM dashDB

I'm new with SQL and I'm trying to create a new table after joining two tables with different fields except for the primary id. I saw online that it is possible, but IBM's dashDB's Run SQL doesn't seem to like it as it marks it as…
user2880990
  • 29
  • 1
  • 4
0
votes
1 answer

Getting wrong output when using IN keyword db2

so this is my query : select count(a.rs1) as partsProduced, a.DEVICEID ,a.DATA_MAINPROGRAMNO from ( SELECT currow, rs1, rs2,DEVICEID,DATA_MAINPROGRAMNO FROM ( SELECT current_row.row1 currow, current_row.DATA_RUNSTATUS rs1, …
Rahul Kulkarni
  • 65
  • 6
0
votes
1 answer

DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=Invalid collation ID, DRIVER=4.21.29

Trying to execute the statement select * from RU_VARIANCE_HISTORY but I'm getting the error DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=Invalid collation ID, DRIVER=4.21.29 Tried searching but unable to find the solution.
Diwakar Bhatt
  • 495
  • 2
  • 11
  • 24
0
votes
2 answers

SQL how to check is a value in a col is NOT in another table

Maybe I need another coffee because this seems so simple yet I cannot get my head around it. Let's say I have a tableA with a col1 where employee IDs are stored.... ALL employee IDs. And the 2nd table, tableB has col2 which lists all employeeID who…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

SQL ROW_NUMBER()OVER(PARTITION BY with conditions

I understand the basics of Row_Number but how do you use it with some conditions. So, I need the number of an instance of a value in col1 BUT only where col2 is not null and col2 is null. So, I have this: col1 col2 col3 Orange x …
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
2 answers

How do i declare and increment local variables in db2?

I want to show row number for each of result set row, I have this query in mySQL SELECT @rownum := @rownum + 1 row, e.* FROM Employee e, (SELECT @rownum := 0) r Here @rownum is local variable and would increment its value for each result row. How…
Rahul Kulkarni
  • 65
  • 6
0
votes
2 answers

SQL, order of value instance in table

I hope this is a simple issue but I'm not really sure how to even approach it. Let's say I have a table. I do a select statement on that table for several columns. I want to add one more formula column that will show me the instance number/count of…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
4 answers

How to get min value from multiple columns for a row in SQL

I need to get to first (min) date from a set of 4 (or more) columns. I tried select min (col1, col2, col3) from tbl which is obviouslly wrong. let's say I have these 4 columns col1 | col2 | col3 | col4 1/1/17 | 2/2/17 | |…
Mike Pala
  • 766
  • 1
  • 11
  • 39
1 2 3
…
15 16