Textarea AS400 database

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 ?

Errol FarroAsked:
Who is Participating?
 
Dave FordSoftware Developer / Database AdministratorCommented:
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)
);

HTH,
DaveSlash
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.