Re: BLOB/CLOB in ILE/C

[Jevgeni Astanovski <Jevgeni.Astanovski@xxxxxxxxxxxx>]

Of course Dennis.
Agree with you. There are lots of other methods to get number of records held on file.
And I have solved this particular problem in another way.

However my feeling is that my way was the easiest one from programming point of view :-)
Using APIs requires more code.

But my question was different.
Is it possible to work with tables containing BLOB/CLOB fields from ILE/C without using embedded SQL?

Jevgeni.


-----Original Message-----
From: c400-l-bounces+jevgeni.astanovski=sampopank.ee@xxxxxxxxxxxx [mailto:c400-l-bounces+jevgeni.astanovski=sampopank.ee@xxxxxxxxxxxx] On Behalf Of Dennis
Sent: 2. november 2011. a. 17:01
To: C programming iSeries / AS400
Subject: Re: [C400-L] 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.