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

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.

Hi .. iqbcp worked gud.. thanks..
now i need to load the file using java into IQ table. IS that a big task ??

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

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