AW: SELECT FIRST

Hoelker, Juergen wrote: > > Hi, > > sorry, newbee alert :) > Ok, but is there a quick way to keep the funktionality of the "SELECT > FIRST/NEXT/..." Statement only with SELECT? I've got plenty of them and > don't want to surround everyone with more code... > A 'quick' way is to substitute SELE

AW: Limit on lenght in columns

: 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_path > > give me the error > General error;-1013 POS(2001) Too many order columns. > > We resolve the

Handling very large tables - Insert Performance

Hi, 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. e.g. Is MAXDB version specifically setup for this ? 2. Fastest Loading of Data in Master Table Can I lo

Killing individual connections

how can I detect and kill a (individual) connection that is tying up the database for other users.

Re: DDL Extraction Tool

Hi, loadercli does the trick. Try this: # loadercli -d -u dba,dba_password > USE USER user_name user_password SERVERDB db_name > CATALOGEXTRACT USER OUTSTREAM FILE schema.ddl For more details see documentation for loadercli. Cheers. Alexei --- Timo Denis <[EMAIL PROTECTED]> wrote: > Hi, > >

RE: SAPDB Standby database setup.

Hi Uwe, I am running SAPDB 7.4.3.32-1 (Value of KERNELVERSION is KERNEL 7.4.3 BUILD 032-121-068-842) on Linux SuSE 8.2 (with all the latest patches). It is latest 7.4.3 build I guess. Also on recover_cancel the instance status becomes offline - is it supposed to be this way? Are there any prerequi

Limit on lenght in columns

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 error;-1013 POS(2001) Too many order columns. We resolve the problem using Select s.* from segment

AW: SELECT FIRST

Hi, sorry, newbee alert :) Ok, but is there a quick way to keep the funktionality of the "SELECT FIRST/NEXT/..." Statement only with SELECT? I've got plenty of them and don't want to surround everyone with more code... Greets, **Jürgen** -Ursprüngliche Nachricht- Von: Zabach, Elke [

RE: Help with grant and usergroups needed.

Instead of using groups have a look at using roles. I think you may need to create public synonyms though if you only want to use the table name and not owner.name Stand to be corrected though. Regards Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thurs

AW: Help with grant and usergroups needed.

[EMAIL 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 ! > programmer (can do everything with tabels drop,alter index, delete > update ) > normaluser (select,insert,update,d

AW: SELECT FIRST

Hoelker, 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, Bemerk1 INTO :P_1 :IND, :P_2 > :IND, > :P_3 :IND, :P_4 :IND, :P_5 :IND FROM WZV_AFOS KEY Tverknr = :P_

Help with grant and usergroups needed.

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 index, delete update ) normaluser (select,insert,update,delete) First i had two users: programmer resourc

SELECT FIRST

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, Bemerk1 INTO :P_1 :IND, :P_2 :IND, :P_3 :IND, :P_4 :IND, :P_5 :IND FROM WZV_AFOS KEY Tverknr = :P_6,WHERE Tindex = :P_7 bekomme ich f

RE: Installing sap db 7.3 using sapinst

Loren, This is a link to documentation on installing maxdb. http://www.transporeon.org/download/sapdb/maxdb_installation_administrat ion.pdf I am working on a web site that uses maxdb, not on SAP Content Manager. So I have to create a database instance manually, not run a script. Inside of the s

creating a maxdb instance, solving problems activating/starting database instance

This 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.pdf I was working with another person. He actually installed the maxdb software. I built the database.

Re: Backup file size

I've forgotten that you have also the possibility to use a faster copying if you are using SSH Protocol 2 by using the -blowfish option. For bigger files/backups this is much more efficient. Georg Thome wrote: Are you doing the backup on a medium which is on a NFS-share or similar? This might be th

RE: -24994 runtime environment error [service_connect ]

Hello Eko, Do you have restricted access rights to /dev/null ? Best Regards, Tilo Heinrich SAP Labs Berlin >-Original Message- >From: Eko Subagio [mailto:[EMAIL PROTECTED] >Sent: Tuesday, June 15, 2004 11:05 AM >To: [EMAIL PROTECTED] >Subject: -24994 runtime environment error [service_c

Installing sap db 7.3 using sapinst

I don't think my e-mail made it through the first time, but if it did sorry for the duplicate. 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

Installing sap db 7.3 using sapinst

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 Server with the SAP DB version 7.3. Everything goes fine until the activation phase of the database which fa

Re: Backup file size

bonjour, Le jeudi 17 juin 2004, Michael Andrewes a écrit... > I am running redhat linux 7.3. It's an old distribution so, if not updated, I'm not sure that RH 7.3 has LFS support. -- jm -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscri

Migrating from MS SQL Server 7

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, the problem is that we dont want to change ALL the tables and functionality to Max. We want to map a maxdb

using TIMESTAMP

Hello, 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(9,0), HUMANRESOURCEID FIXED(9,0), DSTARTCHR TIMESTAMP) RETURNS NUMBER AS VAR RES INT; TRY SELECT 1 INTO

Fw: using TIMESTAMP

Hello, 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(9,0), HUMANRESOURCEID FIXED(9,0), DSTARTCHR TIMESTAMP) RETURNS NUMBER AS VAR RES INT; TRY SELECT 1 INTO

RE: sapdb serviceguard extended package

> 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. If so, from where > can i download it? please let me know. I certainly hope to > recieve an answer at the earliest. As far as

DDL Extraction Tool

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 & Engineering Zone Industrielle, L-6468 Echternach, Luxembourg Phone +(352)72 89 89-6801/6791, Fax +(352)72 89 89-6109 This e-

RE: SQL-Studio Problem

Hello Albert, > I asked this befor with no answer ? the more product specific subject does it now. > In the SQL-Studio(7.5.00.03) dialog(connected as dba) i did : > create usergroup xyz standard > execution ok > refresh > everything ok ! the usergroup is shown under owned users > then i did

RE: Data/Log Size via SQL Query

Here are the requests you asked for: Select "Log (%)" From INFO_STATE Select "Data(%)" From INFO_STATE take care of spaces number and double quote... you can check "Select * from INFO_STATE" to have an overview of all statistics that are available Stéphane -Message

Re: Backup file size

Are you doing the backup on a medium which is on a NFS-share or similar? This might be the reason. Use a pipe medium and do a piping like cat /var/opt/sapdb/pipe | ssh [EMAIL PROTECTED] cat - \> /backup/filename or with zip cat /var/opt/sapdb/pipe | ssh [EMAIL PROTECTED] gzip -1 - \> /backup/filena

Backup file size

Hi, 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 lost a lot of data, and hence have started more regular backups, and had to grow back up to > 2gb). I am ru

SQL-Studio Problem

Hello ! 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 everything ok ! the usergroup is shown under owned users then i did create user password usergroup