RE: Memo field on the AS/400

Both the Native JDBC driver and the Toolbox JDBC driver do support the use
of lobs.  Note that lobs are new to the 400 via a v4r4 PTF.  JDBC 2.0 is
required to use LOBs directly.  JDBC 2.0 is a part of JDK 1.2.  JDK 1.2 was
also added to v4r4 by PTF.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




"Glenn Howald" <ghowald@GSCWEB.COM>@midrange.com on 09/29/2000 11:33:34 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   <JAVA400-L@midrange.com>
cc:
Subject:  RE: Memo field on the AS/400



Look at VARCHAR, CLOB and BLOB data types in the InfoCenter.

The link below (in the InfoCenter) gives the SQL command syntax for
creating
a table (file).
http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/db2/rbafzmsth

ctabl.htm

I haven't used them, but it appears that there is support for them using
the
JDBC drivers as well.

Glenn Howald
Programmer/Analyst
Gateway Software Corporation

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---