localizeddisplay.out

derby database source code.good for you.

ij versi EnC:>65533<  EnC:>171<  EnC:>209< n 10.1
ij> drop table localtab;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'LOCALTAB' because it does not exist.
ij> create table localtab( EnC:>9< ndec decimal(5,3), 
 EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< ndatec date , 
 EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< ntimec time , 
 EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< ncharc varchar(500));
0 filas insertadas/actualizadas/suprimidas
ij> insert into localtab values(12.345, date('2000-05-25'),'15:30:15','\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(32.432, date('2000-05-18'),'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(54.846, date('2000-01-28'),'15:32:28','INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(39.003, date('2000-11-11'),'15:32:29','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(79.406, date('2000-06-05'),'15:32:29','\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(94.999, date('2000-07-30'),'15:32:30','On-Line\u30e2\u30fc\u30c9');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(18.849, date('2000-10-22'),'15:32:31','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(35.444, date('2000-02-29'),'15:33:22','\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(84.391, date('2000-01-21'),'15:33:23','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(56.664, date('2000-04-16'),'15:33:40','\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(22.393, date('2000-03-01'),'15:33;42','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
ij> insert into localtab values(90.007, date('2000-11-27'),'15:33:43','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(30.496, date('2000-04-03'),'15:34:29','\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(66.295, date('2000-10-15'),'15:34:30','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(54.332, date('2000-09-01'),'15:35:35','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
1 fila insertada/actualizada/suprimida
ij> insert into localtab values(11.105, date('2000-07-09'),'15:39:10','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79d2\u3067\u3057\u305f');
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|\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                            
32.432  |2000-05-18|15:32:10|DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                        
54.846  |2000-01-28|15:32:28|INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u30&
39.003  |2000-11-11|15:32:29|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79&
79.406  |2000-06-05|15:32:29|\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306&
94.999  |2000-07-30|15:32:30|On-Line\u30e2\u30fc\u30c9                                                                                                       
18.849  |2000-10-22|15:32:31|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                            
35.444  |2000-02-29|15:33:22|\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
84.391  |2000-01-21|15:33:23|\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
56.664  |2000-04-16|15:33:40|\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
90.007  |2000-11-27|15:33:43|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79&
30.496  |2000-04-03|15:34:29|\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
66.295  |2000-10-15|15:34:30|\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
54.332  |2000-09-01|15:35:35|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                 
11.105  |2000-07-09|15:39:10|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79&
ij> -- display in localized format
LOCALIZEDDISPLAY ON;
ij> select * from localtab;
NDEC    |NDATEC                  |NTIMEC            |NCHARC                                                                                                                          
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
12,345  |25 de mayo de 2000      |15:30:15 PST      |\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                            
32,432  |18 de mayo de 2000      |15:32:10 PST      |DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                        
54,846  |28 de enero de 2000     |15:32:28 PST      |INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u30&
39,003  |11 de noviembre de 2000 |15:32:29 PST      |\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79&
79,406  |5 de junio de 2000      |15:32:29 PST      |\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306&
94,999  |30 de julio de 2000     |15:32:30 PST      |On-Line\u30e2\u30fc\u30c9                                                                                                       
18,849  |22 de octubre de 2000   |15:32:31 PST      |sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                            
35,444  |29 de febrero de 2000   |15:33:22 PST      |\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
84,391  |21 de enero de 2000     |15:33:23 PST      |\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
56,664  |16 de abril de 2000     |15:33:40 PST      |\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
90,007  |27 de noviembre de 2000 |15:33:43 PST      |\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79&
30,496  |3 de abril de 2000      |15:34:29 PST      |\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
66,295  |15 de octubre de 2000   |15:34:30 PST      |\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
54,332  |1 de septiembre de 2000 |15:35:35 PST      |sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                 
11,105  |9 de julio de 2000      |15:39:10 PST      |\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79&
ij>