Textarea AS400 database

Posted on 2005-05-06
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

    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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Now that Expression Web 4.0 ( is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
    Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
    The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: :…
    The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now