Re: sapdb.general digest, Vol 1 #1435 - 3 msgs

----- 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
>