IBM Data Studio is an Eclipse-based tool that is the replacement of the DB2® Control Center and other tools for DB2. In conjunction with DB2 Express-C, the no-charge edition of DB2, Data Studio is ideal for DBAs, developers, students, ISVs, or consultants because it’s easy and free to use. You can extend Data Studio with additional robust management and development capabilities from IBM to help accelerate solution delivery, optimize performance, protect data privacy, manage data growth, and more.
Authors: Debra Eaton, Vitor Rodrigues, Manoj K. Sardana, Michael Schenker, Kathryn Zeidenstein & Raul F. Chong
This tutorial will show you how to discover foreign keys and related tables using IBM Data Studio. Before starting, make sure you have selected the Administer Databases in the Activity button. There are two options you can do it. Option 1: Administration Explorer. IBM Data Studio can't browse data on SAMPLE (DB2 Express-C) Your issue is that you are logging in to the command line as Nenad (you can tell that by the default schema), and that you are logging into the DB through DataStudio as db2admin. Posted To: ibm-db2 Conversation: Generate INSERT statements out of data in DB2-tables Subject: Generate INSERT statements out of data in DB2-tables IS it possible to generate INSERT statements out of data in tables?? If you have table employee with the following fields and data:.
Download
This tutorial will show you how to discover foreign keys and related tables using IBM Data Studio.
Before starting, make sure you have selected the Administer Databases in the Activity button.
There are two options you can do it.
Option 1: Administration Explorer
- In Administration Explorer expand the All Databases node and select the appropriate database to expand its objects tree, then select Constraints.
- The upper right pane shows the list of all constraints in the selected database. You can click on the Type column to sort by type, so you can easily find all the foreign keys.
Ibm Data Studio Documentation
Option 2: Using the Pictorial Path
Ibm Data Studio Sql
- In the upper right pane, click on the last icon of the pictorial path to display the list of options, then select Constraints.
- As in the previous section, the upper right pane shows the list of all the constraints in the selected database and you can click on the Type column to sort by name, so you can easily see all the foreign keys.