Re: ¿ How to concatenate string and date types in a SQL Sentence ?

Try select chr(month(curdate())) & ' ABCD ' from table [EMAIL PROTECTED] wrote: I am trying to concatenate in a SQL Sentence a result of a function date with a string: SELECT MONTH ( CURDATE ( ) ) & ' SOMETHING... ' FROM DBA.DUAL But I got the message: Auto Commit: On, SQL Mode: Internal, Isolat

Error assigning a string to a date type in a DBPROC

I am trying in a DBPROC to assign a char variable to a date variable but there is a message "Datetime field overflow;-3048 POS(1) Invalid date format:ISO". ¿How can I convert the string to a date variable? The procedure is the next: ***

¿ How to concatenate string and date types in a SQL Sentence ?

I am trying to concatenate in a SQL Sentence a result of a function date with a string: SELECT MONTH ( CURDATE ( ) ) & ' SOMETHING... ' FROM DBA.DUAL But I got the message: Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Integrity constraint violation;-8006 POS(16) Data types

AW: question about ALPHA and SOUNDEX function

Josu wrote: > > Hi, > > we are trying to implement a search method to grab the best results > and the most with a keyword given (keyword=a country, a province, a > city ) > > Until now we don't know how to do ALPHA queries, we try: > > select name,alpha(name) from countries where alpha(name

Re: creating new db instance (on Linux server) using DBMGui (on PC) [linux issue?]

bonjour, Le lundi 07 février 2005, Jon Loken a écrit... > --> loader.LoaderError: loader.LoaderError [-250041] A connection to the > database could not be established: 1=cannot connect to server socket > Does anyone have any suggestions to what I can try in order to create this > instan

creating new db instance (on Linux server) using DBMGui (on PC) [linux issue?]

me dbm.ins: // MLoader7.5.0Build 015-121-074-675 // * // MLoaderinstance started at metadata-serve // * // MStarting protocol at 2005020700115931 // * // * // * // MSTART 2005020700115931 // * set logowner sdb // * // MSTART 2005020700115931 // *

RE: Surge in IO writes by kernel.exe

> Hi Döhr, > Does the size of the data cache have any bearing on the amount > of data written. i.e. will a smaller DATA CACHE reduce the magnitude of > the surge? Certainly - but then again it will slow down your queries, too, and also lead to more frequent write operations. I would not bel

RE: Question about Log Mode(s)

[...] >> Hello Andre, >> >> 'auto log overwrite' "clears" only these parts of the log which are >> older then the last savepoint. >> So you can always restart after a powerfailure. The 'auto >log overwrite' >> feature is only to avoid log backups and has nothing to do with the >> savepoint and it

question about ALPHA and SOUNDEX function

Hi, we are trying to implement a search method to grab the best results and the most with a keyword given (keyword=a country, a province, a city ) Until now we don't know how to do ALPHA queries, we try: select name,alpha(name) from countries where alpha(name) like/= alpha(keyword) It resul

RE: Surge in IO writes by kernel.exe

Hi Döhr, Does the size of the data cache have any bearing on the amount of data written. i.e. will a smaller DATA CACHE reduce the magnitude of the surge? Regards, Ajit -Original Message- From: Döhr [mailto:Döhr] Sent: Sunday, February 06, 2005 3:22 AM To: 'Ajit Aranha'; 'maxdb@li

Re: Question about Log Mode(s)

Hahn, Uwe wrote: [...] But what will happen in the same scenario when changes are not in the Datavolume, but only in the cache, and the Logvolume was cleared because it was full 1 second before the powerfailure? Here the operator loose the right to use this name !!! Don't ever try to use a database