| ij> -- |
| -- Licensed to the Apache Software Foundation (ASF) under one or more |
| -- contributor license agreements. See the NOTICE file distributed with |
| -- this work for additional information regarding copyright ownership. |
| -- The ASF licenses this file to You under the Apache License, Version 2.0 |
| -- (the "License"); you may not use this file except in compliance with |
| -- the License. You may obtain a copy of the License at |
| -- |
| -- http://www.apache.org/licenses/LICENSE-2.0 |
| -- |
| -- Unless required by applicable law or agreed to in writing, software |
| -- distributed under the License is distributed on an "AS IS" BASIS, |
| -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| -- See the License for the specific language governing permissions and |
| -- limitations under the License. |
| -- |
| drop table localtab; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'LOCALTAB' because it does not exist. |
| ij> create table localtab( ndec decimal(5,3), |
| ndatec date , |
| ntimec time , |
| ncharc varchar(500)); |
| 0 filas insertadas/actualizadas/suprimidas |
| ij> insert into localtab values(12.345, date('2000-05-25'),'15:30:15','¥¤¥Ù¥ó¥È¥¢¥é¡¼¥à¤¬Í¸ú¤Ç¤¹¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(32.432, date('2000-05-18'),'15:32:10','DR:DRAUTO¤Ï0 (Off)¤Ç¤¹¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(54.846, date('2000-01-28'),'15:32:28','INFORMIX-OnLine¤¬½é´ü²½¤µ¤ì¡¢¥Ç¥£¥¹¥¯¤Î½é´ü²½¤¬´°Î»¤·¤Þ¤·¤¿¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(39.003, date('2000-11-11'),'15:32:29','¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 0ÉäǤ·¤¿'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(79.406, date('2000-06-05'),'15:32:29','¤¹¤Ù¤Æ¤ÎDBÎΰè¤Î¥Ç¡¼¥¿¥¹¥¥Ã¥×¤Ï¸½ºß¥ª¥Õ¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(94.999, date('2000-07-30'),'15:32:30','On-Line¥â¡¼¥É'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(18.849, date('2000-10-22'),'15:32:31','sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®Ãæ¤Ç¤¹...'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(35.444, date('2000-02-29'),'15:33:22','ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(84.391, date('2000-01-21'),'15:33:23','¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(56.664, date('2000-04-16'),'15:33:40','ÏÀÍý¥í¥° 2¤¬´°Î»¤·¤Þ¤·¤¿¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(22.393, date('2000-03-01'),'15:33;42','¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 2¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý'); |
| ERROR 22007: The syntax of the string representation of a date/time value is incorrect. |
| ij> insert into localtab values(90.007, date('2000-11-27'),'15:33:43','¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 2ÉäǤ·¤¿'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(30.496, date('2000-04-03'),'15:34:29','ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(66.295, date('2000-10-15'),'15:34:30','¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(54.332, date('2000-09-01'),'15:35:35','sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®¤Ï´°Î»¤·¤Þ¤·¤¿¡£'); |
| 1 fila insertada/actualizada/suprimida |
| ij> insert into localtab values(11.105, date('2000-07-09'),'15:39:10','¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 8ÉäǤ·¤¿'); |
| 1 fila insertada/actualizada/suprimida |
| ij> -- display in non localized format |
| select * from localtab; |
| NDEC |NDATEC |NTIMEC |NCHARC |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 12.345 |2000-05-25|15:30:15|¥¤¥Ù¥ó¥È¥¢¥é¡¼¥à¤¬Í¸ú¤Ç¤¹¡£ |
| 32.432 |2000-05-18|15:32:10|DR:DRAUTO¤Ï0 (Off)¤Ç¤¹¡£ |
| 54.846 |2000-01-28|15:32:28|INFORMIX-OnLine¤¬½é´ü²½¤µ¤ì¡¢¥Ç¥£¥¹¥¯¤Î½é´ü²½¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 39.003 |2000-11-11|15:32:29|¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 0ÉäǤ·¤¿ |
| 79.406 |2000-06-05|15:32:29|¤¹¤Ù¤Æ¤ÎDBÎΰè¤Î¥Ç¡¼¥¿¥¹¥¥Ã¥×¤Ï¸½ºß¥ª¥Õ¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ |
| 94.999 |2000-07-30|15:32:30|On-Line¥â¡¼¥É |
| 18.849 |2000-10-22|15:32:31|sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®Ãæ¤Ç¤¹... |
| 35.444 |2000-02-29|15:33:22|ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 84.391 |2000-01-21|15:33:23|¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý |
| 56.664 |2000-04-16|15:33:40|ÏÀÍý¥í¥° 2¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 90.007 |2000-11-27|15:33:43|¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 2ÉäǤ·¤¿ |
| 30.496 |2000-04-03|15:34:29|ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 66.295 |2000-10-15|15:34:30|¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý |
| 54.332 |2000-09-01|15:35:35|sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®¤Ï´°Î»¤·¤Þ¤·¤¿¡£ |
| 11.105 |2000-07-09|15:39:10|¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 8ÉäǤ·¤¿ |
| ij> -- display in localized format |
| LOCALIZEDDISPLAY ON; |
| ij> select NDEC, NDATEC, NCHARC from localtab; |
| NDEC |NDATEC |NCHARC |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 12,345 |25 de mayo de 2000 |¥¤¥Ù¥ó¥È¥¢¥é¡¼¥à¤¬Í¸ú¤Ç¤¹¡£ |
| 32,432 |18 de mayo de 2000 |DR:DRAUTO¤Ï0 (Off)¤Ç¤¹¡£ |
| 54,846 |28 de enero de 2000 |INFORMIX-OnLine¤¬½é´ü²½¤µ¤ì¡¢¥Ç¥£¥¹¥¯¤Î½é´ü²½¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 39,003 |11 de noviembre de 2000 |¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 0ÉäǤ·¤¿ |
| 79,406 |5 de junio de 2000 |¤¹¤Ù¤Æ¤ÎDBÎΰè¤Î¥Ç¡¼¥¿¥¹¥¥Ã¥×¤Ï¸½ºß¥ª¥Õ¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ |
| 94,999 |30 de julio de 2000 |On-Line¥â¡¼¥É |
| 18,849 |22 de octubre de 2000 |sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®Ãæ¤Ç¤¹... |
| 35,444 |29 de febrero de 2000 |ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 84,391 |21 de enero de 2000 |¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý |
| 56,664 |16 de abril de 2000 |ÏÀÍý¥í¥° 2¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 90,007 |27 de noviembre de 2000 |¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 2ÉäǤ·¤¿ |
| 30,496 |3 de abril de 2000 |ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£ |
| 66,295 |15 de octubre de 2000 |¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý |
| 54,332 |1 de septiembre de 2000 |sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®¤Ï´°Î»¤·¤Þ¤·¤¿¡£ |
| 11,105 |9 de julio de 2000 |¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 8ÉäǤ·¤¿ |
| ij> |