Back to files

---

chcsv version 2.0, Copyright (C) 1995 Batayan.

chcsv is distributed under the GNU General Public License. chcsv comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions, GPL.

---

chcsv £Ó£Ñ£Ìʸ¤ò¼Â¹Ô¤·¡¢£Ó£Ñ£Ìʸ¤¬£Ó£Å£Ì£Å£Ã£Ôʸ¤Î¾ì¹ç¤Ï¡¢ ¡¡¡¡¡¡ £Ã£Ó£Ö·Á¼°¤Ç¥Õ¥¡¥¤¥ë¤«É¸½à½ÐÎϤؽÐÎϤ¹¤ë¡£

Usage: chcsv userid/password

                [-o Output Filename]
                [-a Appended Output Filename]
                [-i Input Filename]
                [-e Enclosure]
                [-t Terminater]
                [-l Long Type Size]
                [-f Array size of fetch]
                [-b Buffer size of output]
                [-v] [-n] [-h]
                [const] [const] ....

¥ª¥×¥·¥ç¥óÀâÌÀ

     userid/password : ¤«¤Ê¤é¤ºÂè°ì°ú¤­¿ô¤Ë»ØÄꤹ¤ë¡£
                       ¥ê¥â¡¼¥È¥í¥°¥¤¥ó¤Î¾ì¹ç¤Ï userid/password@remote-host

     -o : ½ÐÎÏ¥Õ¥¡¥¤¥ë¤ò»ØÄꤹ¤ë¡£»ØÄ꤬¤Ê¤±¤ì¤Ðɸ½à½ÐÎϤ˽ÐÎϤ¹¤ë
 
     -a : ½ÐÎÏ¥Õ¥¡¥¤¥ë¤ËÄɲÃ(Append)¤¹¤ë¾ì¹ç¤Ë»ØÄꤹ¤ë

     -i : £Ó£Ñ£Ìʸ¤òµ­½Ò¤·¤¿¥Õ¥¡¥¤¥ë¤ò»ØÄꤹ¤ë¡£
          »ØÄ꤬¤Ê¤±¤ì¤Ðɸ½àÆþÎϤ«¤éÆþÎϤ¹¤ë¡£
          
     -e : ¥Ç¡¼¥¿¤ò°Ï¤àʸ»ú¤ò»ØÄꤹ¤ë¡£»ØÄ꤬¤Ê¤±¤ì¤Ð¤Ê¤Ë¤â¤Ä¤±¤Ê¤¤¡£
          ¤¿¤À¤·NUMBER·¿¹àÌܤˤϤĤ±¤Ê¤¤¡£
     
     -t : ¥Ç¡¼¥¿¤Î¶èÀÚ¤êʸ»ú¤ò»ØÄꤹ¤ë¡£»ØÄ꤬¤Ê¤±¤ì¤Ð , (¥«¥ó¥Þ)
          ¤ò»ÈÍѤ¹¤ë¡£
          
     -l : LONG·¿¥Ç¡¼¥¿¤Î¥Ç¡¼¥¿Ä¹¤ò¥Ð¥¤¥Èñ°Ì¤Ç»ØÄꤹ¤ë¡£
          »ØÄ꤬¤Ê¤±¤ì¤Ð1024¥Ð¥¤¥È¤È¤Ê¤ë¡£

     -f : FETCH ÇÛÎó¥µ¥¤¥º¤ò»ØÄꤹ¤ë¡£»ØÄ꤬¤Ê¤±¤ì¤Ð1000¹Ô¡£

     -b : ½ÐÎϥХåե¡¥µ¥¤¥º¡Êñ°Ì¡§¹Ô)¤ò»ØÄꤹ¤ë¡£»ØÄ꤬¤Ê¤±¤ì¤Ð1000¹Ô¡£

     -h : ¥Ø¥Ã¥À¡¼¤òÀèƬ¹Ô¤ËÉղ乤롣

     -v : ¥Ç¡¼¥¿¤ò½ÄʤӤ˽ÐÎϤ¹¤ë

     -n : £±·ï¤â¥Ç¡¼¥¿¤¬¤Ê¤¤¾ì¹ç¡¢£°°Ê³°¤Î¥¹¥Æ¡¼¥¿¥¹¤Ç½ªÎ»¤¹¤ë¡£

     [const]: ·ë¹çÊÑ¿ô¤ò£Ó£Ñ£ÌʸÃæ¤Ë»ÈÍѤ·¤¿¾ì¹ç¡¢¤½¤ÎÆâÍƤò»ØÄꤹ¤ë¡£
          »ØÄ꤬¤Ê¤±¤ì¤Ð²ñÏ÷Á¼°¤Çɸ½àÆþÎϤè¤ê»ØÄꤹ¤ë¡£

µ¡Ç½ÀâÌÀ
¡¡chcsv ¤ÏÆþÎÏ¥Õ¥¡¥¤¥ë¤Î£Ó£Ñ£Ìʸ¤ò¼Â¹Ô¤¹¤ë¡££Ó£Ñ£Ìʸ¤¬£Ó£Å£Ì£Å£Ã£Ôʸ ¤Î¾ì¹ç¤Ï¡¢£Ã£Ó£Ö·Á¼°¤Ç¥Õ¥¡¥¤¥ë¤«É¸½à½ÐÎϤؽÐÎϤ¹¤ë¡£

¡¡£Ó£Ñ£ÌʸÃæ¤Ë¤Ï¥³¥á¥ó¥È¤¬µ­½Ò¤Ç¤­¤ë¡£¥³¥á¥ó¥È¤Ï /* ¤«¤é */¤Þ¤Ç¤Î¤Ç¶èÀڤ롣

£Ó£Ñ£ÌʸÃæ¤Î£×£È£Å£Ò£Å¶ç¤ÎÃæ¤Ë¡¢·ë¹çÊÑ¿ô¤ò»ØÄꤹ¤ë¤³¤È¤¬¤Ç¤­¤ë¡£·ë¹çÊÑ¿ô ¤Ï'&'¤Ç»Ï¤Þ¤ë£²£°»ú°ÊÆâ¤Îʸ»úÎó¤ò»ØÄꤹ¤ë¡£·ë¹çÊÑ¿ô¤ò»ÈÍѤ·¤¿¾ì¹ç¤Ï¡¢¼Â¹Ô »þ¤Î¥³¥Þ¥ó¥É°ú¤­¿ô¤Ë¤½¤ÎÆâÍƤò»ØÄꤹ¤ë¡£»ØÄ꤬¤Ê¤¤¾ì¹ç¤Ï²ñÏ÷Á¼°¤ÇÆþÎϤ¹¤ë ¤¬¡¢¤½¤Î¾ì¹ç¤Ï -i ¥ª¥×¥·¥ç¥ó¤ò»ÈÍѤ·¤Æ£Ó£Ñ£Ìʸ¤òµ­½Ò¤·¤¿¥Õ¥¡¥¤¥ë¤ò»ØÄꤷ¤Ê ¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¡£¡Ê-i ¥ª¥×¥·¥ç¥ó¤ò»ÈÍѤ·¤Ê¤¤¤Èɸ½àÆþÎϤè¤ê£Ó£Ñ£Ìʸ¤òÆþÎϤ¹ ¤ë¤¿¤á¡Ë
Î㤨¤Ð£Ó£Ñ£ÌʸÃæ¤Ë·ë¹çÊÑ¿ô¤ò£³¤Ä°Ê¾å»ØÄꤷ¤Æ¡¢¥³¥Þ¥ó¥É°ú¤­¿ô¤Ë£²¤Ä¤·¤«ÆâÍÆ ¤ò»ØÄꤷ¤Ê¤«¤Ã¤¿¾ì¹ç¤Ï¡¢£³¤Ä°Ê¹ß¤ò²ñÏ÷Á¼°¤ÇÆþÎϤ¹¤ë¡£

»ÈÍÑÎã

£±¡¥Ä̾ï¤Î£Ã£Ó£Ö¥Õ¥¡¥¤¥ë·Á¼°¤Çɸ½à½ÐÎϤ˽ÐÎϤ¹¤ë¡£

$ echo "select user,sysdate from dual" | chcsv scott/tiger SCOTT,01-JAN-95

£²¡¥¥Ç¡¼¥¿¤ò " ¤Ç°Ï¤ó¤Ç file1 ¤Ë½ÐÎϤ¹¤ë¡£

$ echo "select user,sysdate from dual" | chcsv scott/tiger -e\" -o file1 $ cat file1
"SCOTT","01-JAN-95"

£³¡¥test.sql¤Î£Ó£Ñ£Ìʸ¤ò¼Â¹Ô¤·¡¢test.out¤Ë½ÐÎϤ¹¤ë¡£¤Þ¤¿·ë¹çÊÑ¿ô¤ò»ÈÍѤ¹¤ë¡£

$ cat test.sql
select * from emp
where empno = &empno

$ chcsv scott/tiger -e\" 7900
7900,"JAMES","CLERK",7698,"81-12-03",950,,30

¥Ð¡¼¥¸¥ç¥ó¾ðÊó

2.0 1999-3-29

     ÇÛÎóFETCH µ¡Ç½Äɲá£
     -h , -a ¥ª¥×¥·¥ç¥óÄɲá£

1.5 1997-05-31

Date type ¤¬£¹·å¤ÇÀÚ¤ì¤Æ¤·¤Þ¤¦¥Ð¥°¤ò½¤Àµ

1.2 1996-07-31

¥ª¥×¥·¥ç¥ó²òÀϤΥХ°½¤Àµ

1.1 1995-03-31

SELECT ʸ°Ê³°¤Î£Ó£Ñ£Ìʸ¤â½èÍý½ÐÍè¤ë¤è¤¦¤Ë¤·¤¿¡£

1.00 1995-01-31

½é´üÈÇ

---

If you have any PROBLEMS with chcsv, or find BUGS, please mailto

kawabata@personal.email.ne.jp (Batayan)

Thank you !!!

---

~