RE: -999 Not implemented yet.

Posted in 2004

LUQUE Valdivia Omar — Wed, 28 Jan 2004 16:46:49 -0500 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C3E5E8.3BFF8722 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, =20 =20 Schema : -------------- =20 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) ) =20 =20 I have informix 9.21 on Unix Solaris 7. =20 =20 =20 -----Mensaje original----- De: DL Redden [mailto:redden96@yahoo.com] Enviado el: Mi=E9rcoles, 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:=20 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!=20 ----------------------- #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 _____ =20 Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. = <http://us.rd.yahoo.com/evt=3D21608/*http://webhosting.yahoo.com/ps/sb/>; = Try it! ------_=_NextPart_001_01C3E5E8.3BFF8722 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD> <BODY> <DIV>Hi,</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Schema=20 :</DIV> <DIV>--------------</DIV> <DIV> </DIV> <DIV>CREATE=20 TABLE "informix".cuentas_corrientes  (  cod_empresa = character(5)=20 NOT NULL,  cod_anho character(4) NOT = NULL,  cod_tipo_documento=20 character(3) NOT NULL,  cod_num_doc character(10) NOT=20 NULL,  cod_tipo_analitico character(1),  cod_analitico=20 character(15),  cod_tipo_doc_ent = character(3),  num_serie=20 character(4),  num_documento = character(20),  cod_pagar_cobrar=20 character(1),  flg_acr_deb character(1),  cod_moneda=20 character(3),  dtm_documento datetime YEAR TO=20 MINUTE,  des_documento lvarchar,  fac_porcetaje_igv=20 decimal(7,3),  imp_tipo_cambio decimal(7,3),  imp_afecto = decimal(15,2),  imp_inafecto = decimal(15,2),  imp_impuesto=20 decimal(15,2),  imp_neto_me decimal(15,2),  imp_neto=20 decimal(15,2),  imp_girado_me decimal(15,2),  imp_girado = decimal(15,2),  imp_rebajado_me = decimal(15,2),  imp_rebajado=20 decimal(15,2),  num_dias_vcmto integer,  dtm_vencimiento = datetime YEAR TO MINUTE,  dtm_cancelacion datetime YEAR TO=20 MINUTE,  flg_transmitido character(1),  cod_estado=20 character(3),  cod_sec_fase = character(4),  cod_sec_correl=20 character(4),  flg_efectivo = character(1),  cod_empresa_act=20 character(5),  cod_act_com character(3),  cod_item=20 character(2),  cod_anho_banco character(4),  cod_banco=20 character(5),  cod_cuenta_banc=20 character(15),  cod_dcmto_bancario=20 character(3),  cod_num_dcmto_ban=20 character(15),  dtm_dcmto_bancario datetime YEAR TO=20 MINUTE,  cod_tipo_rec character(1),  num_formato=20 character(10),  dtm_formato datetime YEAR TO=20 MINUTE,  flg_conciliado character(1),  fac_cop=20 decimal(7,3),  fac_gaf decimal(7,3),  fac_mec=20 decimal(7,3),  imp_cop decimal(15,2),  imp_gas=20 decimal(15,2),  imp_gaf decimal(15,2),  imp_mec=20 decimal(15,2),  userid varchar(20,0),  funcid=20 varchar(20,0)  ) </DIV> <DIV> </DIV> <DIV><SPAN class=3D570264321-260

RE: -999 Not implemented yet.

Related threads

Your privacy choices