Clearing/Repairing WebDocs iSeries folder names

Problem:

Naming folders with forward slashes or spaces cause problems when moving or uploading documents.

Solution:

SQL on the iSeries can be used to take care of this problem. It involves multiple UPDATE statements to the various tables in RJSIMAGE that contain folder information. The examples statements shown here need to be executed several times. Interactive SQL (STRSQL) is probably the best tool for doing this. If it is not available, the DOCSQL command in RJSIMAGE can be used.

Assume that we are looking for a space in a folder name. We will replace the space with a hyphen. To determine the values that need changing, execute the following statement:

select distinct docflr1 from rjsimage/docflr00 where strip(docflr1) like '% %'

This gets you a list of unique level 1 folder names that have a space?the strip() function ensures that we don't match trailing spaces.

DOCFLR1    TAX RETURNS

******** End of data ********

Replace the space with a hyphen with a statement like the following:

update rjsimage/docflr00 set docflr1 = 'TAX-RETURNS' where docflr1 = 'TAX RETURNS'

I recommend executing the 2 statements repeatedly, copying the old value from the results of the SELECT statement and pasting them into the second statement. Fill in the replacement for the space in the SET clause. This has to be done for several tables and columns. The most common are listed below:

Table Name	Column Name
DOCFLR00	
 DOCFLR1
 DOCFLR2
 DOCFLR3
DOCSEC00	
 DFOLDER1
 DFOLDER2
 DFOLDER3
DOCS00	FOLDER1
 FOLDER2
 FOLDER3

The less common ones are now listed:

Table Name	Column Name
DOCS00	RFOLDER1
 RFOLDER2
 RFOLDER3
DOCSES00	
 SFOLDER1
 SFOLDER2
 SFOLDER3
DOCROUT00	
 RFOLDER1
 RFOLDER2
 RFOLDER3
DOCWEB	D1
 D2
 D3