REM Script Created September 14, 2001 by Peter Duncan
REM Intended to spool DML statements to change vault host and path 
REM User will have to supply desired host and path and run the output script from a SQL*Plus or Server Manager prompt


set pages 0
set lines 150
set feedback off

spool update_vaults.sql
PROMPT
PROMPT REM Change the hostname and port number as appropriate below
PROMPT
select 'update pdm.pdm_fileserver set FSVHOST='||''''||FSVHOST||''''||',FSVPORT='||''''||FSVPORT||''''||' where FSVID='||FSVID||';'
FROM PDM.PDM_FILESERVER
/

PROMPT
PROMPT REM Change the hostname and vault path as appropriate below
PROMPT
select 'update pdm.pdm_pool set POOLHOST='||''''||POOLHOST||''''||',POOLPATH='||''''||POOLPATH||''''||' where POOLID='||POOLID||';'
FROM PDM.PDM_POOL
/
spool off;

set feedback on
set pages 1000