assigned user roles

Hi, I've got some questions about user administration on maxdb. I understand the user concept and role concept but I don't understand how to administer many users without confusion. Some questions : - is there a comfortable tool/way that helps to administer privileges and roles - how can I

How do I use 'session number'?

I have a little confusion about ‘session number’ when a cpc program connects to MaxDB Server. What is its range? Can it be defined as any integer I want? I would assign a connection to each thread when multi thread is involved. Then is there any change to the definition of sqlca and sqlda? Thanks

RE: Data Type Casting

Alan Penny wrote: > > I'm trying to write a SQL statement that needs > some data type casting/conversion. I can't > seem to find the documentation to do this. > > The following expression: > > rec_entry_date > SUBTIME(TIME, '00:15:00') > > Gives the error: > > Integrity co

Re: ebuild for gentoo to build maxd 7.5.0.8 from sources

Hi Martin ! Im giving my best to reproduce your compilation error but i can't. The only way i can get the same error for vni90c.c is when i directly try to build the target sqlfilter.lnk (which is not ment to be built seperatly). As soon as i build the cpc.mac everything is fine. And the ebuild do

Re: FW: KNLDIAGERR

Edward, I'm new to this thread, but --- have you checked to see if those files exist? Have you looked at the permissions? I propose a few ideas, though I don't know how successful you will find them: 1. What's failing here is a call do dlopen(3) (see "man dlopen") you should check: a) tha

RE: KNLDIAGERR

> not know where the xregcomp program is in my unix environment. it's not in your unix environment but in the delivered DB binaries: siauee:t02adm 65> find /sapdb/ -name "xreg*" -print /sapdb/T02/bin/xregcomp so it's in your sapdb installation path. Greetz, SIEGENIA-AUBI KG Informationswesen

Re: FW: KNLDIAGERR

Sorry, I've no idea, but this brings up a meta-issue for me. I'm evaluating MaxDB for some internal projects and have to seriously look at how easy it is to get answers for issues that may come up. I'd hate to get in a position where something really strange is happening, I ask for some help

Re: changing SYSDBA password

Torsten/Tom, Whoops! Perhaps I should have my morning coffee before posting to the list. For some reason I thought Tom was talking about the First Database Manager Operator. According to the docs the First Database Manager Operator's password cannot be changed once set. _This_ is still valid, n

Re: Unix_TimeStamp

Pius, Edward wrote: What should the statement "Select Unix_timestamp()" return? When I do this in SQL Studio, it errors out. But when I do "Select Unix_timestamp(now())" it returns the current timestamp. I was expecting the second statement to return the number of seconds elapsed from 1970-

Unix_TimeStamp

Hello, What should the statement "Select Unix_timestamp()" return? When I do this in SQL Studio, it errors out. But when I do "Select Unix_timestamp(now())" it returns the current timestamp. I was expecting the second statement to return the number of seconds elapsed from 1970-01-01 00:00

FW: KNLDIAGERR

Hello SAP folks, Could you please let me know if there is a solution to this problem? In appreciation, Edward Pius -Original Message- From: Pius, Edward [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 8:38 AM To: [EMAIL PROTECTED] Subject: KNLDIAGERR Hello,

Re: Data Type Casting

Le mardi 13 avril 2004, Alan Penny a écrit... bonjour, > rec_entry_date > SUBTIME(TIME, '00:15:00') Can't you use sth like: NUM (SUBTIME (TIME, '1500')) or FIXED (NUM (SUBTIME (TIME, '1500')), x) x being an integer for FIXED function -- jm -- MaxDB Discussion

RE: changing SYSDBA password

Hi Tom, you should be able to change the password of the SYSDBA!!! Unfortunately the DBMGUI throws the error you describe (-24988). It seems to be a bug and I have informed the responsible developer. Regards, Torsten SAP DB, SAP Labs Berlin -Original Message- From: John L. Singleton [mai

Data Type Casting

I'm trying to write a SQL statement that needs some data type casting/conversion. I can't seem to find the documentation to do this. The following expression: rec_entry_date > SUBTIME(TIME, '00:15:00') Gives the error: Integrity constraint violation;-8006 POS(61) Data t

RE: Problems with dynamic ODBC and iodbc on Linux

Hi Norbert, > -Original Message- > From: Norbert Mende [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 7. April 2004 13:46 > To: Koetter, Thomas Theodor; [EMAIL PROTECTED] > Subject: AW: Problems with dynamic ODBC and iodbc on Linux > > > Hello Thomas, > > the program terminates "correctly"

Re: changing SYSDBA password

Hi Tom, Once you set the SYSDBA password, you can't change it. You can, however, change the password of other DBM users. Cheers, JLS [EMAIL PROTECTED] wrote: Hi to all, we use sapdb in an test environment (it's version 7.4.3 Build 017-123-039-277). When I try to change the SYSDBA password wi

Re: Deadlock detection

Hi, It seems that we have exactly the same problem as described below. A detail that maybe could provide some help: clients are blocked on a specific table; other clients that do not access that specific table continue to work fine. Has anybody else encountered this problem ? Possible causes/s

Transferring MySQL Database to MAXDB

I am new to MAXDB. I have been using MySQL for awhile now though. I have a database that I have in MySQL that I need to transfer over to the MAXDB. I have the newest MAXDB as of Yesterday. I have MySQL 4.0.18. Is there a way to transfer the MySQL DB to MAXDB without fully recreating all the ta

changing SYSDBA password

Hi to all, we use sapdb in an test environment (it's version 7.4.3 Build 017-123-039-277). When I try to change the SYSDBA password with dbmgui or user_put direct I get an error message : -24988 sql error Can anybody help me Best regards tom