Moving or Purging Expired Documents in WebDocs iSeries Version 3.14 or Later
In Webdocs iSeries version 3.14 and above, you can use the DOCEXPPRG command to either:
- Move all expired documents to a folder that you specify.
- Purge all expired documents from WebDocs.
To move expired documents to a folder that you specify:
- On a command line, type DOCEXPPRG and press F4.
- Type the folder that you want to move the expired documents to.
Note: This folder must be defined in WebDocs. RJS Software recommends that you use a folder that is not visible in the web interface - in other words, that no one has access privileges to this folder.
- In Do you really want to run 1, choose *YES.
- In Do you really want to run 2, choose *YES.
- Press Enter.
The expired documents are moved.
To purge expired documents from WebDocs:
Warning: Expired documents that you purge from WebDocs are permanently deleted.
- On a command line, type DOCEXPPRG and press F4.
- Type the folder that you want to move the expired documents to.
Note: This folder must be defined in WebDocs. RJS Software recommends that you use a folder that is not visible in the web interface - in other words, that no one has access privileges to this folder.
- In Do you really want to run 1, choose *YES.
- In Do you really want to run 2, choose *YES.
- In Perm dlt from move to folder 1, choose *YES.
- In Perm dlt from move to folder 2, choose *YES.
- Press Enter.
The expired documents are purged.
Moving or Purging Expired Documents in WebDocs iSeries Version 3.13 and Earlier
The following three commands move all expired documents to a folder named EXPIRED and then purge all files and records pertaining to the documents from the system.
Warning: Always back up the file you are planning to update prior to running a SQL update command.
- (Optional) Review the documents that will be purged:
SELECT * FROM RJSIMAGE/DOCS00 WHERE EXPDATE < CURRENT TIMESTAMP
- Move expired documents from their current folders in WebDocs to the EXPIRED folder:
Note: This folder does not need to be defined in WebDocs. If it is defined, RJS Software recommends that you use a folder that is not visible in the web interface - in other words, that no one has access privileges to this folder.
UPDATE RJSIMAGE/DOCS00 SET FOLDER1 = 'EXPIRED', FOLDER2 = '', FOLDER3 = '', FOLDER4 = '', FOLDER5 = '' WHERE EXPDATE < CURRENT TIMESTAMP
- Purge all documents that are in the EXPIRED folder, including IFS files and related databases records:
Note: This command does not check that the folder is actually defined in WebDocs.
DOCCLRFLR FOLDERLVL1('EXPIRED') CONFIRM1(*YES) CONFIRM2(*YES)
Last Modified On:
No, open a new Support Case