zOs/SQL/CHARSET
select
'x 00 - 0F =
' ,
'x 10 - 1F =
' ,
'x 20 - 2F = ' ,
'x 30 - 3F = ' ,
'x 40 - 4F = [.<(+|' ,
'x 50 - 5F = &]$*);^' ,
'x 60 - 6F = -/!,%_>?' ,
'x 70 - 7F = `:#@''="' ,
'x 80 - 8F = abcdefghi' ,
'x 90 - 9F = jklmnopqrƤ' ,
'x A0 - AF = ~stuvwxyz[ޮ' ,
'x B0 - BF = !]' ,
'x C0 - CF = {ABCDEFGHI' ,
'x D0 - DF = }JKLMNOPQR' ,
'x E0 - EF = \STUVWXYZ' ,
'x F0 - FF = 0123456789 '
from sysibm.sysDummy1
;
x
set current locale lc_ctype = 'It_CH' ;
select current locale lc_ctype from sysibm.sysdummy1;
select chr, upper(chr), int, hex(chr), hex(upper(chr))
from A540769.twk005a
order by chr asc
;
x
delete from A540769.TWK005A;
insert into A540769.TWK005A values(x'00', 0);
insert into A540769.TWK005A values(x'01', 1);
insert into A540769.TWK005A values(x'02', 2);
insert into A540769.TWK005A values(x'03', 3);
insert into A540769.TWK005A values(x'04', 4);
insert into A540769.TWK005A values(x'05', 5);
insert into A540769.TWK005A values(x'06', 6);
insert into A540769.TWK005A values(x'07', 7);
insert into A540769.TWK005A values(x'08', 8);
insert into A540769.TWK005A values(x'09', 9);
insert into A540769.TWK005A values(x'0A', 10);
insert into A540769.TWK005A values(x'0B', 11);
insert into A540769.TWK005A values(x'0C', 12);
insert into A540769.TWK005A values(x'0D', 13);
insert into A540769.TWK005A values(x'0E', 14);
insert into A540769.TWK005A values(x'0F', 15);
insert into A540769.TWK005A values(x'10', 016);
insert into A540769.TWK005A values(x'11', 017);
insert into A540769.TWK005A values(x'12', 018);
insert into A540769.TWK005A values(x'13', 019);
insert into A540769.TWK005A values(x'14', 020);
insert into A540769.TWK005A values(x'15', 021);
insert into A540769.TWK005A values(x'16', 022);
insert into A540769.TWK005A values(x'17', 023);
insert into A540769.TWK005A values(x'18', 024);
insert into A540769.TWK005A values(x'19', 025);
insert into A540769.TWK005A values(x'1A', 026);
insert into A540769.TWK005A values(x'1B', 027);
insert into A540769.TWK005A values(x'1C', 028);
insert into A540769.TWK005A values(x'1D', 029);
insert into A540769.TWK005A values(x'1E', 030);
insert into A540769.TWK005A values(x'1F', 031);
insert into A540769.TWK005A values(x'20', 032);
insert into A540769.TWK005A values(x'21', 033);
insert into A540769.TWK005A values(x'22', 034);
insert into A540769.TWK005A values(x'23', 035);
insert into A540769.TWK005A values(x'24', 036);
insert into A540769.TWK005A values(x'25', 037);
insert into A540769.TWK005A values(x'26', 038);
insert into A540769.TWK005A values(x'27', 039);
insert into A540769.TWK005A values(x'28', 040);
insert into A540769.TWK005A values(x'29', 041);
insert into A540769.TWK005A values(x'2A', 042);
insert into A540769.TWK005A values(x'2B', 043);
insert into A540769.TWK005A values(x'2C', 044);
insert into A540769.TWK005A values(x'2D', 045);
insert into A540769.TWK005A values(x'2E', 046);
insert into A540769.TWK005A values(x'2F', 047);
insert into A540769.TWK005A values(x'30', 048);
insert into A540769.TWK005A values(x'31', 049);
insert into A540769.TWK005A values(x'32', 050);
insert into A540769.TWK005A values(x'33', 051);
insert into A540769.TWK005A values(x'34', 052);
insert into A540769.TWK005A values(x'35', 053);
insert into A540769.TWK005A values(x'36', 054);
insert into A540769.TWK005A values(x'37', 055);
insert into A540769.TWK005A values(x'38', 056);
insert into A540769.TWK005A values(x'39', 057);
insert into A540769.TWK005A values(x'3A', 058);
insert into A540769.TWK005A values(x'3B', 059);
insert into A540769.TWK005A values(x'3C', 060);
insert into A540769.TWK005A values(x'3D', 061);
insert into A540769.TWK005A values(x'3E', 062);
insert into A540769.TWK005A values(x'3F', 063);
insert into A540769.TWK005A values(x'40', 064);
insert into A540769.TWK005A values(x'41', 065);
insert into A540769.TWK005A values(x'42', 066);
insert into A540769.TWK005A values(x'43', 067);
insert into A540769.TWK005A values(x'44', 068);
insert into A540769.TWK005A values(x'45', 069);
insert into A540769.TWK005A values(x'46', 070);
insert into A540769.TWK005A values(x'47', 071);
insert into A540769.TWK005A values(x'48', 072);
insert into A540769.TWK005A values(x'49', 073);
insert into A540769.TWK005A values(x'4A', 074);
insert into A540769.TWK005A values(x'4B', 075);
insert into A540769.TWK005A values(x'4C', 076);
insert into A540769.TWK005A values(x'4D', 077);
insert into A540769.TWK005A values(x'4E', 078);
insert into A540769.TWK005A values(x'4F', 079);
insert into A540769.TWK005A values(x'50', 080);
insert into A540769.TWK005A values(x'51', 081);
insert into A540769.TWK005A values(x'52', 082);
insert into A540769.TWK005A values(x'53', 083);
insert into A540769.TWK005A values(x'54', 084);
insert into A540769.TWK005A values(x'55', 085);
insert into A540769.TWK005A values(x'56', 086);
insert into A540769.TWK005A values(x'57', 087);
insert into A540769.TWK005A values(x'58', 088);
insert into A540769.TWK005A values(x'59', 089);
insert into A540769.TWK005A values(x'5A', 090);
insert into A540769.TWK005A values(x'5B', 091);
insert into A540769.TWK005A values(x'5C', 092);
insert into A540769.TWK005A values(x'5D', 093);
insert into A540769.TWK005A values(x'5E', 094);
insert into A540769.TWK005A values(x'5F', 095);
insert into A540769.TWK005A values(x'60', 096);
insert into A540769.TWK005A values(x'61', 097);
insert into A540769.TWK005A values(x'62', 098);
insert into A540769.TWK005A values(x'63', 099);
insert into A540769.TWK005A values(x'64', 100);
insert into A540769.TWK005A values(x'65', 101);
insert into A540769.TWK005A values(x'66', 102);
insert into A540769.TWK005A values(x'67', 103);
insert into A540769.TWK005A values(x'68', 104);
insert into A540769.TWK005A values(x'69', 105);
insert into A540769.TWK005A values(x'6A', 106);
insert into A540769.TWK005A values(x'6B', 107);
insert into A540769.TWK005A values(x'6C', 108);
insert into A540769.TWK005A values(x'6D', 109);
insert into A540769.TWK005A values(x'6E', 110);
insert into A540769.TWK005A values(x'6F', 111);
insert into A540769.TWK005A values(x'70', 112);
insert into A540769.TWK005A values(x'71', 113);
insert into A540769.TWK005A values(x'72', 114);
insert into A540769.TWK005A values(x'73', 115);
insert into A540769.TWK005A values(x'74', 116);
insert into A540769.TWK005A values(x'75', 117);
insert into A540769.TWK005A values(x'76', 118);
insert into A540769.TWK005A values(x'77', 119);
insert into A540769.TWK005A values(x'78', 120);
insert into A540769.TWK005A values(x'79', 121);
insert into A540769.TWK005A values(x'7A', 122);
insert into A540769.TWK005A values(x'7B', 123);
insert into A540769.TWK005A values(x'7C', 124);
insert into A540769.TWK005A values(x'7D', 125);
insert into A540769.TWK005A values(x'7E', 126);
insert into A540769.TWK005A values(x'7F', 127);
insert into A540769.TWK005A values(x'80', 128);
insert into A540769.TWK005A values(x'81', 129);
insert into A540769.TWK005A values(x'82', 130);
insert into A540769.TWK005A values(x'83', 131);
insert into A540769.TWK005A values(x'84', 132);
insert into A540769.TWK005A values(x'85', 133);
insert into A540769.TWK005A values(x'86', 134);
insert into A540769.TWK005A values(x'87', 135);
insert into A540769.TWK005A values(x'88', 136);
insert into A540769.TWK005A values(x'89', 137);
insert into A540769.TWK005A values(x'8A', 138);
insert into A540769.TWK005A values(x'8B', 139);
insert into A540769.TWK005A values(x'8C', 140);
insert into A540769.TWK005A values(x'8D', 141);
insert into A540769.TWK005A values(x'8E', 142);
insert into A540769.TWK005A values(x'8F', 143);
insert into A540769.TWK005A values(x'90', 144);
insert into A540769.TWK005A values(x'91', 145);
insert into A540769.TWK005A values(x'92', 146);
insert into A540769.TWK005A values(x'93', 147);
insert into A540769.TWK005A values(x'94', 148);
insert into A540769.TWK005A values(x'95', 149);
insert into A540769.TWK005A values(x'96', 150);
insert into A540769.TWK005A values(x'97', 151);
insert into A540769.TWK005A values(x'98', 152);
insert into A540769.TWK005A values(x'99', 153);
insert into A540769.TWK005A values(x'9A', 154);
insert into A540769.TWK005A values(x'9B', 155);
insert into A540769.TWK005A values(x'9C', 156);
insert into A540769.TWK005A values(x'9D', 157);
insert into A540769.TWK005A values(x'9E', 158);
insert into A540769.TWK005A values(x'9F', 159);
insert into A540769.TWK005A values(x'A0', 160);
insert into A540769.TWK005A values(x'A1', 161);
insert into A540769.TWK005A values(x'A2', 162);
insert into A540769.TWK005A values(x'A3', 163);
insert into A540769.TWK005A values(x'A4', 164);
insert into A540769.TWK005A values(x'A5', 165);
insert into A540769.TWK005A values(x'A6', 166);
insert into A540769.TWK005A values(x'A7', 167);
insert into A540769.TWK005A values(x'A8', 168);
insert into A540769.TWK005A values(x'A9', 169);
insert into A540769.TWK005A values(x'AA', 170);
insert into A540769.TWK005A values(x'AB', 171);
insert into A540769.TWK005A values(x'AC', 172);
insert into A540769.TWK005A values(x'AD', 173);
insert into A540769.TWK005A values(x'AE', 174);
insert into A540769.TWK005A values(x'AF', 175);
insert into A540769.TWK005A values(x'B0', 176);
insert into A540769.TWK005A values(x'B1', 177);
insert into A540769.TWK005A values(x'B2', 178);
insert into A540769.TWK005A values(x'B3', 179);
insert into A540769.TWK005A values(x'B4', 180);
insert into A540769.TWK005A values(x'B5', 181);
insert into A540769.TWK005A values(x'B6', 182);
insert into A540769.TWK005A values(x'B7', 183);
insert into A540769.TWK005A values(x'B8', 184);
insert into A540769.TWK005A values(x'B9', 185);
insert into A540769.TWK005A values(x'BA', 186);
insert into A540769.TWK005A values(x'BB', 187);
insert into A540769.TWK005A values(x'BC', 188);
insert into A540769.TWK005A values(x'BD', 189);
insert into A540769.TWK005A values(x'BE', 190);
insert into A540769.TWK005A values(x'BF', 191);
insert into A540769.TWK005A values(x'C0', 192);
insert into A540769.TWK005A values(x'C1', 193);
insert into A540769.TWK005A values(x'C2', 194);
insert into A540769.TWK005A values(x'C3', 195);
insert into A540769.TWK005A values(x'C4', 196);
insert into A540769.TWK005A values(x'C5', 197);
insert into A540769.TWK005A values(x'C6', 198);
insert into A540769.TWK005A values(x'C7', 199);
insert into A540769.TWK005A values(x'C8', 200);
insert into A540769.TWK005A values(x'C9', 201);
insert into A540769.TWK005A values(x'CA', 202);
insert into A540769.TWK005A values(x'CB', 203);
insert into A540769.TWK005A values(x'CC', 204);
insert into A540769.TWK005A values(x'CD', 205);
insert into A540769.TWK005A values(x'CE', 206);
insert into A540769.TWK005A values(x'CF', 207);
insert into A540769.TWK005A values(x'D0', 208);
insert into A540769.TWK005A values(x'D1', 209);
insert into A540769.TWK005A values(x'D2', 210);
insert into A540769.TWK005A values(x'D3', 211);
insert into A540769.TWK005A values(x'D4', 212);
insert into A540769.TWK005A values(x'D5', 213);
insert into A540769.TWK005A values(x'D6', 214);
insert into A540769.TWK005A values(x'D7', 215);
insert into A540769.TWK005A values(x'D8', 216);
insert into A540769.TWK005A values(x'D9', 217);
insert into A540769.TWK005A values(x'DA', 218);
insert into A540769.TWK005A values(x'DB', 219);
insert into A540769.TWK005A values(x'DC', 220);
insert into A540769.TWK005A values(x'DD', 221);
insert into A540769.TWK005A values(x'DE', 222);
insert into A540769.TWK005A values(x'DF', 223);
insert into A540769.TWK005A values(x'E0', 224);
insert into A540769.TWK005A values(x'E1', 225);
insert into A540769.TWK005A values(x'E2', 226);
insert into A540769.TWK005A values(x'E3', 227);
insert into A540769.TWK005A values(x'E4', 228);
insert into A540769.TWK005A values(x'E5', 229);
insert into A540769.TWK005A values(x'E6', 230);
insert into A540769.TWK005A values(x'E7', 231);
insert into A540769.TWK005A values(x'E8', 232);
insert into A540769.TWK005A values(x'E9', 233);
insert into A540769.TWK005A values(x'EA', 234);
insert into A540769.TWK005A values(x'EB', 235);
insert into A540769.TWK005A values(x'EC', 236);
insert into A540769.TWK005A values(x'ED', 237);
insert into A540769.TWK005A values(x'EE', 238);
insert into A540769.TWK005A values(x'EF', 239);
insert into A540769.TWK005A values(x'F0', 240);
insert into A540769.TWK005A values(x'F1', 241);
insert into A540769.TWK005A values(x'F2', 242);
insert into A540769.TWK005A values(x'F3', 243);
insert into A540769.TWK005A values(x'F4', 244);
insert into A540769.TWK005A values(x'F5', 245);
insert into A540769.TWK005A values(x'F6', 246);
insert into A540769.TWK005A values(x'F7', 247);
insert into A540769.TWK005A values(x'F8', 248);
insert into A540769.TWK005A values(x'F9', 249);
insert into A540769.TWK005A values(x'FA', 250);
insert into A540769.TWK005A values(x'FB', 251);
insert into A540769.TWK005A values(x'FC', 252);
insert into A540769.TWK005A values(x'FD', 253);
insert into A540769.TWK005A values(x'FE', 254);
insert into A540769.TWK005A values(x'FF', 255);
commit;
x
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBAF (810) Extract time : 2006-11-06 12:28 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=N UF=N SP=N SQ=N --
-- Grants : SG=N DB=Y TS=Y TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=A005A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS
-- Tablespace=DA540769.A005A
------------------------------------------------------------------------
--
CREATE TABLESPACE A005A
IN DA540769
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 99;
--
------------------------------------------------------------------------
-- Table=A540769.TWK005A In DA540769.A005A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TWK005A
(chr CHAR(1) FOR SBCS DATA NOT NULL,
int integer not null
)
IN DA540769.A005A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE A540769.TWK005A IS 'charset';
--