RE: -999 Not implemented yet.
Posted in 2004
This is a multi-part message in MIME format.
------_=_NextPart_001_01C3E659.0EDB18DC
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You must be running version 9 of Informix - I haven't worked on that =
for a while, but remember it was a very general message for things the =
engine couldn't do, such as doing a table info on views (if the view was =
created on a table residing on a remote database), which I remember.
=20
Nothing to worry about, it might just limit you in what you need to do =
on the DB.
=20
=20
Dirk
=20
=20
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] =
On Behalf Of LUQUE Valdivia Omar
Sent: Wednesday, January 28, 2004 11:47 PM
To: DL Redden; informix-list@iiug.org
Subject: RE: -999 Not implemented yet.
=20
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?
=09
LUQUE Valdivia Omar <luque001@marina.mil.pe> wrote:=20
Hi every body,
Help me please...
=09
I can`t do that :
-----------------
=09
select * from ecofin@e3500desa_tcp:cuentas_corrientes=09
I get the following error :
---------------------------
=09
-999 Not implemented yet.
=09
=09
I don`t understand why!=20
-----------------------
=09
#more sqlhosts
=09
# Servidor Desarrollo e3500desa
e3500desa_shm onipcshm ucayali dummy
e3500desa_tcp ontlitcp ucayali e3500desa_tcp
=09
#------------------------------------------------------------
=09
# Servidor Primario ecofin1 - Salaverry
ecofin1_shm onipcshm ucayali dummy
ecofin1_tcp ontlitcp ucayali ecofin1_tcp
=09
=09
#more hosts.equiv
amazonas
=09
=09
I never before had that problem...
=09
=09
Thank's
=09
Omar.
=09
sending to informix-list
=09
________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! =
<http://us.rd.yahoo.com/evt=3D21608/*http:/webhosting.yahoo.com/ps/sb/>=20
________________________________
<< ella for Spam Control >> has removed 1020 Spam messages and set aside =
177 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com=09
------_=_NextPart_001_01C3E659.0EDB18DC
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=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>You must be running version 9 of =
Informix=A0
- I haven’t worked on that for a while, but remember it was a very
general message for things the engine couldn’t do, such as doing a =
table
info on views (if the view was created on a table residing on a remote
database), which I remember.</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Nothing to worry about, it might =
just
limit you in what you need to do on the DB.</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><s