Get SQL Instance from X3

SOLVED

If I am logged into Sage X3, does anybody know how I can determine which SQL instance X3 is using?  I thought it was in the Administration section, but I can't seem to find it.  This is on V12.

Parents
  • +1
    verified answer

    From the UI you can use TRTPROP (All > Development > Utilities > Verifications > Database > Properties on a standard menu). This function will derive either Oracle or SQL Server and show the correct screen for you. Then you will see the Machine and Instance name there. 

    If you need it from within the 4GL code you can call ORDSYS.GET_SQL_SERVER_INSTANCE_NAME()

Reply
  • +1
    verified answer

    From the UI you can use TRTPROP (All > Development > Utilities > Verifications > Database > Properties on a standard menu). This function will derive either Oracle or SQL Server and show the correct screen for you. Then you will see the Machine and Instance name there. 

    If you need it from within the 4GL code you can call ORDSYS.GET_SQL_SERVER_INSTANCE_NAME()

Children