Problem with Varchar and Text Plain Archive

Posted in 2012

Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Data Types & Schema Design

GUSTAVO ECHENIQUE — Thu, 20 Sep 2012 16:26:07 — source: IIUG Forums & Mailing Lists

Hello to All! I have installed an engine Informix 7.31 TD6 on Windows 2000 Server, and need to generate for a Stored Procedure a flat file. The problem is that the same one has a length of 369 characters and the Varchar has the limitation of 255 characters, and this Informix's version does not support the LVarchar. I be be very grateful if someone can bring a solution over. I am grateful his time and attention. Regards! Gustavo Echenique

↪ replying to GUSTAVO ECHENIQUE

Art Kagel — Thu, 20 Sep 2012 16:40:38 — source: IIUG Forums & Mailing Lists

Solution: Download the Free to use Informix Innovator-C Edition v11.70 from the IBM web sight and put your data into that instead. Not only does it support LVARCHAR, but it also supports external tables which is a better way to move data from the database to flat files. Go to www.informix.com and look for the Trials and Demos link and follow it to the Innovator-C download. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 20, 2012 at 12:26 PM, GUSTAVO ECHENIQUE < gustavo.echenique@cemdo.com.ar> wrote: > Hello to All! I have installed an engine Informix 7.31 TD6 on Windows 2000 > Server, and need to generate for a Stored Procedure a flat file. The > problem > is that the same one has a length of 369 characters and the Varchar has the > limitation of 255 characters, and this Informix's version does not support > the > LVarchar. I be be very grateful if someone can bring a solution over. I am > grateful his time and attention. Regards! Gustavo Echenique > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f502ff84570db04ca24c87f