Stack Overflow
Stack Overflow

Questions tagged [ibm-data-studio]

IBM® Data Studio provides foundational database development and administration support for the DB2 and Informix family of products

From version 10.1 onwards, IBM stopped shipping DB2 Control Center packaged with DB2. To support database development, maintenance and administration, users now have to separately install IBM Data Studio.

Useful Links

95 questions
0
votes
1 answer

DB2 [SQL0029] INTO clause missing from embedded statement

UPDATE to my question. I found the answer and will edit the sample code. Thanks to those who tried to help me. The following test script checks out okay in the tool "Run SQL Scripts" and with an online SQL Syntax checker. However, when deploying it…
GCDevOps
  • 45
  • 6
0
votes
2 answers

-567 Rebind Authorization error for Auth ID IBM Db2 native stored procedure

A user is unable to create a native stored procedure via IBM data studio and faces -567 rebind authorization error for a particular auth id say DBAXXYY.The schema name is also same as the authid But I am able to create the stored procedure…
Sudarsan Rajagopalan
  • 83
  • 8
0
votes
1 answer

Do a SELECT based on a CASE statement

I am trying to execute a select statement depending on the CASE SELECT CASE WHEN TO_CHAR(today, "%a") = 'Mon' THEN (SELECT COUNT(*) FROM jobs WHERE datein > today-2) ELSE (SELECT COUNT(*) FROM jobs WHERE datein = today) END CASE; As a result I…
Arturo
  • 43
  • 5
0
votes
2 answers

How to Update to SET Table1.ColumnX = Table2.ColumnX with a where clause

Let's say I have one table called InsuranceMember which contains all members of insurance plans and their spouses. But oh no! for spouses that have a CountryCD of 'Canada' and have a PlanCD of '99999', the MemberNum's (primary key) are all incorrect…
DB2Jacob
  • 11
  • 2
0
votes
1 answer

How to pass VARGRAPHIC to Stored procedures in DB2?

How can I call a sp with VARGRAPHIC variable type as input? I've create this super simple sp that dose nothing and just for test, with following statement: CREATE PROCEDURE MYPROCEDURE (IN VARNAME vargraphic(5) ) LANGUAGE SQL P1: BEGIN END P1 but…
Masoud Sedghi
  • 495
  • 1
  • 6
  • 19
0
votes
2 answers

How to select rows where the value in one column doesn't have any duplicates (i.e DISTINCT) AND the value in a different column does, IN SQL?

This is in DB2. I want to write query that results in rows where values in one specified column are DISTINCT but then ALSO values in a second column are NOT distinct. Here's an example dataset: COL1 COL2 COL3 149999 Y …
DB2Jacob
  • 11
  • 2
0
votes
1 answer

Problems with silent install of IBM Data Studio 4.1.3

Iam working on a mass Deployment of IBM Data Studio 4.1.3 via SCCM. But in the tests the isntallation fails with the following message: Failed to write into registry in phase Install at path "HKEY_CURRENT_USER\SOFTWARE\IBM\OQT\IBM Data…
troelf
  • 1
  • 2
0
votes
1 answer

IBM Datastudio how to export/unload and import/load multiple tables with SQL?

I'm having issues using the normal sysproc.admin_cmd I thought we should use, as I get error SQL3001. It says I should put the file location of the export to bcufenc folder, but I can't find it, maybe because it is data studio client on my machine.…
Epicenter
  • 35
  • 5
0
votes
0 answers

Why is not running package in Data Client IBM? Why this is software doesnt see functions and procedures?

I have a problem with running of package in DATA CLIENT IBM. I created standard package of Data Client with specifications and etc. And it succesfully deployed, but it deployed without functions and procedure. And after running of package, I see…
Aleks
  • 147
  • 10
0
votes
2 answers

DB2 temp table session concurrent user issue

We are working with an application in .net with DB2 as a database. I am using the temp table in my stored procedure. Sometimes it throws an error "table is in use". Declare Global Temporary Table TRNDETAILS (USERID INT , Name VARCHAR ( 25 )) WITH…
Anandan M
  • 31
  • 5
0
votes
2 answers

How to download files from IBM Python Notebook to local computer?

I am trying to save a plot as a file through the Python Notebook in IBM Watson Platform. After trying localfilenamefromplot = 'foo1.png' fig = plt.figure() fig.savefig(localfilenamefromplot) I can't find where the file is stored. I tried to…
ZelelB
  • 1,836
  • 7
  • 45
  • 71
0
votes
2 answers

Import data fails in DB2

I'm using Data Studio to connect to a DB2 server. When I'm trying to use the 'import utility' in the Data Studio, it succeeds with a warning and the result show that no record has been inserted into the database. The Import wizard is generating the…
HHH
  • 6,085
  • 20
  • 92
  • 164
0
votes
1 answer

Backup operation fails for DB2

I'm using Data Studio to connect to a DB2 database server (db2 server is running on a Linux box). The server disabled SSH password login and I can only SSH using a private key and a keyphrase. I have configured SSH connection in Data Studio to use…
HHH
  • 6,085
  • 20
  • 92
  • 164
0
votes
1 answer

sshd connection fails in Data Studio

My db2 database is running on a server whose ssh password login is disabled and allows only private key ssh. I'm trying to import some data into a table in this database (the data is also sitting on the server). The ssh connection fails because of…
HHH
  • 6,085
  • 20
  • 92
  • 164
0
votes
1 answer

EXPLAIN tables with qualifier error while doing SQL tuning in IBM Data Studio

when I clicked on start tuning button by selecting my code, IBM data studio gives me error of EXPLAIN tables. I am using db2 10.1 on windows 10. see below screenshot for reference. Then I run this command: CALL SYSPROC.SYSINSTALLOBJECTS('EXPLAIN',…
Govind Gupta
  • 1,555
  • 4
  • 15
  • 24
1 2 3
4
5 6 7