 | | | MaxDB | | Dear list
To prevent a division by zero
i examine the divisor for zero.
INSERT INTO "TEMP ". "TABLE2 "
(COLUMN1)
SELECT
CASE
WHEN SOURCECOL 0 THEN 0
WHEN SOURCECOL < > 0 THEN Hi Filip
I assume that your LogVolume has never been really created.
Please change the recovery command for the first data-backup
to
DB_ACTIVATE RECOVER <data-backup-mediumname >
kind regarHi John
if you 'v lost your data and have to recover a databackup
this is marked with a specific kind of timestamp (called
LogIOSequenceNumber). If this can be found on the still intact
LogVolu
Hi Uwe
Just wanted to clarify the method of doing a test restore.(see your
earlier mail below.)
Does this(i.e. recover_check) do the same thing as check-- >backup in
dbmgui? (I assume both I have had this problem before and received a few suggestions but have
not solved this problem yet. Our database fills and in addition there
are many transactions in the transaction log. ThisBlankI am in the process of designing a robust backup plan. I am running livecache 7.4.2.25 log mode SINGLE log volume on EMC
but not on RAID-1 autolog YES. This is for APO 3.1 on AIX5. Backup tBlankWhy do I have to follow the release matrix published by SAP for APO 3.1 which says I cannot use Livecache > 7.4.2.25 (as of
today)?
I would like to use a more recent livecache e.g. maxdb 7.5.0.Hello
Since MySQL AB Con happening in Orlando this year there 's probably a
contingent of you wandering around in what is one of the worst areas in
Orlando. Well I 'm from Orlando! So in anYou are stressing our ignor capabilities
> -----Urspr?ngliche Nachricht-----
> Von Victor Medina [mailto linux@(protected)]
> Gesendet Donnerstag 15. April 2004 14 36
> An maxdb@(protected)What will be the data type to store objects? In my case I need to store a
fax(tiff) image and a voice(pcm) recording.
Will it be fixed? And how do I determine the length? Or is it automatic?
ThWhen I send the query
select count(*) from a where b in
(select c from d where e 'f ')
to a MaxDB 7.5 (Build 008-123-061-548) server on Windows 2000
Server I get the message
General I 'm trying to import some csv data with the following command
DATALOAD TABLE zip
zip 1
zip_type 2
city 3
city_type 4
state 6
latitude 8
longitude 9
INFILE 'zip.csv ' COMPRESSED
And I gSirs I have been a long time user of MS Access and now im testing Max DB in
order to develop more robust apps. There are a few things that I miss (or
cannot find) about the MS Access environment tHello
I 'am trying to setup a standby database but only partially succeed to do
so.
These are the steps I perform
I create an instance for recovery using the DBMGUI. The instance
installs suHi everybody
--- for a German version of the mail text please see further below ---
Summary We are using SAP DB 7.4.3 are unhappy with its performance and
would greatly appreciate any hintDear list
i have the problem to connect to a sapdb instance from windows 2000
workstation based tools DBMGUI and SQLStudio (from Rel 7.4.3.30)
Environment
Server
debian Linux 2.4.x on intel
Hello all
I 'm trying to come up with a sort of matrix of the various logging
settings and I 've come across a few oddities
for example
1) Does it make sense to use Mirrored Log Volumes *w-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
this is only a test mail to the list please ignore
Best Regards
- --
~ |...........................................................|
~ |____ Hi all
Does somebody already have experience with the MAXDB Failover Database?
I tried to setup a Standby Database but till now without success.
Perhaps someone documented his or her installHi to all
we are using SAPDB 7.4...
There are some interesting instance types like (content server e-catalog
...)
Now I 've testet the current maxdb but there are only 3 instance types
(I have done patches against the maxdb-75 tree as of yesterday. The cvs diffs
are here
ftp //ftp.aubi.de/pub/sapdb/MaxDB/diff_maxdb75_140404.diff
and
ftp //ftp.aubi.de/pub/sapdb/MaxDB/diff_toWhen we define a constraint in MaxDB
- How 's the constraint checking is it immediate or deferred ?
- Does MaxDB support such a transition constraint ?
Hi
for special reasons i need a very long SQL-Query concatenating about 400 tables with UNION-statements.
But i got an error message
"General error -1107 POS(494) Too complicated SQL statement Hello
I have a problem with Varchar BYTE concatenation.
CREATE TABLE "ADMIN ". "TEST "
(
"VC " Varchar (50) BYTE
)
//
CREATE DBPROC TESTVC AS
VAR
msg Varchar(100) BYTE
Hello
I want to convert Integer (byte) value into Varchar BYTE variable.
So I created procedure to perform this task.
CREATE DBPROC NUM2VARCHARBYTE (IN NUMBER INTEGER OUT CHARBYTE VARCHAR (2Hi
I 've got some questions about user administration on maxdb.
I understand the user concept and role concept but I don 't understand how
to administer many users without confusion.
Some quI have a little confusion about ?session number? when a cpc program
connects to MaxDB Server.
What is its range? Can it be defined as any integer I want?
I would assign a connection to each threadHello
What should the statement "Select Unix_timestamp() " return? When I
do this in SQL Studio it errors out. But when I do "Select
Unix_timestamp(now()) " it returns the current timestI 'm trying to write a SQL statement that needs
some data type casting/conversion. I can 't
seem to find the documentation to do this.
The following expression
rec_entry_date > SUBTIME(TIME I am new to MAXDB. I have been using MySQL for awhile
now though. I have a database that I have in MySQL
that I need to transfer over to the MAXDB. I have the
newest MAXDB as of Yesterday. I ha |
|
|
