 | | | MaxDB | | Fabio Pinotti wrote
>
> Hi
> we have the following behaviour when passing parameters from java
> code. The sql statement is something like (executed in oracle mode)
>
> SELECT
> *
>Hi
May be you do not know that this list is for open-source-users of MaxDB only.
We (MaxDB 'ler) are asked NOT to answer here because of guarantee-reasons.
Sorry please ask your local supportHi!
I 'm doing a migration to a SAP db ver 7.3 and I get an error message when the migration
gets to 77% then I get this error message
# R3load version @(#) $Id //bas/40B/src/R3load.c#1 $ SAPMatteo Gattoni wrote
>
> Hello
> I 'm using MaxDb version 7.5.01.00.
> I have a function TO_CHAR2 owned by user PPORTAL that receives a float and
> give me back a char value.
>
> The functiIt seems that when the parser concatenates parameters it has some problems
Here is the test case
create table mycity ( city varchar(100))
insert into mycity( city)values( 'rome ' )
insert into Hello List
we have two independant Web Applications runnning
one already on SAPDB one still on Adabas (which we want to get rid off).
In the future the Database for the two applications shou Matteo Gattoni wrote
>
> Hello
> I have a column varchar(4000) in a table.
> When I use it I have some problems
> 1)
> SELECT s.*
> FROM SEGMENT_TYPE s
> order by s.c_tree_pHi
1. Best Version of MYSQL for very large Tables
Can I get some tips for which MySQL version to use
For maintaining a large DB with 100-200 million row master table
With a lot of inserts.
how can I detect and kill a (individual) connection that is tying up the
database for other users.
Hello
I have a column varchar(4000) in a table.
When I use it I have some problems
1)
SELECT s.*
FROM SEGMENT_TYPE s
order by s.c_tree_path
give me the error
General A.Beermann@(protected) wrote
> Hello !
>
> Hello !
>
> Help with grant and usergroups needed.
>
> Just trying to understand the basics -)
>
> I need two kind of users in my db !
> progHoelker Juergen wrote
>
> Hi
>
> Ich bin bei der Portierung von Adabas nach SAPDB 7.4 und hab probleme mit
> SELECT FIRST-Anweisungen z.B. bei
>
> SELECT FIRST Afonr Afo Wverknr Mschnam Hello !
Hello !
Help with grant and usergroups needed.
Just trying to understand the basics -)
I need two kind of users in my db !
programmer (can do everything with tabels drop alter inHi
Ich bin bei der Portierung von Adabas nach SAPDB 7.4 und hab probleme mit
SELECT FIRST-Anweisungen z.B. bei
SELECT FIRST Afonr Afo Wverknr Mschnam Bemerk1 INTO P_1 IND P_2
INThis is the best documentation I 've found on creating a maxdb instance.
It also has other installation instructions.
http //www.transporeon.org/download/sapdb/maxdb_installation_administrat
ion.p
Not sure if this is the correct place for this but I 'm having the following
problem
I 'm installing SAP Content Server using SAP 's sapinst gui tool. I choose
the option to install Content Serv
Hi
we are trying to migrate slowly from msql to maxdb 7.5 ........ currently we
have an aplication that works with msql but new functionalities are
implemented in maxdb instead of mssql theHello
I have the following procedure (in reality mine is a bit more complex but this is usefull).
DROP FUNCTION ISEMPLOYEEINCONTEXT
//
CREATE FUNCTION ISEMPLOYEEINCONTEXT (COMPANYID FIXED(Hi
does anybody know a DDL Extraction Tool for SAPDB?
Regards Timo
--
Timo Denis IT department
DBA / Developer / Administrator [LPIC1]
IEE S.A. International Electronics & EngineerinHi
I just noticed that for the past few days my complete data backup is
Staying at 2GB exactly.
This does not seem correct as each day the incremental grows by around 400MB
(we recently losHello !
I asked this befor with no answer ?
I tried a little more.
In the SQL-Studio(7.5.00.03) dialog(connected as dba) i did
create usergroup xyz standard
execution ok
refresh
Hello experts
could someone please let me know if there is exclusive
service guard extended package for sapdb. i am setting up cluster on
Linux Redhat AS 2.1. IHi
Is it possible to get the Data and Log used % of a DB Instance from an
SQL query via ODBC rather than from dbmcli (info state)?
Thanks
Adam Wendt
IPCoast Inc.
--
MaxDB DiscussHi
I get an error with the following statement on 7.5.01.00 (in SqlStudio)
insert into table1 (col1 col2)
select 1 2 from dual
where not exists (select 1 from table where col1 1)
TheUsing the same function in a more complex sql statement I receive the error
General error -602 System error Move error.
The query is the following. The function is used only in first subquery
Hello
I 'm using MaxDb version 7.5.01.00.
I have a function TO_CHAR2 owned by user PPORTAL that receives a float and give me back a char value.
The function is created like this in Oracle mode (Sorry I forgot knldiag output
...
...
...
2004-06-16 15 12 55 17235 54003 dynpool LOCK SupplyPoolSize 801424
2004-06-16 15 12 55 17235 54003 dynpool LOCK ObjColl_list size Hello.
I 'm using 7.4.3.32 on a SuSE 9.1 system.
After a crash the DB won 't warmup again. In the knldiag.err I got the
following
I 'm trying to get maxdb-76 to compile on Solaris/x86 but the compile is
throwing errors
!irconf -r -p $INSTROOT > /dev/null
!$TOOLSHELL -S ifaconf.pl $INSTRUNTIME
/home/sapdb/maxdb-76/usr/runtiHeiko Giesselmann wrote
> Hi
>
> I have an application that works in Oracle mode. There is a table with a
> timestamp field and I am looking for a way to add an integer
> representing sec |
|
|
