943,753 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Marked Solved
  • Views: 3555
  • Oracle RSS
Mar 31st, 2009
0

LOAD INTO table Sybase IQ help please

Expand Post »
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Miyuki Suzuki is offline Offline
17 posts
since Aug 2008
Mar 31st, 2009
0

Re: LOAD INTO table Sybase IQ help please

Sure. This is run on the IQ instance.

The location is ASE_SERVER.LOCAL_DATABASE (ASE_SERVER should be in your interfaces/sql.ini file).

Oracle Syntax (Toggle Plain Text)
  1. INSERT INTO iqTable
  2. location 'ASE.DB'
  3. (
  4. SELECT * FROM DB..TABLE
  5. )

I cannot assist on setting up the location nor where to find more details in IQ. I am learning this at the moment.
Last edited by Stylish; Mar 31st, 2009 at 1:11 pm.
Reputation Points: 44
Solved Threads: 19
Junior Poster
Stylish is offline Offline
148 posts
since May 2007
Apr 6th, 2009
0

Re: LOAD INTO table Sybase IQ help please

hey there,
thanks for the response, i figured it out already.
thank you.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Miyuki Suzuki is offline Offline
17 posts
since Aug 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: Have Your Even been to Oracle Course that Goes from 10 am to 6 pm for One Month?
Next Thread in Oracle Forum Timeline: Replacing truncate with partitions rotation





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC