----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 30, 2003 4:54 PM Subject: sapdb.general digest, Vol 1 #1435 - 3 msgs
> Send sapdb.general mailing list submissions to > [EMAIL PROTECTED] > > To subscribe or unsubscribe via the World Wide Web, visit > http://listserv.sap.com/mailman/listinfo/sapdb.general > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of sapdb.general digest..." > > > Today's Topics: > > 1. RE: Need Help: Cursor operation conflict with Prepared UPDATE sta tement (J. Jeff Roberts) > 2. Backup and Restore question ([EMAIL PROTECTED]) > 3. Query (Very Urgent) (jain cj) > > --__--__-- > > Message: 1 > Date: Fri, 29 Aug 2003 06:21:22 -0700 (PDT) > From: "J. Jeff Roberts" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Subject: RE: Need Help: Cursor operation conflict with Prepared UPDATE sta tement > To: "Zabach, Elke" <[EMAIL PROTECTED]>, > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > > Thanks for the extra pair of eyes. That was indeed most of the > problem. > > Thanks, > -Jeff > > --- "Zabach, Elke" <[EMAIL PROTECTED]> wrote: > > J. Jeff Roberts wrote > > > > > > > > I'm trying to create a prepared statement for the following update: > > > > > > UPDATE jobhistory SET status=6 WHERE id = '3D1065E0_00001000' > > > > > > The SQL I send to SQLPrepare() looks like this: > > > > > > UPDATE jobhistory SET status=? WHERE id = '?' > > > > ? do mean a placeholder for a variable, right? > > But why do you surround the second placeholder with ' ' ? > > Then the database server will not see the placeholder, but a string > > with > > exactly one question-mark in > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > --__--__-- > > Message: 2 > From: [EMAIL PROTECTED] > Date: Fri, 29 Aug 2003 15:36:13 -0400 > To: [EMAIL PROTECTED] > Subject: Backup and Restore question > > Hi, > > I am trying to do a backup and restore on one of my database instances. What I am essentially trying to do is move the database from one server to another by doing backup/restore. But first, I am just testing all this stuff on one server to see if/how it works. I am trying to do a complete data backup using the media type file. Here are the commands I am executing and the resulting message: > ./dbmcli -d TST74 -u dbm,dbm medium_put newbackup /home/sapdb/backup082903 FILE DATA 0 8 YES > > ./dbmcli -d TST74 -u dbm,dbm -uUTL -c backup_start newbackup > > Returncode 0 > Date 20030829 > Time 00115941 > Server sapdb.abt.net > Database TST74 > Kernel Version Kernel 7.4.3 Build 027-121-048-452 > Pages Transferred 248 > Pages Left 0 > Volumes 1 > Medianame newbackup > Location /home/sapdb/backup082903 > Errortext > Label DAT_00019 > Is Consistent true > First LOG Page 1077 > Last LOG Page > DB Stamp 1 Date 20030829 > DB Stamp 1 Time 00115941 > DB Stamp 2 Date > DB Stamp 2 Time > Page Count 225 > Devices Used 1 > Database ID sapdb.abt.net:TST74_20030820_134838 > Max Used Data Page 0 > > By the way, I AM doing all this with a utility connection. I believe that the backup is successful. However, I am having problems with the restore. What exact command has to be executed in order to restore this database instance and how can one check if the restore was done successfully? I tried the following command, however as you will afterward, the "Location" points to the datasave file which is not the file I wanted to restore: > ./dbmcli on TST74>recover_start DATA > OK > Returncode 0 > Date 20030829 > Time 00134152 > Server sapdb.abt.net > Database TST74 > Kernel Version Kernel 7.4.3 Build 027-121-048-452 > Pages Transferred 248 > Pages Left 0 > Volumes 1 > Medianame data > Location /home/sapdb/TST74/datasave > Errortext > Label DAT_00009 > Is Consistent true > First LOG Page 1057 > Last LOG Page > DB Stamp 1 Date 20030825 > DB Stamp 1 Time 00173710 > DB Stamp 2 Date > DB Stamp 2 Time > Page Count 225 > Devices Used 1 > Database ID sapdb.abt.net:TST74_20030820_134838 > Max Used Data Page 0 > > > Sorry for the long email but I am fairly new to both sap and linux and would appreciate any help/suggestions concerning this matter. Thank you in advance. > > Regards, > J. Simoni > > --__--__-- > > Message: 3 > From: "jain cj" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Query (Very Urgent) > Date: Sat, 30 Aug 2003 05:45:26 +0000 > > hI, > > I am not able to run a query(correlations) like this > > ********************************************************* > Table Name Primary key > ---------------- ----------- > SI_Accounts acct accountid > SI_ActiveUnavailableFund_v accountid, serialno > > > > > > > SELECT > acct.accountId, (acct.acctbalance - (Select sum(Amount) from > SI_ActiveUnavailableFund_v where AccountId = acct.AccountId)) Balance from > SI_Accounts acct > > ********************************************************* > > It could successfully running in oracle. but when I converted into sapdb it > throws an error like > > > getting an error like > > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > General error;-7011 POS(51) Correlated subquery not allowed. > SELECT > acct.accountId, (acct.acctbalance - (Select sum(Amount) from > SI_ActiveUnavailableFund_v where AccountId = acct.AccountId)) b from > SI_Accounts acct > -------------------------------------------------------------------------- ----------- > > > What I can do for running the query. > Please help ---Very urgent..... > > _________________________________________________________________ > Design your own holidays. Make memories that last a lifetime. > http://www.flexihols.com/2003/index.php Enjoy! > > > > --__--__-- > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > End of sapdb.general Digest > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
