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 printing logs

I am using DB2 IBM data studio, and I cannot print logs: create procedure test_ticket begin declare stmt varchar(500); DECLARE QTY INTEGER; SET QTY = (select count(*) from test.ticket); CALL DBMS_OUTPUT.PUT_LINE( QTY…
kinkajou
  • 3,664
  • 25
  • 75
  • 128
0
votes
1 answer

Building Stored Procedure for DB2 for IBM i (iSeries) through Data Studio fails

When trying to Deploy a Stored Procedure for DB2 on IBM i (an iSeries) through Data Studio, it says "No Build Services found for routine." in the status window. I see options in preferences->Data Management->SQL Development->Routines->Deploy…
jflu82
  • 23
  • 4
0
votes
1 answer

Why don't I see all of my DB2 instances in Data Studio?

I'm running IBM Data Studio 4.1.1 in Windows 8.1. I have a copy of DB2 Express-C 10.5 on the same machine and it has two instances, the default one of DB2 and a new one I've created called inst2. When I open Data Studio, I only see the instance…
Anonymous Coward
  • 479
  • 3
  • 6
  • 10
0
votes
0 answers

IBM Data Studio (Admin client) version 3.1.1

Simple question that I can't find an answer to. I am validating Data Studio (admin version) for use at our site. Most of it looks OK apart from trying to use the wizard to build row value SQL expressions such as Update cmf a set (cftlvl,cfplvl) = …
Mark Sanderson
  • 79
  • 1
  • 5
0
votes
1 answer

db2 explain result about lock size

What is Lock List Size, Maximum Lock List Size and Locks Available in the result of explain using IBM data studio. I read some sources from IBM but can not understand the complete concept and different between those. Please tell any resources about…
Hana Bzh
  • 2,212
  • 3
  • 18
  • 38
0
votes
1 answer

db2 explain stored procedure

How to explain stored procedure in IBM Data Studio? I know that there exist db2expln command. But I want a solution to explain the SP in graphical interface. Also I know that selecting a query and then right clicking on it, there exists open visual…
Hana Bzh
  • 2,212
  • 3
  • 18
  • 38
0
votes
0 answers

Capricious date constants in stored proc call

It prints: The syntax of the string representation of a datetime value is incorrect without a reason, when I try to call a stored proc with DATE parameters from another stored proc. Strange thing, presence or absence of unused variables affects the…
basin
  • 3,949
  • 2
  • 27
  • 63
0
votes
1 answer

Where to find my tables on DB2

I have created a table, but is not listed on DataStudio 4101(tables node) I can insert data by sql commands and drop/create the table, but can not find it on the server Database Node, under tables. Other tables are displayed, but not the new ones I…
user3247097
  • 55
  • 1
  • 5
0
votes
1 answer

SQL compile error trying to load data from .csv

I have a simple SQL query that is suppose to get the data from .csv file and insert or update the data in the table import from /home/AssetAllocation/labels.csv of del insert_update into labels I am trying to run the query in IBM Data Studio but…
Chris Quibell
  • 339
  • 3
  • 4
  • 18
0
votes
1 answer

db2 - already created table still undefined name

Ok, I'm gonna explain the environment so you can understand my problem. I'm using IBM Data Studio to connect and edit my DB2 database which is named [dgsmdb] I connect to the database using the username: dgsmadm & password: password I created a…
Malice Sloth
  • 45
  • 3
  • 12
0
votes
2 answers

Copy / Replace DB2 Table Data from one Remote DB Server to Another

I have two IBM DB2 servers at separate remote locations. I need to copy data from several tables on one database on the first server to another database in the second server. Previously I've used the IBM data studio tool to export the data and…
Debajyoti Das
  • 2,038
  • 4
  • 34
  • 66
0
votes
1 answer

How to view explain plan for a DB2 Stored Procedure in IBM DataStudio?

How to view the access plan for the entire SP along with the cost in IBM DataStudio, I am able to view it for a single query but when I do the same for a Stored Procedure it throws an error.
Shan
  • 521
  • 2
  • 8
  • 28
-1
votes
2 answers

SQL4499N when connecting to DB2 express V10.5 from IBM Data Studio 4.1

Background: I have to transfer VS 2003 and VB6 applications from Windows 7 to a new Windows 10 Home machine. The applications are currently using DB2 9.7, Sql Server or Ms Access via ODBC. I decided to consolidate all dbs to DB2 on the W10 machine,…
WolfWeb28
  • 1
  • 1
-1
votes
3 answers

How can I convert a date format in SQL?

Some recently helped me to find a date with the command shown below, it returns the date in YYYY-MM-DD format, how can I convert that to YYYYMMDD so that I can use it to filter records in my where…
Dan B.
  • 13
  • 4
-1
votes
1 answer

Why I got error SQLCODE=-204, SQLSTATE=42704, DRIVER=4.18.60 in execuing below query

When I run: select * from sys.server_role_members ; got below error: SQLCODE=-204, SQLSTATE=42704, DRIVER=4.18.60
Neeraj Sharma
  • 133
  • 1
  • 13
1 2 3 4 5
6
7