To store strings in a database, use OpenROAD to add them to a table. OpenROAD automatically creates a special string storage table, called ii_stored_strings. However, you can create your own storage table if you want to improve distribution of the strings in the database and avoid transaction bottlenecks (see How You Can Create a String Storage Table (see How You Can Create a String Storage Table)).

Each string in the storage table is associated with a handle, called a DBHandle, which you use to access the string. For example, to display a string stored in the database, set the value of the DBHandle attribute to the DBHandle for that string. OpenROAD then displays the string that is associated with that particular DBHandle. You must store the DBHandles for the strings in a separate table from the strings themselves.

The strings that you load into the database can come from text files, from the user (who enters them into multiline entry fields), or from StringObject variables in your 4GL code.