Textarea AS400 database

Posted on 2005-05-06
Medium Priority
Last Modified: 2013-12-16
In a coldfusion form I have a textarea(can enter as many character as needed)  that needs to be stored in a table on an AS/400 (i-series). What type of field should I create in the AS/40 table to incorparate the textarea ? We are on V5R2. What is the SQL syntax ?

Question by:Errol Farro
1 Comment
LVL 18

Accepted Solution

Dave Ford earned 750 total points
ID: 13961061
Ususally, I just define a large VARCHAR

create table deleteme (
  largeVarchar for column largeVC varchar(1000)

Alternately, you could define a CLOB, but I find those much harder to deal with.

create table deleteme (            
  largeCLOB clob(1M)


Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question