COPY INTO requires absolute path(s) of the file(s): from http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto : "The file read from should be accessible by the server and must use an absolute path name." from "The 'file' should be an SQL string that contains the absolute path name of the file to be inserted. The file is read directly by the server, and so has to be accessible to the server." from http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad : "The file names must be absolute paths to the columns files. They should reside on the same file system as the database farm" Stefan ----- Original Message -----
hi all,
when i use the command in sql:
sql>copy binary into testtable from('file1'); failed to open file file1
the file1 contents : [svomhpc@localhost /home/data1]$>cat file1 0123[svomhpc@localhost /home/data1]$>hexdump file1 0000000 0000 3000 0000 3100 0000 3200 0000 3300 0000010
can anyone tell me what's wrong with file1 or how to use copy binary with?
Meng _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |