 | | | MaxDB | | /* from user DBADMIN */
CREATE USER GIS PASSWORD 1 RESOURCE
//
CREATE USER REG PASSWORD 1 RESOURCE
//
CREATE ROLE regRole
//
CREATE USER TU PASSWORD 1
//
GRANT regRole TO TU
//
ALTER user TU DEFAULT Hi
I am using MaxDB 7.6 with python. I expect that it should be possible to
pass parameters to SQL queries like this
cursor session.cursor ()
cursor.execute ( 'select * from messages where msgno >Hi Folks
we finally migrated from SAP DB 7.4 to MaxDB 7.6 and its performance is just
amazing.
We stillt got a problem with our Timestamps.
We have a Table called event where the colums DAY MONTfollowing the SAP Library i 've tried creating a database instance following
the script below. i installed all the relevant files via RPM install.
# ./dbmcli -s db_create ig ig ig (from UNIX prompt)
Hello this message is posted in both English and mein schlechtes Deutch
***In English***
Hello
My wife is an SAP DB Administrator and she 's desparately trying to find
some good documentation onHannes Degenhard wrote
>-----Urspr?ngliche Nachricht-----
>Von Hannes Degenhart [mailto dh@(protected)]
>Gesendet Donnerstag 1. Dezember 2005 16 52
>An Maxdb
>Betreff Select * from tables
>
>
>Hello list
we have updated our testsystem with MaxDB from 7.5.00.16 to 7.5.00.24
Now the SQL-Statement "select * from tables " leads to the following
error message
-811 Numeric output parameteI ma running SAP BW system with SAP DB 7.3 database. How can I reset user 's SAP* password? I know it 's possible in Oracle SAP BW systems.
with regards
Lucas Hoffmann
--
Enhance your customers ' expeHi!
When trying to import data with TIMESTAMPs and a user-defined format
repmcli/loadercli complains about the format. The easiest way is a little
example
DATALOAD TABLE TEST
UPDATE DUPLICATES
List
We have an automated loader that pulls files from an inbox and loads into
SAPDB. Every so often we get the following error.
ERROR [HY090] [MySQL MaxDB][SQLOD32 DLL] Invalid string or buffeHey
I haven 't got any updates for the trees
maxdb-76
maxdb-dev
in the last two weeks - any issues with the CVS server? Just curious...
TOOLSRC and maxdb-75 are updated.
Greetz
SIEGENIA-AUHello
Backint for MaxDB can not restore the backup because two files can not be restored by Backint for Oracle for NetBackup.
First the inquiry of available backups ends without any of your backupHello list
I 'm using MaxDb 7.6.0.16 on WinXP Home vith SP2.
I have installed GUI SQL Studio (maxdb-sqlstudio-setup-7_6_00-106556.exe).
Before I installed new version I uninstalled my old SQL studio Hi everybody
we planned a long time and now the time was right to do a complete System
upgrade.
Wie changed our OS from SuSE 8.2 to Debian Sarge 3.1.
Performing this step we wanted tu update our D-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Daniel was kind enough to take a part of his evening to document the
MaxDB source tree. I 've posted his comments in my blog here
http //www.livejournaHi all
im not quite sure about the parameter setting of CACHE_SIZE and MAXCPU. We
are running a maxdb 7.5.00 build 21 for an sap r/3 4.70 110. Both on a
single system with 2 processors with hyperthrFrank Schimmelpfennig wrote
>Hello
>I faced an interesting effect when replacing a dbproc with a
>newer version
>(1) I was executing the old version of the dbproc in question with a
>non-owner usIn JDBC specification there is no way to get names of
CallableStatement 's parameters. But in
com.sap.dbtech.jdbc.translators.DBTechTranslator there is this
information. Is it possible to add into Hi
I get a wrong result "1 " with the following statement
select 1 from dual where '2005-11-23 11 34 04.985364 ' <subdate( '2005-11-25 11 04 10.456231 ' 40)
with "select subdate( '2005-11-25 11 04 10.45Hello
we are having some performance problems with some kind of queries. This is a
simplified example of what is happening in our production environment.
We have an application with jboss and maxdHi
we tried to do update statistics via a JDBC connection when the driver reported
2005-11-25 09 55 21 18 TERMINAL System Scheduler Error during storing
of finished SEB 17 [-708] Data receive failDid anyboby perform tests of dependencing MaxDB performance on
"elevator " linux kernel 2.6 parameter?
--
MaxDB Discussion Mailing List
For list archives http //lists.mysql.com/maxdb
To unsubscribeHello
I faced an interesting effect when replacing a dbproc with a newer version
(1) I was executing the old version of the dbproc in question with a
non-owner user.
(2) I droped and re-created the Hello
we 're trying to convert some dbprocs written on a 7.6.00.12-MaxDB-installation into our
7.5.00.26-installation.
Even though tablestructeres indices data and stuff are *exactly* the same thHi
we discovered a strange phenomenon with MaxDB 7.5.00.30 on Linux (RHEE
4). Consider these two queries
SELECT TA1.abortcode AS COL1 TA1.description AS COL2 SUM(TA2.refcount) AS COL3
FROM ag_aHi! We are having problems installing MAX DB on windows 2k3 Cluster.
1st the cluster is configured with 2 dell servers Xeon 3ghz 2gb Cache
connected to a DELL storage via redundant fibber links.
Hi
Original from frank.schimmelpfennig@(protected)
> what is the standard port of the MaxDB ODBC driver (we use the Win32
> version)? - I need this to get the IT people to open a
> firewall for tHi
what is the standard port of the MaxDB ODBC driver (we use the Win32
version)? - I need this to get the IT people to open a firewall for this
port.
Thanks in advance!
Frank
--
MaxDB DiscussioHello Everyone!
Is it possible to run a 32-Bit version of SAPDB 7.4.3.32 on a x86-64Bit SuSE
10.0?
As far as I know both libraries - the 32bit and the 64 bit- are installed.
So there should be a way MaxDB 7.6.00.16
CREATE DBPROC test AS
BEGIN
STOP(-20020 '123 some cyrillic here 456 ')
END
SQLDBC 7.6.00.16
SQLDBC_PreparedStatement_prepareNTS(imp_sth- >m_prepstmt
statement SQLDBC_String |
|
|
