Wrong free space estimation of SDBINST on AIX 5L

2005-03-09 Thread Gerd . Wetzel
Hello. I'M trying to install MaxDB 7.5.00.23 on AIX 5.1 ML 07 output of 'oslevel -r' : 5100-07 I'm trying to install all components to the default locations. During the verification step SDBINST tells me: ... package PCR 7301 successfully checked checking filesystem "/opt"... not enough free

Re: Correlated subquery not allowed?

2005-03-09 Thread Edson Carlos Ericksson Richter
Forgot to mention: the view is composed by 4 "union" Regards, Edson Richter. Edson Carlos Ericksson Richter escreveu: Hi! Using MaxDB 7.5.0.23, executing following query: select B.CO_1, B.DS_3, (select count(*) from TB_1 where CO_1 = B.CO_1) as NU_ITENS,

Correlated subquery not allowed?

2005-03-09 Thread Edson Carlos Ericksson Richter
Hi! Using MaxDB 7.5.0.23, executing following query: select B.CO_1, B.DS_3, (select count(*) from TB_1 where CO_1 = B.CO_1) as NU_ITENS, (select count(*) from TB_2 BAA join VI_1 BUG on BAA.CO

AW: Problem: General error;-2003 POS(220) Output columns too long

2005-03-09 Thread Zabach, Elke
Kevin Wilson wrote: > > version 7.5.0.23:64bit:ascii on linux64 (opteron). > > I have 11980 bytes in varchar plus 3 integer output columns in my join > query, I think this is very small considering the data we have to store > and > fetch these days. Error occurs using both the jdbc driver in our

RE: Please Help! Pythondriver says: ERR -11608 COMMUNIC sql03_request: wrong connection state, state is 'requested'

2005-03-09 Thread Dittmar, Daniel
>the real problem seems to me that when more than >8(=firstChunk) connections >are opened, the function sql03_realloc_pool will be called, which >reserves memory for 16 connections copies the old memory and frees it. I've changed the code to realloc an array of pointers and not an array of conne