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

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

Thanks lloydnwo. Yes! we will be using 4GL to insert data. I beleive we can use load statement, if we use isql or dbaccess.

Hi,

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

regards,

lloyd