Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    HN
    Posts
    3

    Unanswered: Copy table in Ingres

    Hi,
    i am new to Ingres and OpenROAD, and now i am trying to use "Copy table" utility of Ingres, can anyone help me to solve this:

    I have a text file comma separated: test.txt with content:

    10,'12-mar-2004',2000,60,30
    11,'12-mar-2004',2000,60,10

    and a table named balance
    In a openROAD script , i use:

    copy balance(
    balance_id= integer,
    balance_date= d1,
    balance_value= integer,
    tenancy_id= integer,
    account_number= integer,
    nl=d1)
    from 'C:/test.txt';


    and it's raising error:

    E_CO0024 COPY: Unexpected END OF FILE while processing row 4.


    Many thanks

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    I will assume that you have already created the table balance (?!)

    Try

    copy balance(
    balance_id= c0comma,
    balance_date= c0comma,
    balance_value= c0comma,
    tenancy_id= c0comma,
    account_number= c0,
    nl=d1)
    from 'C:/test.txt';

    you might need to remove the quoted from around your dates - athough that depends on your setup.

    Hope this helps
    Regards
    Dbabren

  3. #3
    Join Date
    Apr 2004
    Location
    HN
    Posts
    3

    Talking

    Thanks dbabren

    Actually i tried copydb utilitty and then i just get the code from *.in file
    and it works

Posting Permissions

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