The reason in name of column 'NAME'. After renaming problem was solved.
MaxDB bug.
Alexey Gaidukov пишет:
GIS - resource user
CREATE TABLE "GIS"."NAMES"
(
"NAME" Varchar (20) UNICODENOT NULL
)
grant select on gis.names to PUBLIC
from STANDARD user
SELECT Name FROM gis.names ORDER
I trace a sql statement using database trace.But any sql statement are not
complete in the result .How can i get complete sql statement by database
trace?
_
享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com
--
MaxDB Discuss
maxdb can not use temp view
From: 王 旭 <[EMAIL PROTECTED]>
To: maxdb@lists.mysql.com
Subject: can i create a temp view??
Date: Tue, 21 Jun 2005 14:46:11 +0800
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn/
--
MaxDB Discuss
Hello:
I met this error:
SQLExecute error:
SQL state: 01004
Native error: 0
SQL Errortext: [MySQL MaxDB][SQLOD32 DLL] Data truncated
On Windows2000 the error occured when running SQLExecute() with this SQL
statement:
UPDATE EACONTACTMEMBERS SET
USERNAME=?,NICKNAME=?,DEPTNAME=?,GENDER=?,BIRTHDAY=
GIS - resource user
CREATE TABLE "GIS"."NAMES"
(
"NAME" Varchar (20) UNICODENOT NULL
)
grant select on gis.names to PUBLIC
from STANDARD user
SELECT Name FROM gis.names ORDER BY Name
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Base table not found;-4004 POS(34)
> The CVS trees for the buildtools and the release 7.5 are up to date
[...]
YEAH - I already noticed - thanx VERY much! :))
> In addition, the current development release is also available and
> updated daily:
> cvs -z9 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb c
> -P -d maxdb-dev
So.. i
Following this logick the code should be compiled
CREATE DBPROC test(
IN p varchar) AS
BEGIN
select '44' from dual where :p='112';
END;
But it's copiled without error.
In Oracle 8.1.6 my example with varchar and substr compiles and works
without problems.
Schroeder, Alexander пишет:
I've tried JDBC and SQL Studio. Both are from 7.6.00.10 for Windows.
Schroeder, Alexander пишет:
Hello Alexey,
please tell us
- the definition of the table
- the interface (JDBC?, ODBC?) that was used to issue this statement.
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
-Ori
The CVS trees for the buildtools and the release 7.5 are up to date
again and you can get them with
cvs -z9 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb c -P -d TOOLSRC
and
cvs -z9 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb c -P -d
maxdb-7500
In addition, the current development release i
> The only difference I see between the two Debian Etch
> machines is the kernel version : Debian 2.6.8 on the test
> machine, custom 2.6.11.12 on the other. The two machines are
> up to date.
[...]
> STDERR: MAKE SYSTEM: c_runtime = GLIBC 2.3.3
[...]
> STDERR: YOUR SYSTEM: c_runtime = GLIBC 2.
bonjour,
I wanted to test maxdb 7.6.10 on a Debian Etch box for testing with a
backup-recovery of 7.5.26 instances.
I tried with SDBINST and SDBSETUP
SDBSETUP is searching for libtiff3, deprecated on Debian Etch. I needed
to link libtiff.so.3 to libtiff.so.4.1.2 (symbolic link) and it wor
> increasing read performance during scan operations is one of
> our major topics of the next release. I agree to you that
> MaxDB could be much faster than today concerning this topic.
Ok :)
so 'next release' - is it 7.7 (8.0) or 7.6?
> Implementing another prefetch technic in the kernel is
Hi Markus,
increasing read performance during scan operations is one of our
major topics of the next release. I agree to you that MaxDB could
be much faster than today concerning this topic.
Implementing another prefetch technic in the kernel is possible
but it is only one small piece of our st
Hello,
With 7.6 the Analyser seems not to work, I can see the following error
in DBAN.err:
ERROR 5: Cannot execute SQL statement.
[MySQL MaxDB][SQLOD32 DLL][MaxDB] Column not found;-4005 POS(66)
Unknown column name:ADDRESS
CREATE OR REPLACE VIEW READER_WRITER_LOCKSTATISTICS_AR AS
SELECT ADDRES
Hello Alexander and Elke,
> For your purposes, it is more safe to refer to the DOMAIN.* tables and
use
> SELECT DISTINCT TABLENAME, SCHEMANAME FROM DOMAIN.COLUMNS WHERE KEYPOS
IS NOT NULL
> AND OWNER=USER
Yes thanks, that works.
The reason we do this is a Software Application which is using the
I have a connection defenetly in UNICODE. MaxDB 7.6.00.10
CREATE VIEW TEST AS
select field from table where field2 like 'some cyrillic here' and
field3='some cyrillic here'
SELECT * FROM TEST
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9111 POS(1) 䄀吀䔀刀䔀匀
Is it possible in 7.6 to enable a parallel read from disk? Imagine if the
optimizer has a threashold value (e. g. 1). When the costs are higher
than this value Servertasks will be used additionally to get the pages from
the disks (as Oracle does). I'm sure this will really give a performance
bo
Robert Klemme wrote :
>"Anhaus, Thomas" <[EMAIL PROTECTED]> schrieb am 28.06.05 08:55:26:
>> I assume your sequence has been created with CACHE 100. The CACHE
>> parameter defines the
>> number of sequence values which are stored in the sequence cache.
>
>Interestingly documentation for Oracle mod
You should explizitely specify the length, i.e.
CREATE DBPROC test(IN p VARCHAR(10)) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
otherwise 1 is assumed as length, which renders your substr function call
invalid.
See
http://dev.mysql.com/doc/maxdb/en/03/5087f083c411d
I'm using MaxDB 7.6.00.10
--- Begin Message ---
CREATE DBPROC test(IN p varchar) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-3046 POS(319) Invalid char position in string function
CREATE
CREATE DBPROC test(IN p varchar) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-3046 POS(319) Invalid char position in string function
CREATE DBPROC test(IN p varchar) AS
VAR
pp varchar(10
"Anhaus, Thomas" <[EMAIL PROTECTED]> schrieb am 28.06.05 08:55:26:
> I assume your sequence has been created with CACHE 100. The CACHE
> parameter defines the
> number of sequence values which are stored in the sequence cache.
Interestingly documentation for Oracle mode says about creating seque
22 matches
Mail list logo
