Hi Dave, nice tip ! That is exactly what I was looking for.
Thanks, Itamar "David Van De Griek" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > 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 > > > >
