RE: -999 Not implemented yet.
--0-128396693-1075390578=:73801
Content-Type: text/plain; charset=us-ascii
It looks like Ravi was right. You have a LVARCHAR (des_documento lvarchar) on the table. It along with BOOLEAN and probably some others will cause this error when an attempt is selected from another database. A work around for your version of IDS would be to create a view that selects all columns accept the LVARCHAR then make your remote select on that view. If you were needing the data in the LVARCHAR column your out of luck. You'll have to open a connection to directly to ecofin@e3500desa_tcp and execute the select on that connection.
LUQUE Valdivia Omar <luque001@marina.mil.pe> wrote:
Hi,
Schema :
--------------
CREATE TABLE "informix".cuentas_corrientes
(
cod_empresa character(5) NOT NULL,
cod_anho character(4) NOT NULL,
cod_tipo_documento character(3) NOT NULL,
cod_num_doc character(10) NOT NULL,
cod_tipo_analitico character(1),
cod_analitico character(15),
cod_tipo_doc_ent character(3),
num_serie character(4),
num_documento character(20),
cod_pagar_cobrar character(1),
flg_acr_deb character(1),
cod_moneda character(3),
dtm_documento datetime YEAR TO MINUTE,
des_documento lvarchar,
fac_porcetaje_igv decimal(7,3),
imp_tipo_cambio decimal(7,3),
imp_afecto decimal(15,2),
imp_inafecto decimal(15,2),
imp_impuesto decimal(15,2),
imp_neto_me decimal(15,2),
imp_neto decimal(15,2),
imp_girado_me decimal(15,2),
imp_girado decimal(15,2),
imp_rebajado_me decimal(15,2),
imp_rebajado decimal(15,2),
num_dias_vcmto integer,
dtm_vencimiento datetime YEAR TO MINUTE,
dtm_cancelacion datetime YEAR TO MINUTE,
flg_transmitido character(1),
cod_estado character(3),
cod_sec_fase character(4),
cod_sec_correl character(4),
flg_efectivo character(1),
cod_empresa_act character(5),
cod_act_com character(3),
cod_item character(2),
cod_anho_banco character(4),
cod_banco character(5),
cod_cuenta_banc character(15),
cod_dcmto_bancario character(3),
cod_num_dcmto_ban character(15),
dtm_dcmto_bancario datetime YEAR TO MINUTE,
cod_tipo_rec character(1),
num_formato character(10),
dtm_formato datetime YEAR TO MINUTE,
flg_conciliado character(1),
fac_cop decimal(7,3),
fac_gaf decimal(7,3),
fac_mec decimal(7,3),
imp_cop decimal(15,2),
imp_gas decimal(15,2),
imp_gaf decimal(15,2),
imp_mec decimal(15,2),
userid varchar(20,0),
funcid varchar(20,0)
)
I have informix 9.21 on Unix Solaris 7.
-----Mensaje original-----
De: DL Redden [mailto:redden96@yahoo.com]
Enviado el: Mi'rcoles, 28 de Enero de 2004 03:53 p.m.
Para: LUQUE Valdivia Omar; informix-list@iiug.org
Asunto: Re: -999 Not implemented yet.
What version(s) are you using? What is the schema for the table ecofin@e3500desa_tcp:cuentas_corrientes?
LUQUE Valdivia Omar <luque001@marina.mil.pe> wrote: Hi every body,
Help me please...
I can`t do that :
-----------------
select * from ecofin@e3500desa_tcp:cuentas_corrientes
I get the following error :
---------------------------
-999 Not implemented yet.
I don`t understand why!
-----------------------
#more sqlhosts
# Servidor Desarrollo e3500desa
e3500desa_shm onipcshm ucayali dummy
e3500desa_tcp ontlitcp ucayali e3500desa_tcp
#------------------------------------------------------------
# Servidor Primario ecofin1 - Salaverry
ecofin1_shm onipcshm ucayali dummy
ecofin1_tcp ontlitcp ucayali ecofin1_tcp
#more hosts.equiv
amazonas
I never before had that problem...
Thank's
Omar.
sending to informix-list
---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
--0-128396693-1075390578=:73801
Content-Type: text/html; charset=us-ascii
<DIV>It looks like Ravi was right. You have a LVARCHAR (<FONT color=#0000ff>des_documento lvarchar)</FONT> on the table. It along with BOOLEAN and probably some others will cause this error when an attempt is selected from another database. A work around for your version of IDS would be to create a view that selects all columns accept the LVARCHAR then make your remote select on that view. If you were needing the data in the LVARCHAR column your out of luck. You'll have to open a connection to directly to <A href="mailto:ecofin@e3500desa_tcp">ecofin@e3500desa_tcp</A> and execute the select on that connection.</DIV>
<DIV><BR><B><I>LUQUE Valdivia Omar <luque001@marina.mil.pe></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2>Schema :</FONT></SPAN></DIV>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2>--------------</FONT></SPAN></DIV>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=570264321-26012004><FONT face=Arial color=#0000ff size=2>CREATE TABLE "informix".cuentas_corrientes<BR> (<BR> cod_empresa character(5) NOT NULL,<BR> cod_anho character(4) NOT NULL,<BR> cod_tipo_documento character(3) NOT NULL,<BR> cod_num_doc character(10) NOT NULL,<BR> cod_tipo_analitico character(1),<BR> cod_analitico character(15),<BR> cod_tipo_doc_ent character(3),<BR> num_serie character(4),<BR> num_documento character(20),<BR> cod_pagar_cobrar character(1),<BR> flg_acr_deb character(1),<BR> cod_moneda character(3),<BR> dtm_documento datetime YEAR TO MINUTE,<BR> des_documento lvarchar,<BR> fac_porcetaje_igv decimal(7,3),<BR> imp_tipo_cambio decimal(7,3),<BR> imp_afecto decimal(15,2),<BR> imp_inafecto decimal(15,2),<BR> imp_impuesto decimal(15,2),<BR> imp_neto_me decimal(15,2),<BR> imp_neto decimal(15,2),<BR> imp_girado_me
decimal(15,2),<BR> imp_girado decimal(15,2),<BR> imp_rebajado_me decimal(15,2),<BR> imp_rebajado decimal(15,2),<BR> num_dias_vcmto integer,<BR> dtm_vencimiento datetime YEAR TO MINUTE,<BR> dtm_cancelacion datetime YEAR TO MINUTE,<BR> flg_transmitido character(1),<BR> cod_estado character(3),<BR> cod_sec_fase character(4),<BR> cod_sec_correl character(4),<BR> flg_efectivo character(1),<BR> cod_empresa_act character(5),<BR> cod_act_com character(3),<BR> cod_item character(2),<BR> cod_anho_banco character(4),<BR> cod_banco character(5),<BR> cod_cuenta_banc character(15),<BR> cod_dcmto_bancario character(3),<BR> cod_num_dcmto_ban character(15),<BR> dtm_dcmto_bancario datetime YEAR TO MINUTE,<BR> cod_tipo_rec character(1),<BR> num_formato character(10),<BR> dtm_formato datetim