How to load a MS Word document into a Text field

Posted in 1999

TindellT01 — 10 Feb 1999 00:56:29 GMT — source: Informix-list mailing list archive (1991-1998)

I am trying to load a Word document into the Informix text field. From what I have read and understood this is one of the purposes of the text field. I am using the UNIX operating system of Informix. I tried using the load command and I keep getting errors. Has anyone done this? Also when using the load command, is there any way to load a file from your hard drive to Informix without having to FTP it to the Informix Unix server first? Teresa Tindell Florida Department of Health Care Administration

↪ replying to TindellT01

Frank — Tue, 9 Feb 1999 21:02:41 -0500 — source: Informix-list mailing list archive (1991-1998)

If you are using Informix 9.x, then you can use the Filetoblob or Filetoclob function to insert or update your file into the database. Use the former for binary files and the latter for text files. Also, you will want to use blob and clob types rather than byte or text. Frank TindellT01 wrote in message <19990209195629.26979.00000716@ng121.aol.com>... >I am trying to load a Word document into the Informix text field. From what I >have read and understood this is one of the purposes of the text field. I am >using the UNIX operating system of Informix. >I tried using the load command and I keep getting errors. >Has anyone done this? >Also when using the load command, is there any way to load a file from your >hard drive to Informix without having to FTP it to the Informix Unix server >first? >Teresa Tindell >Florida Department of Health Care Administration

↪ replying to Frank

Art S. Kagel — Wed, 10 Feb 1999 12:18:38 -0500 — source: Informix-list mailing list archive (1991-1998)

Frank wrote: [SNIP reply] > TindellT01 wrote in message <19990209195629.26979.00000716@ng121.aol.com>... > >I am trying to load a Word document into the Informix text field. From > what I > >have read and understood this is one of the purposes of the text field. I > am > >using the UNIX operating system of Informix. > >I tried using the load command and I keep getting errors. > >Has anyone done this? > >Also when using the load command, is there any way to load a file from your > >hard drive to Informix without having to FTP it to the Informix Unix server > >first? If you have ESQL/C you can load the file into the BLOB using Dynamic SQL and the LOCFILE or LOCFNAME method (see the ESQL/C manual in the Dynamic SQL section). You can even get ESQL/C for WinNT and create the load program to run on the client machines. BTW In TEXT type columns Informix expects ASCII printable characters so I would recommend using BYTE blobs, they are functionally the same actually. Art S. Kagel