Hello all,
Quick question: Should this work?
>select LOG(2, 65536) from dual
Whenever I execute this I get:
* -5016: Missing delimiter: ) SQLSTATE: 42000
Am I doing something wrong? I have to be missing something...
Thanks!
JLS
PS: I'm using 7.5.00.19...
--
MaxDB Discussion Mailing List
F
Hello All,
I'm trying to build MaxDB in a Xeon system with the 64 bit extensions
installed. (I would use the binaries, but they are not supported)
For example:
software in package Database Kernel is not runnable on your system
MAKE SYSTEM: architecture = I386
MAKE SYSTEM: c_runtime = GLIBC 2.2.2
Hello All,
I just ran into a rather weird problem in a SQL query. Basically, I
created a view from a very large query. The query runs fine when
executed as is, and the create view statement completes successfully
as well. However, when I try to select from that view I get an error,
"BD Append Not
Hi All,
I want to document two parts of MaxDB however I have a few questions:
1) MySQL_Proxy seems to be alpha software. How long before this is
release quality? If I were to document it now, how much would it change
by the time it becomes stable?
2) MaxDB<->MySQL Clustering/Replication. Does thi
Hi Felde,
One thing I just thought of which may be a help to you is to store the
results in a temporary table. Do something like:
CREATE DBPROC DBA.TEST_PROC(IN PARA1 VARCHAR(4), IN
TABLE_NAME VARCHAR(10))
AS
VAR QUERY VARCHAR(200);
SET QUERY = 'CREATE TABLE TEMP.' || TABLE_NAME || ' AS
SELECT '
Hi,
Oh, I see what you mean now. Sorry about that. No, I don't actually know
if what you are trying to do is possible. I would, however, be very
interested to find out if it is. I know that if this were embedded SQL
you could do something like that with a prepare/execute series of
statements. H
Hi Felde,
I wanted to create a dbproc in which I use the result of a dynamic
query. I thought the dbproc should work as follows ( just example ):
CREATE DBPROC PREPTEST (
IN SZAM INTEGER,
OUT RES VARCHAR
)
AS
VAR QI VARCHAR(100);
SET QI = 'SELECT 5 FROM DBA.DUAL ';
EXECUTE QI;
FETCH INTO :R
I forgot to include that the process that crashed was the Apache
process, which of course means that PHP crashed.
John Singleton wrote:
Hi All,
I seem to be having a crashing problem with the PHP module for MaxDB.
I am using apache 1.3.9 in Windows XP with MaxDB 7.5.00.19, PHP module
version
Hello All,
Does anyone know if the PHP module supports returning parameters from a
stored procedure yet?
All Best,
JLS
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I seem to be having a crashing problem with the PHP module for MaxDB. I
am using apache 1.3.9 in Windows XP with MaxDB 7.5.00.19, PHP module
version 7.5.00.19, and PHP 5.0.2. PHP is loaded as a dll. Here is the
code snippet.
$link = maxdb_connect("localhost", "DBA", "DBA", "CH10");
if
Hi All,
I'm trying to get the SAP::DBTech::dbm interface running, however, I am
experiencing some problems doing so.
Whenever I run the following program, perl crashes.
use SAP::DBTech::dbm;
$session = new DBM('localhost', 'TEST', '', 'DBM,DBM');
Any ideas? I'm using Activestate Perl5.8 with M
Hi Felde,
I too am having this problem. Have you solved it?
JLS
Felde Norbert wrote:
Hi,
I tried to use the new php module.
As I test it with php -m I receive no error message and it is loaded but
it dous not work.
I wanted to connect with maxdb_connect and I get the message:
Initialization failed
Hello All,
I ran into a problem installing MaxDB 7.5.00.19. When running SDBINST I
got the following error message:
please enter profile id: 10
getBuildInfoTGZ(): cannot find file "misc/sapdb/pythondef/dbm.pyd" in
package C:
/Documents and Settings/Rhyce
Udique/Desktop/MaxDB/maxdb-all-win-32bit
Hello All,
I'm trying to fire up the MaxDB PHP module. While running php-cgi -m I
got the following error:
"This application has failed to start because MSVCR71.dll was not found.
Re-installing the application may fix the problem."
There is a MSVCR70.dll in the root dir of the 7.5.00.19 install
Thomas,
Well, I did it several times just to be sure before reporting. It may
have been some strange glitch or something, but after several database
crashes and restarts it still worked. Are there any files I could send
you for verification?
Best,
JLS
Anhaus, Thomas wrote:
John Singleton
Hello All,
Just wanted to report a crash I experienced. I tried to load the
following stored procedure like this:
sqlcli> \i test.sql
the proc:
CREATE DBPROC DBA.test AS
var username varchar(50);
owner varchar(50);
foo int;
TRY
SELECT * FROM DOMAIN.USERS WHERE USERNAME='DDD';
CATCH
IF $RC =
Hi Jean-Michel,
This is most likely because $rc = 100, in which case there will be no
error returned, either. STOP will stop the execution of your program but
will not print the error. If you are looking to catch the row not found
condition you could work around it like:
TRY
SELECT * FROM DO
Hello All,
I just came across a syntax error that I thought I should report.
http://dev.mysql.com/doc/maxdb/en/0a/191ca01377384dbf872d5391adf3cf/frameset.htm
Maybe I am wrong, but I think there should be a semi-colon after the END
CASE statement.
All Best,
JLS
--
MaxDB Discussion Mailing List
For
Jonathan,
Also, you may want to check out these postings:
http://lists.mysql.com/maxdb/12851
http://lists.mysql.com/maxdb/12859
http://jakarta.apache.org/lucene/docs/index.html
Cheers,
JLS
+---+
Liked my Post? Then you're sure to love
Christoph,
What happens when you type:
#/opt/test/sapdb/indep_prog/bin/dbmcli db_enum
Also, this may seem very obvious, but why are you using 7.4?
SAPDB^H^H^H^H MaxDB 7.5 is currently available at: www.mysql.com/maxdb
Is there any reason why you need to use 7.4? It seems to me all of these
probl
Hi Christoph,
The libs libdl.so.2 and libc.so.6 are two common system libraries. You
may not actually have them installed in the new version of SUSE.
Verify this with:
find / -name 'libc.so.6'
and:
find / -name 'libdl.so.2'
If they are installed, just either modify /etc/ld.so.conf or the env.
va
Ralf,
Try adding this line before starting x_server:
export LD_ASSUME_KERNEL=2.2.5
Just a hunch.
JLS
Ralf Schneider wrote:
Am Samstag, 12. Juni 2004 10:57 schrieb Ralf Schneider:
Am Samstag, 12. Juni 2004 08:54 schrieb Jean-Michel OLTRA:
#$X_SERVER stop > /dev/null 2>&1
Kevin,
After looking at what that statment does in MS SQL Server, I think this
is the syntax you are looking for:
UPDATE SET = | (,...) =
WHERE
Hope that helps. (That update from statement is wild...)
Cheers,
JLS
[EMAIL PROTECTED] wrote:
Unable to do mass update from a table using:
UPDAT
Hi Kevin,
That statement really works in SQL Server? What does it do?
Try:
UPDATE SET = WHERE
JLS
[EMAIL PROTECTED] wrote:
Unable to do mass update from a table using:
UPDATE SET = 'X' FROM , WHERE
Get "Invalid end of SQL statement." on the FROM keyword. This is a real
handy item to have (u
Elke,
Yes, DDL does not perform name resolution
All DDL statements? Some, like DROP TABLE seem to perform resolution at
least on the first level...
Cheers,
JLS
Zabach, Elke wrote:
John Singleton wrote:
Hello all,
So I think I've pretty much got MaxDB's name resolution system d
JLS
Zabach, Elke wrote:
John Singleton wrote:
Hello all,
So I think I've pretty much got MaxDB's name resolution system down. But
I just wanted to post to the list to make sure :)
So, from what I've been able to determine, it works like this:
1) Say I have three users. DBA, DBA2, and D
Hi Gustav,
The SQL statement I posted below is a special statement---not merely the
first column. Given the table definition:
create table sometable (foo int DEFAULT SERIAL, bar int)
insert into sometable (bar) VALUES (11)
If you do:
select sometable.currval from sometable
It will return the curr
Hello,
Something like this will work:
select mytable_name.currval from mytable_name
Just fetch the first row.
Cheers,
JLS
maxdb wrote:
If i create a table that have a field of type serial(1) and insert a row
on it how to determine the currval for this field on this table
when insert new values
Hello all,
From the docs on the REVOKE statement:
--
Let U1, U2, and U3 be users.
U1 grants U2 the privilege set P WITH GRANT OPTION.
U1 grants U3 the privilege set P' (P'<=P).
If U1 revokes the privilege set P'' (P''<=P) from user U2, the privilege
set (P'*P'') is revoked implicitly from user
Hi Joannes,
Whoops. Sorry about that. I misread your post. (Not enough coffee yet.)
See Alexander's post for the correct answer to your question.
Cheers,
JLS
John Singleton wrote:
Hi Joannes,
The table you're looking for is "dbprocedures."
Cheers,
JLS
Joannes Capitanio w
Hi Joannes,
The table you're looking for is "dbprocedures."
Cheers,
JLS
Joannes Capitanio wrote:
Hi,
Is there a system table or something else to get functions list created by CREATE
FUNCTION statement?
thanks in advance
Joannes
- Original Message -
From: Joannes Capitanio
To: [EMAIL
je)
John you have been very helpful, many thanks to you and many thanks for
being in this forum to help people like me to use maxdb....
Thanks,
erick
-Original Message-
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Monday, June 07, 2004 12:08 PM
To: Erick Perez
Cc: [EMAIL PROTECTED]
10 tcp (im using windows).
i wanted to try mysql administrator but the program does not seem to work. I
enter dba/pass and port 7210 and it never connects
anyways..thanks
erick
-Original Message-----
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 05, 2004 10:03 AM
Hello all,
So I think I've pretty much got MaxDB's name resolution system down. But
I just wanted to post to the list to make sure :)
So, from what I've been able to determine, it works like this:
1) Say I have three users. DBA, DBA2, and DBA2USER. DBA creates DBA2
then DBA2 creates the resource
Hi Markus,
Do you know if this will be corrected in the future? I'm trying to
figure out how to document it. If this won't be corrected in the future,
SQL Studio is limited to creating synonyms for objects the current user
owns. In theory, however, SQL Studio could create a synonym for any
obje
Erick,
The port number you're looking for is 7210. This port number is only
used if the communication is non-local. When you install MaxDB in *nix
based platforms, you're required to put three entries into your services
file. (SDBINST usually does this by automatically.)
sql6 7210/tcp
sql30 720
is incorrect/corrupted.
Since i have never used the command line clients, how can i change/check the
pass?
thanks,
erick
-Original Message-----
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 5:44 PM
To: Erick Perez
Cc: [EMAIL PROTECTED]
Subject: Re: remove a failed data
Hi Erick,
This is a normal error, meant to protect you from accidentally making
your databases unavailable. You can check this out like this:
# dbmcli db_enum
Then have a look at the database it prints. You can drop those databases
with the command:
# dbmcli -d -u , db_drop
Be careful though,
Joao:
Hi there. You might try starting x_server with the "-F" flag. This
option supresses DNS lookups.
Hope that helps.
JLS
Joao wrote:
Hello,
I Have a big problem
I've installed a SAPDB Database v 7.4 in AIX system.
Using ODBC the connection time to this database is about 2 minuts some
part
Hello All,
I just ran into a rather odd problem in SQL Studio and I was hoping
someone could clear the air.
I have two users, DBA, and DBA2. I also have 2 tables FOO and BAR. FOO
belongs to DBA and BAR belongs to DBA2. DBA has all privileges on DBA2's
tables and vice-a-versa.
Now: In sqlcli I
you can use "backup_replace" with just one single medium (as you did with PARA\F01). That way it is possible to keep a parallel backup parallel, but it is impossible to end a backup that started non-parallel as a parallel backup.
Best Regards,
Tilo Heinrich
SAP Labs Berlin
-Origi
Hello all,
Can you continue from a interrupted backup (due to a media full error)
by specifying a parallel medium? Is this insane?
For example, say I start a backup to a file-based medium of 10 KB.
>backup_start SMALL_FILE_MEDIUM
(error stuff here)
Now let's say that I create a parallel media
Data" the device type "File" and by changing the Name and Device/File columns in the "spreadsheet-like" field to F01 plus DEMO_COMF1, F02 plus DEMO_COMF2 and so on.
Best Regards,
Tilo Heinrich
SAP Labs Berlin
-Original Message-
From: John Singleton [mailto:[EMA
dsheet-like" field to F01 plus DEMO_COMF1, F02 plus DEMO_COMF2 and so on.
Best Regards,
Tilo Heinrich
SAP Labs Berlin
-Original Message-
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 5:26 PM
To: [EMAIL PROTECTED]
Subject: Ridiculous Question About Para
back" and tell the wizard
to "ignore" the problem.
Hope that helps.
JLS
John Singleton wrote:
Hi Jim,
Two things:
1) Did you verify that the log backup works on S1?
2) Did you copy the log version files over to S2? The log version
files are those files that look like: .001,
.
Hi Jim,
Two things:
1) Did you verify that the log backup works on S1?
2) Did you copy the log version files over to S2? The log version files
are those files that look like: .001, .
JLS
Jim Sanders wrote:
Hi,
I have simple problem just trying to recover data & log from one server
to another ser
Hello all,
I have a completely ridiculous question about using parallel media: How
do you create a parallel media group with DBMGUI?
I understand how to do it with dbmcli like: (simple example)
PARA\F01DEMO_COMF1 FILEDATA0 0 NO NO
PARA\F02DEMO_COMF2 FILE
Hello all,
I have a completely ridiculous question about using parallel media: How
do you create a parallel media group with DBMGUI?
I understand how to do it with dbmcli like: (simple example)
PARA\F01DEMO_COMF1 FILEDATA0 0 NO NO
PARA\F02DEMO_COMF2 FILE
48 matches
Mail list logo
