Noah J SILVA wrote:
>
>
> Hi Again,
>
> Problem found:
> The "field1" below had actually started with a number.
> Apparently this
> isn't allowed in queries - but it is allowed in table creates!
No simple identifier (without " around) is allowed to start with
a number/digit, no matter if in
lu peng wrote:
>
> Hi
>
> did anybody have a summary of the differences between maxdb
> and oracle?
>
For the beginning
http://dev.mysql.com/doc/maxdb/en/81/ee4d3c596f0b26e1000a11402f/frameset.htm
may help
Elke
SAP Labs Berlin
> Lu
>
> ___
Samir Mishra wrote:
>
> Hi All,
>
> Just installed SapDB binaries (from file
> maxdb-all-linux-32bit-i386-7_5_0_8.tgz) on a new machine, and
> am simply
> following directions in the documentation so that I can be up
> and running.
>
> Unfortunately, I'm getting an error when I try and initi
Hi All,
Just installed SapDB binaries (from file
maxdb-all-linux-32bit-i386-7_5_0_8.tgz) on a new machine, and am simply
following directions in the documentation so that I can be up and running.
Unfortunately, I'm getting an error when I try and initialise my
base/initial/primary database. I ha
Hi
did anybody have a summary of the differences between maxdb and oracle?
Lu
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscri
We saw similar problems of inconsistent behaviour with external loaders to
databases. Most of our experience was with Oracle, but our findings should
hold.
1. It is best to load a freshly created table and join it to the other
tables, or primary table, preferably through views.
2. If you have any
I noticed a very strange behavior when DBPROC returns cursor which
includes DATE and TIME columns.
Enviroment --
MaxDB 7.5.0.8
JDBC (last one)
UNICODE = YES
Suse 9.0
--
CREATE DBPROC DT RETURNS CURSOR AS
DECLARE :$CURSOR CURSOR FOR
SELECT DATE, TIME FRO
Hi Again,
Problem found:
The "field1" below had actually started with a number. Apparently this
isn't allowed in queries - but it is allowed in table creates!
Thank you,
Noah Silva
Atofina IS&T - Sr. Programmer Analyst
(215) 419 - 7916
"Noah J SILVA" <[EMAIL PROTECTED]>
0
The explain output of the statement:
SELECT COMPANY_ID,COM_NAME FROM COMPANY ORDER BY COM_NAME ASC
shows that a table scan is being performed. Now I know there was mention of
this in previous emails and one suggestion was to look at the
optimizerstatistics tables to see if the system sees a tabl
bonjour,
Le mardi 25 mai 2004, Noah J SILVA a écrit...
> UPDATE table1
> SET table1.field1=(SELECT field1 FROM table2 WHERE table1.key =
> table2.key)
Should be correct but...columnname to update must be specified without
table name
UPDATE MYTABLE SET MYCOLUMN="blah"
--
jm
--
Hi again,
I did a little more digging, and found the post below, which is similar to
one way I tried writing my query, and yet my query didn't work still:
the query I am running (with some field names changed ...) is:
update table1 a
set field1 = (select amount
from table
bonjour,
Le mardi 25 mai 2004, Bauer, Alexander a écrit...
> $db = odbc_connect("Driver={MaxDB};Server=p52600;Database=CRM_AUTO","WEBCLIENT",
> "webclient")
> Warning: odbc_connect(): SQL error: [MySQL MaxDB][SQLOD32 DLL][MaxDB] Invalid
> authorization specification;-4008 POS(1) Un
Hi,
This is likely a silly question, but probably I have been staring at SQL
queries for too long, and using too many database systems at once:
How can I do a multi-table update?
More specifically something like:
UPDATE table1
FROM table2
SET table1.field1=table2.field1
WHERE table1.key = tabl
Hello Shesh,
the error output of your Backint for SAP DB in dbm.ebp is not very useful:
#ERROR \\.\Pipe\ABC.BACKDP-Data[1].1
That leads me to the question what executable is hiding behind "C:\Program
Files\OmniBack\bin\\sapdb_backint.exe" and which Backint are you trying to use with
Omniback.
Where can i see the database script?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
we still have problems getting our udate of the statistics
we have Sapdb 7.4.3.32/7.4.3.31 running on Linux Redhat and Suse.
In our backup procedure we have
util_connect
util_execute check data except index
sql_updatestat
backup_start pipe data
The proposed alternative was to use
UPDATE STATIST
We use Sapdb 7.4.3.32 on Redhat 9 with kernel 2.4.20-8
and have following in the profile of Sapdb user
LD_ASSUME_KERNEL=2.2.5
export LD_ASSUME_KERNEL
MaxDB wrote:
This is the result
set | grep LD_
LD_HWCAP_MASK=0x2000
What must to do?
Schroeder, Alexander wrote:
You may want to search through
To install the new maxdb instance with your 7.3 migrated backup use the following.
db_admin
util_connect
db_activate recover backupMedium
db_online
If you use recover_start the log volume is not initialized.
This is shown to you in the knldiag with the error message
"db identifier mismatch" which
Hi,
i can't connect to a MaxDB database (server installed on my local machine) with PHP
4.*.
Code on my page:
' . odbc_error() .'' .
odbc_errormsg());
?>
I get the following error msg:
Warning: odbc_connect(): SQL error: [MySQL MaxDB][SQLOD32 DLL][MaxDB] Invalid
authorization specification;
Hello,
I'm trying to upgrade SAPDB 7.3.0.25 to MAXDB 7.5.0.12 but without
success.
A) I tried sdbupd.exe and then the procedure documented in Database
Upgrade from SAP DB 7.3 to 7.4
with sdbinst.exe but the result was the same error.
load_systab
ERR
-24909,ERR_DBAUNKNOWN: SYSDBA unknown
B
I have a table with a primary index that was created like this:
CREATE TABLE "DBA"."CARS_USED"
(
"RECORD_ID" Fixed (10,0) NOT NULL DEFAULT SERIAL (1)
}
Every time I insert a record without giving a value to 'record_id', it auto
inserts a value that increases by 1 with every new INSERT.
Exactly w
Hello,
DBD::MaxDB is a Perl module which provides access to the MySQL MaxDB databases using
the DBI module. It is an interface between the Perl programming language and the MaxDB
programming API SQLDBC.
The programming API SQLDBC is part of the MySQL MaxDB database software package,
whereas the
Hi Zavier,
Zavier Sheran [mailto:[EMAIL PROTECTED] wrote:
>
> I have to import a csv dataset and some fields that are
> indexed in the table are not in the csv data.
>
> Loader gives an error stating that those fields are required.
>
> is there a way to import the data and set for the index
23 matches
Mail list logo
