Here is the scenario:
08:00pm Complete backup to disk
midnight Shutdown SAP DB database.
Copy files to backup directory
Startup SAP DB system.
05:30am SAP DB detects that one of the data volumes are bad.
09:00am Shutdown SAP DB database.
Restore files copied at midnight.
At this point, I need to recover the database by applying the log files. In
DB GUI, I start the database in warm mode. I'm given the option to recover
the database from backup but not from the logs. The recovery option is
going back to the 08:00pm backup that was taken. I would like to bypass
this and just apply the logs. Can this be done ? or am I required to
recover the database from the 8:00pm backup and then apply the logs ? Any
help is appreciated.
Glen Case
-----Original Message-----
From: Claus-Thomas Buhl [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 12:32 PM
To: [EMAIL PROTECTED]
Subject: Storing binary data in LONG (BYTE) columns in ESQL/C
I am using the C/C++ precompiler of SAP DB 7.3.0.34 and want
to store binary data in LONG (BYTE) columns.
I have the following ESQL/C code snippet, there are no database errors
at runtime, but the data isn't stored. What am I doing wrong ?
int Update (char * sqlstmt, tparam param[], int nparam) {
EXEC SQL BEGIN DECLARE SECTION;
char * stmt;
char stmtupd[8];
EXEC SQL END DECLARE SECTION;
sqlvartype *ha;
int longcols=0;
stmt = sqlstmt;
EXEC SQL PREPARE stmtupd FROM :stmt;
if (sqlca.sqlcode!=0){return 1;}
EXEC SQL DESCRIBE stmtupd;
if (sqlca.sqlcode!=0){return 1;}
for (i=0;i<nparam;i++){
ha = &sqlda.sqlvar[i];
if (ha->col.colislong) {
SQLLongDesc *ldesc = (SQLLongDesc *)alloca(sizeof(SQLLongDesc));
ldesc->szBuf = param[i].buf;
ldesc->cbBufMax = param[i].size;
ldesc->cbBufLen = param[i].size;
ha->hostvartype=sqlvlongdesc;
ha->hostvaraddr=ldesc;
ha->hostcolsize = sizeof (SQLLongDesc);
ha->collength = sizeof (SQLLongDesc);
longcols = 1;
} else {
...
}
}
EXEC SQL EXECUTE stmtupd USING DESCRIPTOR;
if (sqlca.sqlcode!=0 && sqlca.sqlcode!=100) {return 1;}
if (longcols) {
EXEC SQL PUTVAL stmtupd USING DESCRIPTOR;
if (sqlca.sqlcode!=0 && sqlca.sqlcode!=100){return 1;}
}
return 0;
}
Regards,
CTB
--
_______
\o/|\o/ Claus-Thomas Buhl
| Diplom-Informatiker
\_____/ mailto:[EMAIL PROTECTED]
H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim
Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED]
http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
________________________________________________________________________
This email has been scanned for all known viruses prior to entering the
network.
________________________________________________________________________
________________________________________________________________________
This email has been scanned for all known viruses.
_______________________________________________________________________
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
