Zavier Sheran wrote:
>
> Note that if you use ROWNO, then a following ORDER BY clause will sort
> only
> the records until the limit of ROWNO is reached. It says so in the manual
> at
> least, I haven't tried it... Makes the feature a bit useless IMO... You
> can
> set MaxDB to parse in Oracle m
Hi,
Can anyone help me with the problem below please? I'm using
mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc.
Thanks,
JS.
Does anyone know what goes on (system wise) during the CREATE INDEX ? I can
see it's copying the table file, what then though?
I tried running the "create index" again using --
Is there a maxdb replication tool? Or do you suggest anyway to
replicate a remote and local instance?
Thanks,
Si Chen
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why in the world would you want to do this? Think about it, you have similar
data in two different columns that should be in one. If a value in (c) is
the same as (b) which enables it to have a FK link to (a) then why not merge
the columns and save yourself some headaches?
This is a normal task. Th
Note that if you use ROWNO, then a following ORDER BY clause will sort only
the records until the limit of ROWNO is reached. It says so in the manual at
least, I haven't tried it... Makes the feature a bit useless IMO... You can
set MaxDB to parse in Oracle mode and use ROWNUM to limit/offset..
Hi Elke,
there was no index on ag_id in va_ums.
Have created index and now speed is the same like "in" clause.
Sorry for my last response. Have not seen your hint with index.
Normally i'm working with explain in such case of problems, but the bug
with "in" clause in conjuction with outer joins mak
Hi Elke,
have tried everything to make it faster.
So i'm getting confused with my querys.
The query needs more than 4 hours.
138000 rows in bas_agnums and 38 in va_ums.
The same query with "in" clause need 15 seconds.
Plz. take a look to the msg. with bug in "in" clause.
http://www.sapdb.org/we
Albert Steckenborn wrote:
>
> Have tried not exists like shown:
> select count(a.id) from bas_agnums a where not exists(select b.ag_id
> from va_ums b where b.ag_id=a.id group by b.ag_id)
>
Being back to office one question:
Why (in hell) do you use the group by-clause in the subquery?
There is
Filip Sergeys wrote:
>
> Hello,
>
> When evaluating a math formula stored in a cell and convert the result
> back into a string, The returnvalue is strange
> Example:
> stored in the cell 7+7
>
> SELECT num(substr(nbreplace,1,1)) + num(substr(nbreplace,3,1))
> result: 4
>
> SELECT chr(num(sub
select * from table where rowno<=[num of records that you need]
ej.
select * from table where rowno<=5
Grzegorz Konicki wrote:
Hello
How can I limit results from queries?
In mysql or postgresql i use syntax limit, but in maxdb it doesn't work.
---
Best regards Gregory
--
MaxDB Discussion Mailin
Why in the world would you want to do this? Think about it, you have similar
data in two different columns that should be in one. If a value in (c) is
the same as (b) which enables it to have a FK link to (a) then why not merge
the columns and save yourself some headaches?
-Original Message---
This is a forwarded message
From: Sim Zacks <[EMAIL PROTECTED]>
To: "Dittmar, Daniel" <[EMAIL PROTECTED]>
(Sorry, I noticed I hit reply before and didn't send it to the list)
I am using the python module you mentioned with Python version 2.2.1.
It occurred again when using this method.
Where would
> I've tried this a number of different ways, including in a try except
> block and I get a segmentation error which throws me out of python
> completely.
Have you used the python driver from
ftp://ftp.sap.com/pub/sapdb/bin/linux/sapdb-python-linux-i386-7.4.03.33a.tgz? The
driver in the server i
Hello Alexei,
I have to add that there is at least the possible workaround
SELECT * FROM TABLE WHERE X LIKE CONCAT(RTRIM(?, ''), '%')
which should produce the expected result.
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
> -Original Message-
> From: Alexei Novakov [mailto:[EMAI
Forgot to mention:
Maxdb version: 7.5.00.14
OS: linux
On Mon, 2004-07-26 at 12:49, Filip Sergeys wrote:
> Hello,
>
> When evaluating a math formula stored in a cell and convert the result
> back into a string, The returnvalue is strange
> Example:
> stored in the cell 7+7
>
> SELECT num(substr
Hello,
When evaluating a math formula stored in a cell and convert the result
back into a string, The returnvalue is strange
Example:
stored in the cell 7+7
SELECT num(substr(nbreplace,1,1)) + num(substr(nbreplace,3,1))
result: 4
SELECT chr(num(substr(nbreplace,1,1)) + num(substr(nbreplace,3,1
I'm not sure exactly where the bug is here and I was hoping someone
could look at this and tell me where I am going wrong.
I am trying to switch a Long column to a varchar(7000) column.
(Comments is Long, comments2 is varchar(7000))
import sys
import sapdb.sql
session=sapdb.sql.connect("DBA","PWD
Alexei Novakov wrote:
> I ran across interesting problem with MaxDB 7.5.0.8 on
> Windows 2000. Simple select query:
>
> select sum(abs(access_flag)) from access_tbl where ...
>
> was giving me negative and result (which should never
> be the case with sum(abs( ). I tried to do:
>
> create tabl
Hi Albert,
the example with the "not in" is an inner join.
The bug is only related to outer joins.
So do you have an example with outer joins in subquery
in a delete or update command wich works fine?
Kind regards
Holger
> -Ursprüngliche Nachricht-
> Von: Albert Steckenborn [mailto:[EMA
Hello Alexei,
unfortunately, this is a limitation in the database kernel and not
in JDBC, and it has to do with the fact that the necessary length
of the parameter is possibly not determined carefully enough when
evaluating the expression - leading to the fact that the '%' is
not considered in
Hello
How can I limit results from queries?
In mysql or postgresql i use syntax limit, but in maxdb it doesn't work.
---
Best regards Gregory
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
Prepared statements with "like clause" don't seem to
work. For example from sqlcli I run query:
select * from tbl where str_val like CONCAT('test',
'%')
It works fine and returns 100 records. If I do the
same thing in JDBC it works too, but not if I use
prepared statement. As follows:
P
22 matches
Mail list logo
