>hi all,
>
>i try to create table , some fields as number(numaric)TYPE
>

> CREATE TABLE home(list_no N(10), customer_tel C(15),name C(80), area_no C(10),account C(10), qdate C(30),home C(10), bus C(40),survey_no c(10), flag N(10),n_try N(10)  NOCPTRANS)
>

>THANKS

Use the NOCPTRANS keyword after each character fields where you need, it has no meaning for a numeric field like you have used it.

CREATE TABLE home (list_no N(10), cust_tel C(15) nocp ,name C(80) nocp, area_no C(10) nocp ,account C(10), qdate C(30) nocp,home C(10) nocp, bus C(40) nocp,survey_no c(10) nocp, flag N(10),n_try N(10))

And note that customer_tel is more than 10 character, and NOT a legal fieldname in a free table.
Also if qdate is a date, you should use a date field type!!!