Re: BLOB/CLOB in ILE/C

You can't read a table containing BLOBs for instance, but you can
however open it using _Ropen and then you could use the feedback API
to get the number of records.

Look up a mail to this list from November 2010, particularly Bruce
Vining's answer:
http://archive.midrange.com/c400-l/201011/msg00013.html

Thanks,
Erik

2011/11/2 Jevgeni Astanovski <Jevgeni.Astanovski@xxxxxxxxxxxx>:

Hi, folks.

Such an unexpected situation.
Had a program that for certain reason needed to know number of records in a physical file.
Definitely there are many ways to do that.
I did it like this:

.....
if ((fp1 = _Ropen(argv[1], "rr")) == NULL)
{
 .... error message ....
 return(0) ;
}
fb1 = _Ropnfbk (fp1);
_Rclose(fp1) ;
......

After that fb1->num_records contains a number of records in the file argv[1].
Worked fine with all needed files but 3. For them open fails. Looked inside - they contain either BLOB or CLOB fields of size ca 1MB.

Googled for a while but failed to find if it is possible to work with tables containing BLOB/CLOB fields from ILE/C without using embedded SQL.

Any idea?

Jevgeni Astanovski

--
This is the C programming iSeries / AS400 (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.