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
1
vote
1 answer

Execute LIST HISTORY in IBM Data Studio

How can I execute the DB2 command LIST HISTORY in IBM Database Studio?
Chief Peter
  • 343
  • 5
  • 11
1
vote
2 answers

How can I deploy a DB2 stored procedure which writes to a table that does not yet exist (but will by the time it does so)?

As you would most likely have deduced from the following question, I am new to DB2 in general. I am attempting to write my second ever stored procedure using IBM Data Studio and am running into an error when trying to deploy it. The point of the…
dpberry178
  • 558
  • 6
  • 21
1
vote
1 answer

DataStudio holds connections to DB2 database

I run my queries on DB2 Datastudio. I start with "connect"ing to the database... and over a period of time.. say, I run 100+ queries on the same connection over multiple days. On the database side, we see 100+ connections coming from me. I don't…
Aravind Datta
  • 327
  • 4
  • 6
  • 17
1
vote
1 answer

What is the shortcut to run single sql in IBM Data Studio (Equivalent of F9 in Toad)

I am new to IBM Datastudio (DB2) and my experience is on sql Developer and Toad. I tried F5, it runs all the sqls, but i would like to run one specific sql only.
lrathod
  • 1,094
  • 1
  • 9
  • 17
1
vote
2 answers

Keyboard Hotkey for comment lines in DataStudio?

I was searching on internet, but zero results. Anyone knows? I'm using IBM DataStudio 4.1.1. Regards.
DormantDemon
  • 57
  • 1
  • 8
1
vote
1 answer

IBM Data Studio Admin Client 3.1.1

I have a simple IBM Data Studio issue which I can't find an answer to. I have to say the online resource and general documentation for this product is very poor. Anyway, I have noticed in my installation that the run SQL button in the SQL editor…
1
vote
1 answer

Visualizing data model using data Studio 4.1

I want to generate ER - Diagram for existing database. I created .dbm file but in diagram I see only table names all in a row. I am not able to see columns and relationship between tables. How can i see ER- diagram.
Vipin
  • 4,851
  • 3
  • 35
  • 65
1
vote
2 answers

Cannot connect IBM data studio with DB2 Express-C (Error: User Id Revoked)

I have installed following software in the order: 1. IBM DB2 Express C version 10.5.1 2. IBM Data Studio version 4.1.0.1 I am having local admin rights. I have installed both above software using my corporate domain account…
Bharat Mori
  • 363
  • 1
  • 5
  • 14
1
vote
3 answers

IBM DB2 "Administrator" does not have the privilege to perform "Select"

I've been testing a software I helped develop, which resides on a 32-bit application server. It is to connect to a 64-bit database server, which uses IBM DB2 v10.1. I was the one to setup the DB2, but I'm pretty sure it has since been modified; I am…
zack_falcon
  • 4,186
  • 20
  • 62
  • 108
0
votes
0 answers

Can I connect via OBDC to database in IBM Data Studio?

Is there a way to connect to my IBM AS/400 Database using ODBC in IBM Data Studio? It seems as though IBM Data studio is limited to JDBC connections which is not compatible with our server. I tried to conenct to our database using the JDBC AS/400…
wleonard
  • 1
  • 1
0
votes
0 answers

Cannot get the describe information for the calling stored procedure

I am trying to call a DB2 stored procedure from a java application and getting the error below: Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10453][12711][4.22.29] Cannot get the describe information for the calling stored procedure with name…
ssubas
  • 1
  • 1
0
votes
0 answers

Data studio ibm simple gui

i am writting on java in data studuo ibm. I want to build a gui but can't find the option in platform.if someone know where can i find a window builder on a platfom.
Irenan
  • 1
0
votes
1 answer

Are IntelliSense features available in Data Studio?

Does IBM Data Studio have IntelliSense features or Intelligent code completion something like below? I would like to write an SQL query with IntelliSense type functionality. I have IBM Data Studio 4.1.3
dtc348
  • 309
  • 6
  • 19
0
votes
0 answers

SQL Query Not Writing File

I am running the following query in IBM data studio but it does not write the file to my library, it errors out without a description of the error. Can anyone help, is there something wrong with my syntax? DROP TABLE IF EXISTS DANBLIB/FILE1; CREATE…
Dan B.
  • 13
  • 4
0
votes
3 answers

Selecting all data from a table where it is the first of the month

I am using Data Studio to query a large table in a relational database. I am attempting to get all of the data where a certain column with the data type of DATE is the first of the month. The dates in the columns range from about 1990 to 2023 and…