IBM Data Studio Table name issue

Question

When I create a new SQL script , for example

select * from table

When I execute this the sql that gets ran is

SELECT * FROM MYNAME.TABLE

I understand DB2 does this , but I want the schema name to be concatenated onto the table names, not my username.

SELECT * FROM SCHEMANAME.TABLE

It did this for me before, but I dont know what changed that it now only puts the database username at the end of the tables.

Does anyone know how to set it so the schema name gets added on?

It's not clear what you're asking. Are you asking that the schema name be `added into` your script? Or do you want your script to _run against_ your desired schema when that schema name doesn't match your username? — user2338816, Oct 07 '16 at 14:01

Mustafa DOGRU · Answer 1 · 2016-10-05T14:36:44.140

0

Could you try this;

In Data Project Explorer,

right clicked, properties
Driver properties
type your schema in Default schema
disconnect and reconnect database;

and try without SCHEMANAME.

edited Oct 05 '16 at 14:36

answered Oct 05 '16 at 14:24

Mustafa DOGRU

3,994
1
16
24

score 0 · Answer 2 · answered Oct 05 '16 at 14:30

0

Schema name defaults to your authorisation ID (user name in most cases). To use a different name to qualify unqualified object names, set the special register CURRENT_SCHEMA appropriately:

SET SCHEMA whatever

answered Oct 05 '16 at 14:30

mustaccio

18,234
16
48
57

score 0 · Accepted Answer · answered Oct 05 '16 at 16:54

0

Best way in my eyes for Data Stuio is setting the special register "Current schema" on the Special Registers tab of the SQL Editor. Here is a screenshot

answered Oct 05 '16 at 16:54

MichaelTiefenbacher

3,805
2
11
17

IBM Data Studio Table name issue

3 Answers3