Good Morning all,
I need some help with loading a file into a sybase IQ table with the "LOAD INTO" statement.
I have never used it before and I cant seem to get myhead around how I am supposed to implement it in my java app.
I have a stateless ejb that does file pick up and copy.
After that I used a bufferedreader to extract the stuffs from the file, put it in an array and then used the collection to persist it.
Thing is, it still takes too much time.
I was told to use the Sybase IQ LOAD INTO table statement, but as yet, I havent come across an example of how to use it.
Can anyone either point me in the right direction to a java implemetation of this or please provide an example.
thank you,
Miyuki