distributed query & blob

IDS 11.50.FC8 , IBM INFORMIX-4GL Version 7.50.FC3X4 Q. getting the following error trying to retrieve a blob data type from an external informix logged database. fglrun testnetimage.42m Program stopped at 'testnetimage.4gl', line number 29. SQL statement error number -9270. Type (informix.blob) is unsupported in distributed queries. Not sure if this is supported or not, if not then would appreciate any insight on how to retrieve a blob from an external database. We tried opening the external database and running the query , same error.

You have to connect directly to the remote server by using one of: - the CONNECT TO SQL Command in your 4GL app - include the @dbservername in the DATABASE command in your 4GL app - set the remote server's name into INFORMIXSERVER in the apps environment If you also have to query the local server, you can use CONNECT TO and SET CONNECTION to maintain separate connections to each server. Art Art S. Kagel, Principal Consultant 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 Tue, Sep 17, 2013 at 5:31 PM, MARK JALKIEWICZ < mark.jalkiewicz@verizon.net> wrote: > IDS 11.50.FC8 , IBM INFORMIX-4GL Version 7.50.FC3X4 > > Q. getting the following error trying to retrieve a blob data type from an > external informix logged database. > > fglrun testnetimage.42m > Program stopped at 'testnetimage.4gl', line number 29. > SQL statement error number -9270. > Type (informix.blob) is unsupported in distributed queries. > > Not sure if this is supported or not, if not then would appreciate any > insight > on how to retrieve a blob from an external database. We tried opening the > external database and running the query , same error. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c373e497321804e69b220d