RE: Error while installing MAXDB on suse LINUX

Hello Naveen, It seems, that parts of an old installation are lingering around on your system. If and only if you are sure that no other MaxDB versions should be on the system please clean up as follows: rm /etc/opt/sdb rm -rf /usr/spool/sql rm -rf /var/spool/sql rm -rf /sapdb Best regards, Tilo

RE: SAP DB ERROR

Hello Daniel, Does creation of directory /var/opt/sapdb/indep_data/wrk/CQ... (probably the rundirectory of yor database) solve the problem? If not do you min providing us with the context of the problem? Best regards, Tilo Heinrich SAP Labs Berlin -Original Message- From: Daniel Castro S

RE: Date in the name of the backup file

Hello Daniel, Currently the only way to achiev this, is to create a new backup medium each time before a backup, e.g. using a script and the DBMCLI commands medium_put, backup_start and medium_delete. Best regards, Tilo -Original Message- From: Daniel Castro Sent: Dienstag, 20. Juni 200

RE: addDate could not add monthes

Hello Thomas, finally I suggest ABS((MONTH(TIMESTAMP) - MONTH(Au_RechDatum)) + (YEAR(TIMESTAMP) - YEAR(Au_RechDatum) ) * 12) for a number of months even extending a year. -Original Message- From: Thomas Stegbauer [mailto:[EMAIL PROTECTED] Sent: Dienstag, 20. Juni 2006 16:16 To: Thom

Date in the name of the backup file

Hi, Is there anyway to put the date in the name of the backup file. Exmple: 20060619CompleteF 20060620CompleteF So, by this way we can have more backup files in the server. Thank You, -- Daniel Castro Website: http://danielti.no-ip.info:2139 MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 3167

Re: Query identification

Hi Robert, Unfortunelly not. Nobody aswered me. best regards, 2006/6/20, Robert Klemme <[EMAIL PROTECTED]>: Daniel, did you get any answers on this one? Kind regards robert 2006/6/12, Daniel Castro <[EMAIL PROTECTED]>: > Hi, > > I have 2 warnings in dbanalyzer: > > * W3 Deletes selectivi

Re: Query identification

Daniel, did you get any answers on this one? Kind regards robert 2006/6/12, Daniel Castro <[EMAIL PROTECTED]>: Hi, I have 2 warnings in dbanalyzer: * W3 Deletes selectivity 0%: 8 deletes, 6982 rows read, 0 rows qualified CON: DelSel < 0.3 VAL: 0 < 0.3 * W3 155968 physica

Re: addDate could not add monthes

hi alexander, hi elke, the statement got modified like this: select Au_Id,K_Nr,Au_R_Id,Au_R_Pos from Auftrag,Kunden where Au_R_Id = K_Id and (Month(Timestamp) - Month(Au_RechDatum) + 12) mod12 >= Au_nMonate AND Au_Zyklisch = 1 AND Au_StartDatum <= TimeStamp and Au_StopDatum >= Timestampestamp wi

RE: addDate could not add monthes

Thomas Stegbauer wrote: > > hi ml, > > currently we are trying to port a application from a sybase > sql to maxdb > (currently 7.5.00.24-3 as it is shipped with debian 3.1). > > with sybase there is it possible to count nr of month's to a date, and > the database takes care if it has 28, 30, 31

Re: addDate could not add monthes

hi alexander, this could be the solution, cause currently the selections is running in the other direction. select Au_Id,K_Nr,Au_R_Id,Au_R_Pos from Auftrag,Kunden where Au_R_Id = K_Id and AddDate(Au_RechDatum,Au_nMonate*29) < TimeStamp AND Au_Zyklisch = 1 AND Au_StartDatum <= TimeStamp and Au_Sto

SAP DB ERROR

Hi, 3135 ERR 11881 DIAGHIST RTEDiag_MakeCrashHist 'RTEDiag_CreateDirectory' OS error: [[2] No such file or directory, /var/opt/sapdb/indep_data/wrk/CQ] Can you help me? Best regards, -- Daniel Castro Website: http://danielti.no-ip.info:2139 MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 3167

addDate could not add monthes

hi ml, currently we are trying to port a application from a sybase sql to maxdb (currently 7.5.00.24-3 as it is shipped with debian 3.1). with sybase there is it possible to count nr of month's to a date, and the database takes care if it has 28, 30, 31 or even 29 day's. i was unable to find an a

Re: python interface and clob column

The lecture you told me didn't solve my problem with clob fields. the code I use to get the data I need for my application is the following: ... from mod_python import apache, Session, psp, util from string import Template ... _result = req.session['cnn'].prepare('CALL "Gestion

RE: 7.6.00.27 kernel crash

Alexey Gaidukov wrote : > > Hi MaxDB team! > > May I get information about this crash? Will be it fixed in > next versions? > > Thanks in advance, > Alexey Gaidukov. > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists

RE: python interface and clob column

>Can someone tell me how to read data from clob columns via the >maxdb python interface ? The Python interfaces (sdb.sql and sql.dbapi) use SapDB_LongReader objects, see http://dev.mysql.com/doc/maxdb/en/59/0369eb4b5bff4781935cbecd7f248a/fram eset.htm. For INSERTs und UPDATEs of lobs, you can u

Re: 7.6.00.27 kernel crash

Hi MaxDB team! May I get information about this crash? Will be it fixed in next versions? Thanks in advance, Alexey Gaidukov. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

python interface and clob column

Can someone tell me how to read data from clob columns via the maxdb python interface ? Thanks in advance. Luca