diff -uNr DBD-MaxDB-7.5.00.32.origin/dbdimp.c DBD-MaxDB-7.5.00.32/dbdimp.c
--- DBD-MaxDB-7.5.00.32.origin/dbdimp.c 2005-09-12 15:26:20.0 +0900
+++ DBD-MaxDB-7.5.00.32/dbdimp.c2005-09-21 11:08:12.0 +0900
@@ -222,6 +222,7 @@
DBD_ERR_VALUE_OVERFLOW_D,
DBD_ERR_PARAMET
SQLDBC_Connection_connectNTS(imp_dbh->m_connection,
host,
dbname,
user,
password,
SQLDBC_StringEncodingType
2005/9/20, Jens-Peter C. Hillers <[EMAIL PROTECTED]>:
> > May be true for 32, but for 2000 ??
> so take the middle ! were talking about 64K. I'll think some Megabytes are
> your Problem !
> or use select count(*)*avg(length(YourVarcharField)) from t1
select sum(length(YourVarcharField)) from t1 wh
Andreas Goldstein wrote :
>> --- Ursprüngliche Nachricht ---
>> Von: "Anhaus, Thomas" <[EMAIL PROTECTED]>
>> An: "Andreas Goldstein" <[EMAIL PROTECTED]>,
>>
>> Betreff: AW: [FSID] How to drop a public function?
>> Datum: Tue, 20 Sep 2005 10:50:16 +0200
>>
>> Andreas Goldstein wrote :
>>
>> >
>>
> -Ursprüngliche Nachricht-
> Von: Zabach, Elke [mailto:[EMAIL PROTECTED]
> Gesendet am: Dienstag, 20. September 2005 16:09
> An: [EMAIL PROTECTED]; Ralf Schneider; maxdb@lists.mysql.com
> Betreff: AW: How to track DB usage of user
>
> Jens-Peter C. Hillers wrote:
> >
> > Hi,
> >
> > I thin
Jens-Peter C. Hillers wrote:
>
> Hi,
>
> I think the "normal" tables could be estimated.
>
> row by size (varchar (32) = 32) will result in a good guess
>
May be true for 32, but for 2000 ??
> BUT
>
> the problem will be that there is NO way of evaluating the size og a blob
> (long ascii or
All,
Just incase someone else runs into this problem in the future, I
believe I figured out what the problem was. I continued to get the error
until I did a load_systab. I thought I had done that after the last
upgrade but maybe I didn't. I was able to change the password after that.
Thanks
> --- Ursprüngliche Nachricht ---
> Von: "Anhaus, Thomas" <[EMAIL PROTECTED]>
> An: "Andreas Goldstein" <[EMAIL PROTECTED]>,
>
> Betreff: AW: [FSID] How to drop a public function?
> Datum: Tue, 20 Sep 2005 10:50:16 +0200
>
> Andreas Goldstein wrote :
>
> >
> >Hi Listmembers,
> >
> >I defined a p
Hi,
I think the "normal" tables could be estimated.
row by size (varchar (32) = 32) will result in a good guess
BUT
the problem will be that there is NO way of evaluating the size og a blob
(long ascii or long byte) in a SQL Statement
like
select sum(datalen(MYBLOB)) from T1
regrads
jph
P.S
Am Dienstag, 20. September 2005 14:58 schrieb Robert Klemme:
> Then probably a limit different from bytes makes more sense? Maybe
> something that can be directly translated into record counts (max
> contacts or similar).
That's right from a developers perspective, but not from a sales perspectiv
Then probably a limit different from bytes makes more sense? Maybe
something that can be directly translated into record counts (max
contacts or similar).
Btw, Elke ad 2: I simply picked a bad name, as the "user" really
should be the name of the column that stores the user name or user id.
My ba
Am Dienstag, 20. September 2005 13:44 schrieb Zabach, Elke:
> 5. The szenario that different people have to share one table, but are
> limited to some amount of space, seems to me uncommon. May I ask for
> some background-info?
> I think that info stored in a table used by different people is reall
>I was used to ireport, for sql queries, with the 7.5 maxdb releases.
>
>Is ireport deprecated in 7.6 release (7.6.00.12) ?
Basically yes, sqlcli should be used instead. So ireport won't get any
new features and will probably be removed later on. Of course, you can
still use your copy, as the unde
Ralf Schneider wrote:
>
> Am Montag, 19. September 2005 17:28 schrieb Robert Klemme:
> > You could do reports like
> >
> > select user, count(*)
> > from your_table
> >
> > to see which user takes up how much space of the table. If you
> > combine this with information about the whole table's siz
Andreas Goldstein wrote :
>
>Hi Listmembers,
>
>I defined a public function on my 7.6.00.12-Windows MaxDB. Now
>I would lik
>to change the function, but I can not drop the old version :(
>
>
>
>Here is what I did in more detail:
>
>Logged into the DB-instance as DBAdmin
>CREATE PUBLIC FUNCTION KD
15 matches
Mail list logo