Re: -999 Not implemented yet.
Posted in 2004
LUQUE Valdivia Omar 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, Yup, you cannot select extended data types (things like LVARCHAR, BOOLEAN, etc.) remotely like this. If you explicitly name all the other columns in your select and omit des_documento, then it will work. Please submit a feature request to IBM for this to be "fixed". The more that do, the more chance it will get fixed. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list