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
