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

Temp table for user defined functions

I am trying to use temp table in user defined function for DB2. I am trying to do this in data studio but the code below is not working. How can I make this work? Thanks. CREATE FUNCTION BELSIZE.TEST (aSTRING VARCHAR(50)) RETURNS TABLE( column1…
VN Khan
  • 21
  • 7
-1
votes
2 answers

Converting from lower to upper case in Sql Editor in Data Studio

What keyboard shortcut can I use to switch from lower to upper case and upper to lower case in Sql Editor in Data Studio LUW ?
Ina
  • 1
  • 2
-1
votes
1 answer

DB2 Linux to Windows Migration

We have a RHEL server running DB2 with one failing hard drive that is several years out of support. I've been tasked with migrating DB2 to a newer Windows server. What is the easiest way to do this? Is it possible to take a backup of the entire…
reakt
  • 500
  • 8
  • 25
-1
votes
1 answer

unable to create a database connection using Aqua Data Studio ETL tool

When try to connect to DB2 Z/OS, the following error message is displayed, [jcc][t4][10509][13454][3.67.28] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS…
-2
votes
1 answer

Alternative to IBM Data Studio

I use IBM Data Studio (4.1.3 and 4.1.4) to develop stored procedures (native) and functions on DB2 Z/OS (V12) and DB2 LUW. Unfortunately Data Studio is slow and keeps crashing. Do you know valid alternatives that can be used on both Z / OS and LUW…
1 2 3 4 5 6
7