[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: NO SUBJECT

We use informix:

begin-select
your_char_field
    do insert_blob
from
your_table
end-select

begin-procedure insert_blob
begin-sql
insert into blob_table
(blob_field) values (&your_char_field)
end-sql
end-procedure

-----Original Message-----
From: Manimaran Muniandy <mmunian@SEARS.CA>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Wednesday, August 12, 1998 9:09 AM
Subject: NO SUBJECT


>HAVE A NICE DAY
>*** Forwarding note from MMUNIAN --TORINFO  08/12/98 11:38 ***
>To: INTERNET--IBMMAIL
>cc: MARCHI1 --TORINFO  MIKE ARCHIBALD
>
>FROM   : MANIMARAN MUNIANDY  TEL:(416)510-6487  HQ: 941-3219
>         INTERNET: MMUNIAN@SEARS.CA   DEPT: D/704-FIN,
>         FINANCE PROJ, 100 VB3, NORTH YORK, ON. M3B 2S9.
>SUBJECT:
>
>/INTERNET
>/TO  <SQR-USERS@list.iex.net>
>/END
>
>
>Could someone explain to me, how to take a character field from one table
>and load into a long field (type = Blob) in another table on the same
>database (INFORMIX) using SQR.
>
>Thank You.
>..
>
>HAVE A NICE DAY