Re: BLOB/CLOB in ILE/C

[Dennis <iseries@xxxxxxxxxxxx>]

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.