MQSeries.net :: View topic - IIB9: Physical Data Model / View / MSSQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB9: Physical Data Model / View / MSSQL

IIB9: Physical Data Model / View / MSSQL

« View previous topic :: View next topic »

Author

Message

akil

Posted: Fri Aug 29, 2014 6:48 am Post subject: IIB9: Physical Data Model / View / MSSQL

Partisan

Joined: 27 May 2014
Posts: 338
Location: Mumbai

Hi

I think a view that accesses tables across multiple databases is not supported in the physical data model. This makes using views in the GDM a bit tricky ..

My Database Engine : Microsoft SQL Server, 2008
Database Name: finesb
Schema Name: dbo

View DDL in the database (the table is in another database called contact admin, and under that a schema dbo)

Code:

create view testing_view as select * from contact admin.dbo.RCDSLOANS

I tried a couple of things,

1. Reverse Engineer:
This just skips this kind of view, all other objects get created, but the view is not present.

2. Hand creating by 'Add Data Object' --> 'View'
I type the following query

Code:

select * from contact admin.dbo.RCDSLOANS

I get "The SQL statement could not be parsed".
( I already have the database definition for contact admin in the same database project ).

3. Hand create by first adding a dependency 'Add Data Object' --> 'Dependency'

While I can create a dependency to a table in another database/schema, I am unable to use that in the view. I get an error 'Cannot find table'

Is there another way that I could try?
_________________
Regards

akil

Posted: Fri Aug 29, 2014 6:50 am Post subject:

Partisan

Joined: 27 May 2014
Posts: 338
Location: Mumbai

The database name is 'contact admin' for some reason it gets changed to 'contact admin' when I post ..
_________________
Regards

mqjeff

Posted: Fri Aug 29, 2014 7:03 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

You probably need to open a PMR.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB9: Physical Data Model / View / MSSQL

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP