Aaron Grady [MSFT]
Guest
|
 Posted:
Thu Mar 24, 2005 10:48 pm Post subject:
Re: msdb2 Default schema not used |
|
|
Krijn-
Correct, default schema is only used for schema queries. If you want to
qualify tables, you need to use the new default qualifier property which is
available in HIS 2004. From the connection string below it looks like you
probably are using HIS 2004 already, so you'll just need to start using this
property.
NOTE: Default qualifier only works with certain DB2 levels. There is a chart
in the InstallationGuide.htm file on the HIS 2004 CD that shows you which
versions of DB2 support this new property.
HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Krijn Michiels" <Krijn Michiels@discussions.microsoft.com> wrote in message
news:89A2EA0A-7BC1-4880-89A3-B8AB89D9DDA9@microsoft.com...
| Quote: | Looks like the default schema property in the connectionstring is not used
when executing msdb2commands. The query's are always executed in the
connected user schema.
Example :
connectionstring :
[oledb]
; Everything after this line is an OLE DB initstring
Provider=DB2OLEDB;Password=xxxx;Persist Security Info=True;User
ID=USERNAME;Initial Catalog=RDBREM;Data Source=xxxx;Network Transport
Library=TCPIP;Host CCSID=500;PC Code Page=1252;Network Address=xxx;Network
Port=446;Package Collection=MYSCHEMA;Default Schema=MYSCHEMA;DBMS
Platform=DB2/AS400;Process Binary as Character=False;Connection
Pooling=False;Units of Work=RUW
All query's - SELECT * FROM TABLE - are executed like SELECT * FROM
USER.TABLE instead of SELECT * FROM MYSCHEMA.TABLE
Any solutions ? |
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in