Get SQL Instance from X3

Question

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.

Delamater · Accepted 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()

Sage X3

Get SQL Instance from X3

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING