Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Unanswered: TEXT data type in INFORMIX

    Hi Guys,

    I have not worked with data type TEXT before. Now I need to create a TEXT column in one of the table to store some report outputs. How do you create a TEXT column in a table? Please let me know the synatx.

    for an example

    create table test_tbl
    ( emp_code char(15)
    emp_history text
    )

    Is this correct ?

    Thanks!

    LR

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,
    The syntax is correct, though u forgot a comma at the end of the first line.

    create table test_tbl
    ( emp_code char(15),
    emp_history text
    )

    What application are u using to insert the data. If ur using 4GL u will have to loacate the datatype in to memory.
    eg.
    locate emp_rec.emp_history into memory

  3. #3
    Join Date
    Jun 2004
    Posts
    19
    Thanks lloydnwo. Yes! we will be using 4GL to insert data. I beleive we can use load statement, if we use isql or dbaccess.

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,

    Your welcome, yes you can use load statements through isql/dbaccess.

    regards,

    lloyd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •