Before you decide to rollback from MR2 to MR1, Cognos Support told us that the Content Manager database is changed and you can't rollback without restoring the Content Manager database. We were too deep into development after installing MR2 to go back to MR1.
We also found out from Cognos...
Fool-proof is difficult because Fools are innately ingenious.
Use SQL Server's Linked Server service. It is as rock solid as the database odbc or ole provider is. If the Linked Server becomes hosed, which doesn't happen very often, rebuilding it with the same names will have no code impact...
I use Win2K, so adjust to Unix accordingly.
Start cmd.exe you must. Change to the directory where your script is. If myscript.sql is in C:\ddl be in this directory when you enter the command bteq
.logon yada/yada
--Then run your script--
.run file=myscript.sql;
That's all there is to it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.