Hi Ajit, [ajit_cus wrote]
> Subject: Sap setup > > The problem with the docs is that they don't seem to be written > for people new to SAPDB (Once u've worked with SAPDB for a while > they're a useful reference). The info in the docs is not in the > sequence a new user will need them in. > Also solutions to some common problems are not in the docs > (Atleast I haven't found them) > I partially agree and we'll change the doc for Replication Manager (will be released in the beginning of the next year) and include more HOWTOs which cover the real needs of users (hopefully). > How do you use repmcli to execute a sql file in SQLMODE oracle? > This is quite simple and I thought it would become clear from the documentation. But I was obviously wrong in that. So simply place a command SQLMODE ORACLE // <lots of commands may follow> at the beginning of the file thats feeded to repmcli and all subsequent commands will be processed in that SQLMODE. To reset it you need another SQLMODE INTERNAL command at the place where ORACLE is not longer needed. > creating DBPROCS in repmcli?-->;; > This depends on the version you run. If it is 7.3.00.29 you may simply remove the second semicolon from the CREATE DBPROC-command. The second semicolon at the end of a CREATE DBPROC-command if running it with Replication Manager is a relic from the past where we had semicolon as command delimiters (thats really long long ago :-)). In versions before ...29 you need the second semicolon because of some dead code still in there (sorry). The change that comes together with that in ...29 is that the only allowed command separator in files for repmcli is now a double slash at the beginning of a row. HTH and sorry for any inconvenience Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
