import file text type

[ivh]

hi, any idea to load one file type text delimit with ',', i
try with the LOAD method but i don't now if exist another
method mores fast to input the information to my database .

thanks all

[Josh Savill [Sybase iAnywhere]]

What version and build of SQL Anywhere?

LOAD TABLE ... ROW DELIMITED BY ... is probably your best approach for speed.

Are you having difficulties?

--
Joshua Savill
Sybase iAnywhere - Product Manager

[ivh]

thanks, i try with asa 9.0.2.3420, my information
incremental by month , and the result is the load table to
my db is slow, my table are 8 columns and 20,000 regs and
put table is aprox 10 min. this is my problem, any idea to
incremental speed the process.

thaks all.

[Josh Savill [Sybase iAnywhere]]

How are you starting the database? Can you provide the command line?

Is there other uses in the database at the time of the LOAD TABLE? There could be blocking as the
LOAD TABLE requires a write lock for the whole table. When you run LOAD TABLE also run sa_locks() to
see if the connection is blocking.