Update folder names in WebDocs - iSeries Edition

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

Customer put a space in a folder name and they are running into searching problems with WebDocs - iSeries Edition

Customer gets the following message after using the MOVE option:

Document was moved

User has no document access permissions to this document or the document does not exist. See the WebDocs Administrator for assistance.

Solution:

The following SQL statements can be used to fix an issue where a folder name has a space in it.

For this sample, we're updating a folder name that says: HUMAN RESOURCES to be HUMANRESOURCES

**Note: Be sure to back up or make a copy of the RJSIMAGE library prior to running these SQL statements.

Updating Folder Name if Folder Table

DOCSQL SQLSTM('update docflr00 set docflr1 = HUMANRESOURCES where docflr1 = HUMAN RESOURCES)

Updating Folder User Security Table

DOCSQL SQLSTM('update docsec00 set dfolder1 = HUMANRESOURCES where dfolder1 = HUMAN RESOURCES)

Updating Document Index Table

DOCSQL SQLSTM('update docs00 set folder1 = HUMANRESOURCES where folder1 = HUMAN RESOURCES)

NOTE: The command requires two single quotes not double quotes to run.

NOTE: docflr1, dfolder1, folder1 refer to level one folders. Substitute a "2" for the "1" to change level 2 folders and "3" for level three folders, etc.