Uniface on GitHub
Fixes and Updates
We are planning to migrate from SYBASE to MSS. In Sybase we have multiple databases which are actually 1 database. They are more sort of schema.
Example we have loans in the database LNNG with table name e_lening But also we have customers in the database HYBO, table name e_klant in the asn we all fix this.
But now for MMS we want to make 2 schema's LNNG and HYBO (also Uniface models are called LNNG and HYBO)
So the select wil be:
select nr_lnng from LNNG.e_lening
select nr_klnt from HYBO.e_klant
But Uniface translate this to:
select nr_lnng from lnng.e_lening
In the asn file we have
$LNNG = mss: etc etc
LNNG $LNNG:LNNG. *.*
How to solve this? We can set is in lower or in uppercase but not like this...
Hi PaulMS-SQL is (normaly) case insensitive, so a object "LNNG" is the same then "lnng"
I think you are looking MSS Connector option "entity names".
Keep in mind it should be used together with "identifiers" option.
Please see details in documentation:
I did more tests with "entity names" and "identifiers" MSS Connector options.
USYS$MSS_PARAMS = isolation=read uncommitted, entity names=upper, identifiers=quoted
Below log created by Uniface:
Without these options:
USYS$MSS_PARAMS = isolation=read uncommitted
With these options:
One more remark, even if a table created with these options, when you return back to use without these options, below statement executed:
And you get correct data from correct table.
You can see MSS tables have been created below:
I hope this is helpful for you.
© 2020 Uniface Privacy & Cookies | Privacy Statement | Legal