RE: VARCHAR Field Size Max

Try CLOB (Character Large Object)

I believe that can hold up to some ungodly sum like 15 million bytes.

CREATE TABLE LAW8EXTN.CHECKOUT(
TRANS_NBR CHAR(10) NOT NULL WITH DEFAULT,
CHECK_DATE DATE NOT NULL WITH DEFAULT,
VENDOR CHAR(9) NOT NULL WITH DEFAULT,
VENDOR_VNAME CHAR(50) NOT NULL WITH DEFAULT,
BASE_CHK_AMT NUMERIC(15,2) NOT NULL WITH DEFAULT,
INVOICES CLOB(4096) NOT NULL WITH DEFAULT);

I had to use it today.

-----------------------------------
Jim Norbut
Systems Administrator
Grubb & Ellis Company
500 West Monroe
Chicago, IL 60661
(312) 698-5620

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Tuesday, January 08, 2008 5:19 PM
To: midrange-l@xxxxxxxxxxxx
Subject: VARCHAR Field Size Max

Quick question for the DB gurus in the forum.

Vern doesn't count on this one since he didn't have a direct answer :-)

Is there a data type besides VARCHAR in DB2/400 -or- DB2 for i5/OS (For
Trevor :-) ) that will let me store more than 32000 characters.

I need a long note field that is larger than 32KB.

Any help would be appreciated.

Thanks :-)

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com <http://www.rjssoftware.com/>
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT