RE: Working with CLOB's

Nevermind...  If you cast the clob field name to varchar or char with a
length, it works.

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.
> 
> 
>