Results 1 to 6 of 6
  1. #1
    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

  2. #2
    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.

  3. #3
    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 ??

  4. #4
    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

  5. #5
    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

  6. #6
    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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •