1
0
-1

Hello,


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...


Regards


Paul Koldijk


    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Paul

      MS-SQL is (normaly) case insensitive, so a object "LNNG" is the same then "lnng"

      Regards Ingo

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi Paul

        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:

        Best regards

        Burak

        1. Burak Yuksel

          Hi 

          I did more tests with "entity names" and "identifiers" MSS Connector options. 

          With options: 

          [DRIVER_SETTINGS]
          MSS U5.0
          USYS$MSS_PARAMS = isolation=read uncommitted, entity names=upper, identifiers=quoted

          Below log created by Uniface:

          select [KEYFIELD],[FIELD]
          from [UENTDB_1]

          Without these options: 

          [DRIVER_SETTINGS]
          MSS U5.0
          USYS$MSS_PARAMS = isolation=read uncommitted

          Below log created by Uniface:

          With these options:

          select keyfield,field
          from uentdb_2

          One more remark, even if a table created with these options, when you return back to use without these options, below statement executed: 

          select keyfield,field
          from uentdb_1

          And you get correct data from correct table. 

          You can see MSS tables have been created below:

          I hope this is helpful for you. 

          Best regards

          Burak

        CommentAdd your comment...