Stack Overflow
Stack Overflow

Questions tagged [db2-woc]

8 questions
1
vote
2 answers

DB2 Warehouse on Cloud Load_jobs filename or path is not valid failure

I have to try to load data to DB2 WoC (formerly dashDB) from IBM Cloud Object Storage (Softlayer) by using /load_jobs API call. Always getting error response: SQL3025N,A parameter specifying a filename or path is not valid.,0,n/a Trying different…
CTiPKA
  • 2,944
  • 1
  • 24
  • 27
0
votes
0 answers

Issue connecting SPSS Modeler 18.3 & 18.4 to DB2WoC Databases - Null values rendered as the value in the previous record

I am having an issue connecting SPSS Modeler 18.3 & 18.4 to DB2WoC Databases - Null values rendered as the value in the previous record. For instance record 1 contains the values - 1,2012-12-12,,"Strength" record 2 contains…
Damian
  • 1
0
votes
1 answer

How to create external table in db2 with basic DML operation

I created external table with following command db2 " CREATE EXTERNAL TABLE TEST(a int) using (dataobject '/home/db2inst2/test.tbl' ) ) " db2 "insert into TEST values(1)" db2 "insert into TEST values(2)" But looks like it is replacing value.…
Vishnu
  • 97
  • 1
  • 13
0
votes
1 answer

How to handle error in ibm_db python package while calling stored procedure?

I'm trying call stored procedure using following code conn = ibm_db.connect("database","username","password") sql = "CALL DB2INST1.KPI_VALIDATE()" stmt = ibm_db.exec_immediate(conn, sql) But this procedure does not return any rows & It will only …
Vishnu
  • 97
  • 1
  • 13
0
votes
1 answer

How to use liquibase cmd with db2 ssl connection?

I'm trying to run liquibase update command using liquibase --driver="com.ibm.db2.jcc.DB2Driver" --changeLogFile="masterchangelog.xml " --url="jdbc:db2://localhost:60001/SMDINTDB:retrieveMessageFromServerOnGetMessage=true;sslConnection=true;" …
Vishnu
  • 97
  • 1
  • 13
0
votes
2 answers

DB2 Warehouse on Cloud default PLSQL compatibility

How can I find if a DB2 Warehouse on Cloud instance is enabled for Oracle compatibility? What is the default compatibility mode for DB2WoC instance which was provisioned from IBM Cloud? Is there a way to toggle the mode? Thanks.
Vamshi Krishna
  • 15
  • 4
0
votes
1 answer

IBM Db2 Warehouse client container db_migrate error

Short Description: Error on db_migrate IBM Db2 Warehouse client container I have successfully installed the client container v2.9.0 for DB2 Warehouse from docker. I am trying to run the db_migrate command to copy data from our "old" PDA servers to…
AdamSzilagyi
  • 1
0
votes
2 answers

How to connect DB2 to Cognos Dynamic Dashboard Embedded on IBM Cloud

I have an IBM Cloud account with a DB2 (SMP Small), a Cognos Dynamic Dashboard Embedded services provisioned and a .php app bpund to the DB2 instance. I managed to find some simple tutorials on how to create a session and a framework for the API…
Robert Pitrone
  • 109
  • 1
  • 3
  • 13