String concatenation utility

String concatenation lets you merge up to 8 simple strings into a new long text field (long string data type). Long text fields have two sub categories - medium long and large long. Medium long can support a text size up to 32KB.

To concatenate simple strings, the fields must be unencrypted. After you use the concatenation utility, you can encrypt the new long text field.

You must log in as an administrator to perform string concatenation. You can use any system with access to SQL*Plus that can connect to the IBM® OpenPages® with Watson™ database server.

String concatenation is a database operation. A SQL template file is provided to specify parameters for the action. For more information, see Running string concatenation.

For more information on long text fields, see Long string fields .