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

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

Thanks dbabren

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