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

SQL Conditional Column selection

I'm running a simple query: Select "ID", "Original_ID" from table; and that gets me this: ID | Original_ID 56917659 | #56906230 Captain 56781961 | #56754164 Shipment Management 56794542 | #56620028 Team Member 56655028 | …
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

Query fails on Bluemix dashDB when the columns names are camel cased or lower cased

I have a Bluemix dashDB entry level instance. I have created a table which is as seen below When i run the following query select * from USERS where userId=2; I get the following error "USERID" is not valid in the context where it is used..…
S.A.Norton Stanley
  • 1,833
  • 3
  • 23
  • 37
0
votes
5 answers

dashDB and DB2 Load operation

I am currently trying to use a dashDB database with the db2cli utility and ODBC (values are from Connect/Connection Information on the dashDB web console). At this moment I can perfectly do SELECT or INSERT statements and fetch data from custom…
Steph
  • 47
  • 1
  • 8
0
votes
3 answers

SQL name value with highest value in another column

let's say I have a table like so: Store | Item | Price store01 | Apple | 2.50 store01 | Pear | 3.00 store01 | Banana | 3.11 store02 | Apple | 2.50 store02 | Pear | 2.00 store03 | Banana | 3.10 and I just want a query that…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

dashDB local MPP deployment issue - cannot connect to database

I am facing a huge problem at deploying a dashDB local cluster. After a successful deployment the following error comes in case of trying to create a single table or launch a query. Furthermore webserver is not working properly like in previous SMP…
Daniel Huszti
  • 3
  • 2
0
votes
2 answers

SQL CONVERT string to date issue

I have a column with string values like this 05.2015. I need to get a DATE value out in the format that the first 2 chars are the month and the day is always the 1st... so in this example it would be 01/05/2015 ... or 2015-05-01 ..depending on the…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

SQL query, is GROUP BY needed? how to avoid unnecessarily complicated syntax

I am building a query that will build one, pretty large data set based on 4 tables. Here is my query so far: SELECT CLIENT_CA."Requisition_ID", CLIENT_REQS."Requisition Title", CLIENT_REQS."Country", CLIENT_CD."Application_Status", …
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

bluemix pyspark error occurred while calling jdbc

I'm using pySpark in the Spark service in Bluemix to transform something in my data and then write it in DashDB, also in Bluemix. But when I try to load data I receive the following error: Py4JJavaError: An error occurred while calling o111.jdbc. :…
Bruno Hirata
  • 21
  • 3
0
votes
1 answer

Cloudant JSON data into dashdb table joins

I have successfully imported some JSON data into cloudant, the JSON data has three levels. Then created the dashdb warehouse from cloudant to put the data into relational tables. It appears that dashdb has created three tables for each of the…
binway
  • 88
  • 1
  • 11
0
votes
1 answer

Bluemix DashDB WHERE IN statement not working

I am developing an IBM Bluemix solution using Node-RED with DashDB. I am facing an issue when parsing the multiple values to an column called ACCOUNT_ID on a WHERE IN SQL clause. If I just pass one parameter it works perfectly but when I have two or…
Eduardo Diogo Garcia
  • 41
  • 7
0
votes
1 answer

Call to undefined function db2_connect()

I am trying to access to dash db from netbenas 8.0 but it is unable to access throwing the error Call to undefined function db2_connect() in /var/www/PhpProject6/demo3.php on line 11 while running through netbeans8.0
user6769147
0
votes
2 answers

Dashdb/Netezza: SQL syntax errors

I come from a heavy T-SQL background, have been familiarizing myself with IBM Netezza appliance for a customer. I have played with the Netezza emulator 7.1 on Windows, ran DDL, DML, Control, and Transaction statements. Also, I signed up for a trial…
user3789226
  • 1
  • 2
0
votes
1 answer

SQL to list tables in a dashDB schema

I need to list all of the tables in a schema in dashDB (Db2 Warehouse on Cloud on IBM Cloud). Is this possible using just a SQL statement or do I need a CLI tool for this? If it is possible using a SQL statement, please let me know what it…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
2 answers

DashDB - Export data using Java

I'm using DashDB (Bluemix service) and I need to export the tables data in my Java code. For that purpose I wrote the following ... String sql = "CALL SYSPROC.ADMIN_CMD(?)"; callStmt1 = conn.prepareCall(sql); query = "export…
Macana
  • 1
0
votes
2 answers

DashDB local (docker) failed to start because database services didn't start

I encountered an error while deploying and starting dashDB local on RedHat Enterprise Linux 7.2. Here are the main steps of IBM's official tutorial, which I followed step-by-step. 1.Deployment first steps - downloading and running container: docker…
Daniel Huszti
  • 3
  • 2
1 2 3
…
15 16