Naming folders with forward slashes or spaces cause problems when moving or uploading documents.
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
Still have questions? We can help. Submit a case to Technical Support.