Re: BLOB/CLOB in ILE/C

I would avoid opening a file I don't intend to read/write. Instead, I'd go for output of QDBRTVFD, QUSLMBR, or QUSRMBRD APIs - or RTVMBRD command.
++
Dennis
++
"No one is laughable who laughs at himself."
-- Seneca (1st century)



Sent from my Galaxy tablet phone. Please excuse my brevity.
For any grammatic/spelling errors, there is no excuse.
++


"Jevgeni Astanovski" <Jevgeni.Astanovski@xxxxxxxxxxxx> wrote:

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.