Running a SQL SELECT statement in USER NAMESPACE to get data from another NAMESPACE

Question

Question

Jimmy Christian · Apr 18, 2019

#SQL #Caché

Hello,

I am trying to run a simple SELECT STATEMENT in USER NAMESPACE.

SELECT * FROM projectname.table

What is the syntax if i need to get data for a table in another namespace eg. SAMPLES., SYS

SELECT * FROM SAMPLES.projectname.table is not working.

Thanks in advance.

Jimmy Christian.

Discussion (9)2

Log in or sign up to continue

Kurro Lopez · Apr 18, 2019

Hi,

You need to map the other Global database into your namespace. This is the only way to have visibility of other database

2 0

score 0 · Answer 1 · 2019-04-18T13:36:00-04:00

Jimmy Christian · Apr 18, 2019

Thank you .

0 0

score 0 · Answer 2 · 2019-04-23T07:05:58-04:00

Be aware that if you're using InterSystems IRIS Community Edition you can't do this.

If you agree with me that InterSystems decision to disable the mapping features in Community Edition should be reversed, please go to https://github.com/intersystems-community/iris-community-edition/issues/2 and +1 this issue.

score 0 · Answer 3 · 2019-04-23T08:02:09-04:00

Jimmy Christian · Apr 23, 2019

Thank you all. At this time, i will not be able to map the USER db to rest of it. But i will try to call support .

0 0

score 0 · Answer 4 · 2019-04-18T13:53:00-04:00

Kurro Lopez · Apr 18, 2019

Please, you have to map the class too. It is into Routine database.

Check previously what is the Global name to map it.

0 0

score 1 · Answer 5 · 2019-04-18T13:54:36-04:00

Eduard Lebedyuk · Apr 18, 2019

You need to map both data global and class package.

1 0

score 0 · Answer 6 · 2019-04-18T14:25:20-04:00

Thank you all. Only reason i have to do it is because i cannot import the csv file data into my table in USER namespace using IMPORT WIZARD. Wizard is not working and throwing CSP error.

I will try and see if i am able to map the class and package. and then run the query i need to extract the data. Thank you

score 0 · Answer 7 · 2019-04-23T00:48:06-04:00

Neerav Verma · Apr 23, 2019

Call support. Its a known bug

0 0

score 0 · Answer 8 · 2019-04-22T16:57:36-04:00

If the C++ binding is installed you could/should be able to use a %RemoteResultSet object to accomplish what you're wanting to do. I've never done so myself so I can't confirm from experience.