Help on blob spaces

Posted in 2014

SERGIO PERES — Mon, 19 May 2014 22:58:09 — source: IIUG Forums & Mailing Lists

Hi, At my company we use external documents to database and we are using shares with acl control but it is very difficult to manage sometimes. I have read about blob spaces and I would like if someone can help about that, I know to create them but how we can work with it, what are the changes that we have to do on our code to access them, how can we put objects on blob space ... Sorry for my insistance but I have read some information and don't understand how to do it, thanks in advance for any help. SP

↪ replying to SERGIO PERES

Art Kagel — Mon, 19 May 2014 23:35:11 — source: IIUG Forums & Mailing Lists

For dumb blobs like TEXT and BYTE type columns, which live either in tablespace or in blobspaces, look in the ESQL/C Programmers Guide in the section named "Programming with simple large objects" in Chapter 7. You will probably initially want to look at using the LOCFNAME method for loading a blob column from a file in order to load up your existing external document files. If you want to use Smart BLOBs like BLOB and CLOB type columns, look at Chapter 8 in the ESQL/C Guide "Smart large objects". Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Mon, May 19, 2014 at 6:58 PM, SERGIO PERES <sergio.peres@airc.pt> wrote: > Hi, > > At my company we use external documents to database and we are using shares > with acl control but it is very difficult to manage sometimes. I have read > about blob spaces and I would like if someone can help about that, I know > to > create them but how we can work with it, what are the changes that we have > to > do on our code to access them, how can we put objects on blob space ... > Sorry for my insistance but I have read some information and don't > understand > how to do it, thanks in advance for any help. > > SP > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133d50cbb750204f9c93698