troubles to transfer blob data from one to an other Db Server

Posted in 2000

Herbert Liechti — Sat, 15 Jan 2000 22:24:14 GMT — source: Informix-list mailing list archive (1991-1998)

Hi I'm currently involved in a web project where we are using the newest Informix Version with the universal data option. We have two different machines. One machine with a DB Server for preparing the content for the web and one machine with a DB Server for the productive environment. My task is it to write stored procedures which are deploying the data from the development machine to the productive environment. I can reach the productive server without problems with the syntax db@server:table. Everything is working fine. But as soon I try to transfer blob data to the server complains with the message 'not implemented yet' Argghhhhhh..... See the following fragment of code for an example how I attempted to solve the problem: SELECT LOTOFILE(bild, bildname, 'client') INTO dummy FROM buttons WHERE buttons.buttonid = v_buttonid; INSERT INTO online2000@sun_net:buttons (buttonid, zeitstempel, button, bild, mimetype, artid, punktex, punktey) VALUES(v_buttonid, v_zeitstempel, v_button, FILETOBLOB( bildname, 'client'), v_mimetype, v_artid, v_punktex, v_punktey); Anybody know a solution? Thanks Herbie

↪ replying to Herbert Liechti

Madison Pruet — Sat, 15 Jan 2000 17:32:04 -0600 — source: Informix-list mailing list archive (1991-1998)

9.3 supports distributed queries with blobs. For now you would need to use text or byte columns instead of blob/clob columns. Herbert Liechti wrote: > Hi > > I'm currently involved in a web project where we are using the newest > Informix Version with the universal data option. We have two different > machines. One machine with a DB Server for preparing the content for the > web and one machine with a DB Server for the productive environment. > > My task is it to write stored procedures which are deploying the data > from > the development machine to the productive environment. I can reach > the productive server without problems with the syntax > db@server:table. Everything is working fine. But as soon I try > to transfer blob data to the server complains with the message > 'not implemented yet' > > Argghhhhhh..... > > See the following fragment of code for an example how I > attempted to solve the problem: > > SELECT LOTOFILE(bild, bildname, 'client') > INTO dummy > FROM buttons WHERE buttons.buttonid = v_buttonid; > > INSERT INTO online2000@sun_net:buttons > (buttonid, zeitstempel, button, bild, mimetype, artid, > punktex, punktey) > VALUES(v_buttonid, v_zeitstempel, v_button, > FILETOBLOB( bildname, 'client'), > v_mimetype, v_artid, v_punktex, v_punktey);> > Anybody know a solution? > > Thanks Herbie

↪ replying to Madison Pruet

Herbert Liechti — Tue, 18 Jan 2000 11:13:12 GMT — source: Informix-list mailing list archive (1991-1998)

Madison Pruet wrote: > > 9.3 supports distributed queries with blobs. > > For now you would need to use text or byte columns instead of blob/clob > columns. Ok. For now I run in the next trap. We have written a few load programs which are loading binary data such as pictures into the database. I can't find a practicable way in the docu to load byte data in the database similar to the function filtoblob. How do I load Byte Columns in the database? Thanks for your help Herbie > > Herbert Liechti wrote: > > > Hi > > > > I'm currently involved in a web project where we are using the newest > > Informix Version with the universal data option. We have two different > > machines. One machine with a DB Server for preparing the content for the > > web and one machine with a DB Server for the productive environment. > > > > My task is it to write stored procedures which are deploying the data > > from > > the development machine to the productive environment. I can reach > > the productive server without problems with the syntax > > db@server:table. Everything is working fine. But as soon I try > > to transfer blob data to the server complains with the message > > 'not implemented yet'

↪ replying to Herbert Liechti

Madison Pruet — Tue, 18 Jan 2000 05:34:48 -0700 — source: Informix-list mailing list archive (1991-1998)

In $INFORMIXDIR/demo/esqlc there is a demo program, blobload.ec which could be used or modified for this purpose. Herbert Liechti wrote: > Madison Pruet wrote: > > > > 9.3 supports distributed queries with blobs. > > > > For now you would need to use text or byte columns instead of blob/clob > > columns. > > Ok. For now I run in the next trap. We have written a few load programs > which are loading binary data such as pictures into the database. > I can't find a practicable way in the docu to load byte data > in the database similar to the function filtoblob. > > How do I load Byte Columns in the database? > > Thanks for your help > Herbie > > > > > Herbert Liechti wrote: > > > > > Hi > > > > > > I'm currently involved in a web project where we are using the newest > > > Informix Version with the universal data option. We have two different > > > machines. One machine with a DB Server for preparing the content for the > > > web and one machine with a DB Server for the productive environment. > > > > > > My task is it to write stored procedures which are deploying the data > > > from > > > the development machine to the productive environment. I can reach > > > the productive server without problems with the syntax > > > db@server:table. Everything is working fine. But as soon I try > > > to transfer blob data to the server complains with the message > > > 'not implemented yet' -- Madison Pruet =========================================== Enterprise Replication Product Developement Dallas, Texas Informix Software ===========================================