Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!uwm.edu!uwvax!ai.cs.wisc.edu!beverly
From: beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung))
Newsgroups: comp.databases
Subject: Need help with INGRES SQL copy to/from file
Message-ID: <11104@spool.cs.wisc.edu>
Date: 28 Aug 90 16:56:25 GMT
Sender: news@spool.cs.wisc.edu
Organization: U of Wisconsin CS Dept
Lines: 41


  Iam trying to transfer the contents of one table to another
  using "copy from" and "copy into".

  The SQL statement:

	copy table atomlook3 (atomnumb=c0,comma=d1,
						  aaname=c0,comma=d1,
						  atomname=c0, comma=d1,
						  nucleus = c0)
   into 'DSK$USER12:[NMRDB]pd.out'


results in a nicely formatted file with one line for
each record in the table atomlook3. If I then try to 
transfer the file's contents  
into a new table:

	 copy table pd_atom_look(atomnumb=c0comma,
							 aaname=c0comma,
							 atomname=c0comma,
							 nucleus=c0)
     from 'DSK$USER12:[NMRDB].pd.out'

I get :
INGRES ERROR: 18826 COPY:Error encountered while processing row 2
INGRES ERROR: 17111 string cannot be converted to numeric due to
			  incorrect syntax.
			  
     copy table pd_atom_look(atomnumb=c0comma,
							   aaname=c0comma,
                             atomname=c0comma,
							 nucleus=c0nl)
     from 'DSK$USER12:[NMRDB]pd.out'

results  in:
INGRES ERROR: 18815 COPY: an unterminated "varchar" field occurred while fillin
INGRES ERROR: 18826 COPY: Error encountered while processing row 0


Just what syntax exactly does Ingres/SQL want here?