Increase Size of Operation Code Field

WOW allows approximately 5000 characters for the SQL text or operation code which is sufficient for the majority of operations. If more space/characters are needed, the following SQL statements can be executed against the WOW metadata.

NOTE: When installing an upgrade, these steps may need to be repeated for each targeted metadata library:

Below is an example for changing the length of the SQL statement field to 10000:

1) Increase validation size allowed for field:

• • update pjsys70.fielddata set column_size = 10000 where id = -923

2) Increase size of field (assumes your user library is PJUSER64). Use the statement that matches your DB:

For AS/400 based metadata:

• • alter table pjuser70.sqlops alter column lvsqlqry set data type varchar(10000) /* AS400 */

For MYSQL based metadata:

• • alter table pjuser70.sqlops modify column lvsqlqry varchar(10000) /* MySQL */

3) Restart your Tomcat or Application Server.

NOTE: Change PJUSER70 to your specific WOW user library or project schema. For various releases, change 70 to your targeted release.

TAGS: Change size of sql operation, Longer SQL, SQL too short, Need more room for SQL, Increase operation size