Hi ALL
    I encountered a problem using a COPY INFO.  Strange thing is my IP is 59execute the following statement is not a problem on the machine.So freak!

IP:192.168.110.59 (Database Server)
[hotel-revenue-online@bjs-hotel-RevenueCompute-02 data_visual_monetdb]$ mclient -u monetdb -d hotel-revenue -s "COPY 2 RECORDS INTO  hotel_revenue_octopus_booking_order  FROM  '/home/hotel-revenue-online/ping.gao/data_visual_monetdb/hotel_revenue_octopus_booking_order.sql'  USING  DELIMITERS ',','\\n'"
password:
2 affected rows

IP:192.168.110.179
Error 1:
[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO  hotel_revenue_octopus_hotel_info  FROM /home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data USING  DELIMITERS '\\001','\\n'¡±

syntax error, unexpected '/', expecting STRING or '(' or STDIN in: "copy 2 records into  hotel_revenue_octopus_hotel_info  from /¡°

Error 2:

[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO  hotel_revenue_octopus_hotel_info  FROM  '/home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data'  USING  DELIMITERS '\\001','\\n'"

could not open file '/home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data': No such file or directory


Error 3:
[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO  hotel_revenue_octopus_hotel_info  FROM STDIN DELIMITERS '\\001','\\n'" - < /home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data
2 affected rows
syntax error, unexpected sqlINT in: "90564318"