Procfile reverts to original after a program that does a connect database.
Minor
Closed - Fixed
Found:XS.01.07 18 MAR 2008
Fixed:XS.01.08 20 MAR 2008
DETAILS
With this program it writes the database's procfile on the write [dsn("PROCFILE")] but
after the program has finished the PROCFILE attribute (and default procfile) reverts to
sirproc.srp. If you uncomment the two lines then the procfile does not revert to
sirproc. I also tried an execute dbms "CONNECT DATABASE..." and this had the same effect
as the PQL CONNECT DATABASE.
EXAMPLE PROGRAM
program
PQL CONNECT DATABASE "COMPANY"
SECURITY "COMPANY","HIGH","HIGH"
IOSTAT rc
write [dsn("PROCFILE")]
c execute dbms "set procfile sir014"
c write [dsn("PROCFILE")]
end program
WORKAROUND
Use the SET PROCFILE code commented out in the above example