Hi,

I want to create an external table to load data from flat file.

I tried to execute below code in dbaccess terminal but i am getting 201 syntax error message.

Code:
CREATE EXTERNAL TABLE ET_TEST
(
id int, 
name char(10)
)
USING
DATAFILES ('DISK:/home/rtest.unl'),
FORMAT 'DELIMITED',
REJECTFILE '/home/rtest.rej',
MAXERRORS 250,
DELUXE
);
Can any body let me know how to create an external table in IDS 11.50.

I am using IDS 11.50 on SOLARIS machine.

Thanks in advance.........

Regards:
Ritesh Kumar