1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
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:DRAUTO0 (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:DRAUTO0 (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:DRAUTO0 (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>
|
