Re: INSERT INTO TEXT column
Posted in 1997
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design
Magnus Ljung wrote: > > I'm having the same problem in Informix Universal Web Connect. > Does anyone know if this can be done directly from an AppPage? If not, > how can I do this by using the UWC API? > > I'm getting a bit desperate with this, so any suggestions are > welcome... > > //Magnus Ljung Try the perl DBI and DBD interface You can read and write straight into TEXT and BYTE columns from perl variables in the same manner as other data types using a syntax very similar to ESQL/C. Note perl variables can contain HUGE (10MB,100MB etc.) amounts of data if you have the space space. It is all FREE from the perl CPAN under http://www.perl.org but you need ESQL/C on one machine to compile the shared library. -- # John Clutterbuck Tel: +44 1703 765021 # Siemens Business Services email: jclutterbuck@sbs.siemens.co.uk # Phi House, Enterprise Road # Chilworth, Hampshire, SO16 7NS