RE: Working with CLOB's

["Kristen Henry" <klhnry@xxxxxxxxxxxx>]

I don't know about that..

Kristen


> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of cornelius, chad
> Sent: Wednesday, August 31, 2005 2:37 PM
> To: 'Java Programming on and around the iSeries / AS400'
> Subject: RE: Working with CLOB's
> 
> 
> Thanks Kristen...  Is there a way to view the data using a 
> database tool such as DBVisualizer or MyEclipse database perspective?
> 
> Chad Cornelius, IIS
> (720) 921-7835
> 
> -----Original Message-----
> From: Kristen Henry [mailto:klhnry@xxxxxxxxxxxx] 
> Sent: Wednesday, August 31, 2005 2:29 PM
> To: 'Java Programming on and around the iSeries / AS400'
> Subject: RE: Working with CLOB's
> 
> Using SQL do a regular select.  Then I do something like this:
> 
>                           if (rs.getClob("additionalcomments") !=
> null) {
>                               
>                                   Clob c =
> rs.getClob("additionalcomments");
>       
> setAdditionalcomments(c.getSubString(1, (int) c.length()));
>                               } else {
>                                       
>                                       setAdditionalcomments("");
>                           }
> 
> I don't remember why I had to do the substring thing...
> 
> Kristen
> 
> 
> 
> > -----Original Message-----
> > From: java400-l-bounces@xxxxxxxxxxxx
> > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of cornelius, chad
> > Sent: Wednesday, August 31, 2005 2:12 PM
> > To: 'java400-l@xxxxxxxxxxxx'
> > Subject: Working with CLOB's
> > 
> > 
> > This is the first time I have attempted or needed to work
> > with Clob's, and am wondering how you retrieve the data 
> > defined as a CLOB using SQL.  Is this even possible?  Any 
> > suggestions would be greatly appreciated.
> > 
> >  
> > 
> > Thanks,
> > 
> > Chad Cornelius, IIS
> > 
> > (720) 921-7835
> > 
> >  
> > 
> > --
> > This is the Java Programming on and around the iSeries / 
> > AS400 (JAVA400-L) mailing list To post a message email: 
> > JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> > list options,
> > visit: http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> > 
> > 
> > 
> 
> 
> -- 
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> -- 
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> 
> 
>