Back to SPR List Previous Next
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
Back to SPR List Previous Next