How to Make a Report File on the Strings/Messages

Previous Next

To make a report file on the strings:

1. From the menu bar, choose Tools, SQL Command.

The SQL Command window appears.

2. Type the following code in the SQL Statement field:

set reportFile StringReport.txt

SELECT u.STR_CODE

    , u.TXT_STR

    , l.LNG_TXT_STR

FROM T_APP_USED_STR u

    , T_APP_LNG_STR l

WHERE u.STR_CODE = l.STR_CODE

AND l.LNG_CODE = 'HEB'

3. When you are finished, click Execute to execute your script.

By default, the report file is created in the APP subdirectory of your USoft installation directory. You can also specify the directory in which this file should be created, as follows:

4. set reportFile C:\StrMes\StringReport.txt

To make a report file on the messages:

1. From the menu bar, choose Tools, SQL Command.

The SQL Command window appears.

2. Type the following code in the SQL Statement field:

set reportFile MessageReport.txt

SELECT S.MSG_CODE

    , S.SYS_MSG

    , L.LNG_SYS_MSG

FROM T_SYS_MSG S

    , T_SYS_MSG_LNG L

WHERE S.MSG_CODE = L.MSG_CODE

AND L.LNG_CODE = 'HEB'

3. When you are finished, click Execute to execute your script.

By default, the report file is created in the APP subdirectory of your USoft installation directory. You can also specify the directory in which this file should be created, as follows:

set reportFile C:\StrMes\MessageReport.txt