If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Loading sybase iq

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 6
Loading sybase iq

Hi all, am new to sybase.
I have a .dat file on my ASE server. I need to load that into my sybase IQ server.
i have heard that bcp will not work in IQ,is there any possible solution ??

Please advice
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Mar 2008
Posts: 96
there is an iqbcp utility to do the bcp in and out in Sybase IQ, see if this may help.
Also in sybase IQ there is a command load database from plain text file, I am forgetting the syntax of that.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 6
Hi .. iqbcp worked gud.. thanks..
now i need to load the file using java into IQ table. IS that a big task ??
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Mar 2008
Posts: 96
I don't know about loading file from java, but in IQ its possible to load data from flat files (ie csv) to IQ tables.

please go to below link for more information

SyBooks Online
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 6
Comparing Huge data

Hi ..
In sybase IQ I have a store procedure that loads 10 lakhs records into an empty working table. After loading it takes each record from the working table and compares it with records in main table . The problem is main table has around 1 crore records and 94 columns .

Can u pls tell me any SQL performance improvement tat can be done to this SP ?

As of now my store procedure hangs in the part where it compares each column of 9 lak records with 1 crore in main table .

Ur help is highly appreciated .. thanks in advance
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Mar 2008
Posts: 96
I have some questions first.
1. from where u r loading 10 lakh records in working table (from any other table using select or from a flat file) ?
2. is it possible to create a view by joining two tables(the main table and the working table) and then create another working table with matching rows ?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On