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
8
votes
1 answer

Simple way to run SQL queries in IBM Data Studio

How can I run a simple query like: select current timestamp from sysibm.sysdummy1 In the old "Command Center" if was simply able to run such a command without creating a script/project, using a query builder etc.. However the old command center was…
Udo Held
  • 12,314
  • 11
  • 67
  • 93
4
votes
1 answer

Where can i see the output of DBMS_OUTPUT.PUT_LINE() in IBM Data Studio?

I am using IBM Data Studio as Development environment, CREATE OR REPLACE PROCEDURE TEST() is BEGIN DBMS_OUTPUT.PUT_LINE("Hi there."); END; I can see in execution details like time, exception if any, other info in SQL Results window. Is IBM…
leo_roar_001
  • 181
  • 1
  • 10
4
votes
2 answers

How to execute compound sql in DB2

I am facing a challenge trying to understand DB2 sql (note, I am coming from MS SQL Server) :P. Here is a scenario, I have got 2 tables one has IDs and other details, second one has lot of other info corresponding to each ID. ID Info…
Abhinav
  • 2,085
  • 1
  • 18
  • 31
4
votes
1 answer

Bundling Java libraries with a DB2 Java stored procedure

Creating a DB2 Java stored procedure using IBM Data Studio, I have some libraries that are required in the classpath. I'm running Data Studio in a VM, and deploying remotely to my DB2 server in a Cloud instance. How do I bundle up the jars with my…
Marius Butuc
  • 17,781
  • 22
  • 77
  • 111
3
votes
3 answers

IBM Data Studio - Run SQL Shortcut

Is there any shortcut for the command "Run SQL" in IBM Data Studio Developer 2.1?
Vasilen Donchev
  • 975
  • 4
  • 14
  • 26
3
votes
2 answers

'Load Property...' An internal error has occured. java.lang.StackOverfrlowError

I cannot ALTER table in Data Studio for last few days.. Nothing really was updated (I guess it is Eclipse environment error). Any ideas what's going on? Note: it happens when I do right-click on the table then select Alter. But it happens only to…
VladP
  • 881
  • 2
  • 13
  • 37
3
votes
3 answers

Increasing SQL result column limit on IBM Data Studio

I'm using IBM Data Studio when I browse down to the columns in a table using the data source explorer it is limiting the number of columns it shows. I don't think it is not a permissions problem as the same credentials work in a different…
user195166
  • 417
  • 5
  • 16
3
votes
2 answers

IBM Data Studio can't browse data on SAMPLE (DB2 Express-C)

I can't browse data on SAMPLE DB. Setup is as follows: - Windows 7 64 bit PRO, - IBM DB2 Express-C, 10.5.500.107 (latest) - IBM Data Studio Version 4.1.1 (Administrative installation, Installed using IBM Installation Manager 1.8.1) Database…
Nenad Bulatović
  • 7,238
  • 14
  • 83
  • 113
3
votes
1 answer

How to create a new schema on a database at IBM Data Studio?

I am trying to create a new schema on a database that I created at IBM Data Studio but I get error: "DB2ADMIN" does not have the privilege to perform operation "CREATE SCHEMA".. SQLCODE=-552, SQLSTATE=42502, DRIVER=3.67.28. How can I do it on…
furbymely
  • 33
  • 1
  • 5
3
votes
1 answer

Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884

I am getting below error when calling stored procedure written in IBM DB2 from my Worklight SQLAdapter Invocation Result of procedure: 'track_ReqByMob_No' from the Worklight Server: { "errors": [ "Runtime: Failed to retrieve data with…
Ravi Yadav
  • 405
  • 4
  • 16
2
votes
1 answer

How to make F5 shortcut key to run query on IBM Data Studio 4.1.1?

F5 is shortcut to refresh on IBM Data Studio 4.1.1. How to make F5 shortcut to run SQL query?
Vijaydev Ramdev
  • 21
  • 2
2
votes
1 answer

Data stage parallel job export options

I am aware that in Datastage the parallel jobs (.pjb) or any other jobs can be exported to .dsx and .isx files. I wondered if I can simply export a .pjb file as is ?
dna
  • 483
  • 3
  • 10
  • 32
2
votes
1 answer

IBM Data Studio Connection error SQL1035N

I have been searching in IBM forums/documentation, Google, and StackOverflow topics about this error, but I can't manage to find the solution. Situation Installed DB2 for test and education purposes, since I'm a student and I have to do a manual…
Jesus Gonzalez
  • 411
  • 6
  • 17
2
votes
2 answers

Exporting Data - IBM Data Studio DB2

I am trying to export a large query from a DB2 database to a text file on my desktop using IBM Data Studio and I can't seem to get anything to work. When I run the query and right click on the results tab->Export->All Results it only gives me the…
user1723699
  • 1,031
  • 6
  • 13
  • 27
2
votes
1 answer

IBM data studio not connecting to local DB2 databases

I have installed DB2 10.5 version on my local Ubuntu 12.04 Machine. Now i need a GUI. I already tried squirrel-sql & Db-Visualizer. While Db-Visualizer give me the view-only database structure, squirrel-sql give me some more options to manage. But…
kuldeep.kamboj
  • 2,566
  • 3
  • 26
  • 63
1
2 3 4 5 6 7