How to see a part of information in clob in SP
Someone migrating from Oracle asked how to read just a portion of a CLOB (>32K) inside an Informix stored procedure, the equivalent of Oracle's SUBSTR on a CLOB, having seen references to mi_read. A respondent pointed to the ifx_lo_read / smart large object API docs, but the poster objected that these are ODBC/client-side APIs, not usable from SPL. No working in-stored-procedure solution is recorded; the original poster said he would try writing a Java UDR and post the code later, after a side comment about netiquette.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I am doing the application migration. The previous application use a Oracle Clob data type which large than 32K, Oracle has a familiar function that like substr ,this function could see a portion of clob content,the partner use this function in Oracle store procedure,How to implement it in Informix store procedure? I check some informix document,it said mi_read has such kind of function. Do anyone show a sample or more detail information for me? thanks for your help.
CHUAN LU wrote: > Hi, > > I am doing the application migration. > The previous application use a Oracle Clob data type which large than 32K, > Oracle has a familiar function that like substr ,this function could see a > portion of clob content,the partner use this function in Oracle store > procedure,How to implement it in Informix store procedure? I check some > informix document,it said mi_read has such kind of function. Do anyone show a > sample or more detail information for me? Do you mean ifx_lo_read? http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.odbc.doc/sii -07-30238.htm -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
CHUAN LU wrote: > Hi, > > I am doing the application migration. > The previous application use a Oracle Clob data type which large than 32K, > Oracle has a familiar function that like substr ,this function could see a > portion of clob content,the partner use this function in Oracle store > procedure,How to implement it in Informix store procedure? I check some > informix document,it said mi_read has such kind of function. Do anyone show a > sample or more detail information for me? Or perhaps: http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.o dbc.doc/sii-07-11604.htm -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
ifx_lo_read is a ODBC API，I want to kown how to use it in store procedure.
HI, Friends It may make our life better if we follow some message manner, (1) Always give back big THANKS to any one who offered help. (2) Always report/share/explain the testing Result.... for the answer you got from anyone here. (3) Always include the original question and answers in your message. Your good daily life would be enhanced further ! Informix guy should do things Better (and Faster) ! Thanks, Frank On Wed, Sep 15, 2010 at 10:40 AM, CHUAN LU <luchuan114@sina.com> wrote: > ifx_lo_read is a ODBC API，I want to kown how to use it in store > procedure. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f272082622d00490b6470d
I'll try to write a Java UDR on OCT, if it work fine, I will paste the code into here