Itamar,
Yes, there is a way. You have to set up a package<->schema mapping in the Package definition.
Create the following entry in the %Library.PackageDefinition class in the namespace you want this mapping in:
USER>Set oref=##class(%Library.PackageDefinition).%New("%Lib")
(The argument to %New is the name of the package you want to define)USER>s oref.SQLName="Lib"
USER>w oref.%Save() 1
Now any classes in the '%Lib' package that project SQL tables, views, and procedures will project them to the 'Lib' schema.
In Cach� 5.1, there will be Package Information interface in Studio to manage this.
Hope this helps,
-dave
Itamar wrote:
Hi,
is there anyway to change default SQL schema projection in Cach�. That is:
Class: %Lib.Table SQL table: Lib.Table
???
TIA,
Itamar
