ucosminexus EUR 3020-7-713
OS Windows 7 x86 Windows 7 x64 1 P-2CD2-5694 ucosminexus EUR Designer 09-00 P-2CD2-5794 ucosminexus EUR Developer 2 09-00 P-2CD2-5394 ucosminexus EUR Viewer 09-00 OS Windows Server 2008 R2 P-29D2-5994 ucosminexus EUR Server Standard 3 09-00 P-29D2-5A94 ucosminexus EUR Server Enterprise 3 09-00 P-29D2-5794 ucosminexus EUR Server Print Edition 3 09-00 P-29D2-5C94 ucosminexus EUR Server - Cipher option 09-00 OS HP-UX 11i V3(IPF) P-1JD2-5991 ucosminexus EUR Server Standard 09-00 P-1JD2-5A91 ucosminexus EUR Server Enterprise 09-00 P-1JD2-5791 ucosminexus EUR Server Print Edition 09-00 P-1JD2-5C91 ucosminexus EUR Server - Cipher option 09-00 OS AIX V6.1 AIX V7.1 P-1MD2-5991 ucosminexus EUR Server Standard 09-00 P-1MD2-5A91 ucosminexus EUR Server Enterprise 09-00 P-1MD2-5791 ucosminexus EUR Server Print Edition 09-00 P-1MD2-5C91 ucosminexus EUR Server - Cipher option 09-00 OS Red Hat Enterprise Linux Server 6 (64-bit x86_64) P-82D2-5991 ucosminexus EUR Server Standard 09-00 P-82D2-5A91 ucosminexus EUR Server Enterprise 09-00 P-82D2-5791 ucosminexus EUR Server Print Edition 09-00 P-82D2-5C91 ucosminexus EUR Server - Cipher option 09-00 1 WOW64 Windows On Windows 64 2 P-2463-2354DABroker 3 P-2963-2354DABroker(64) ISO9001 TickIT
Acrobat Adobe Systems Incorporated ActiveX Microsoft Corporation Adobe Flash Adobe Systems Incorporated( ) Adobe Reader Adobe Systems Incorporated( ) AIX International Business Machines Corporation AMD Advanced Micro Devices, Inc. BSAFE EMC Corporation ESC/P ( ) GIF CompuServe Inc. HP-UX Hewlett-Packard Development Company, L.P. Internet Explorer Microsoft Corporation Itanium Intel Corporation Linux Linus Torvalds LIPSIII Microsoft Hyper-V Microsoft Corporation Microsoft MS-DOS Microsoft Corporation Microsoft Visual Basic Microsoft Corporation Microsoft Visual C++ Microsoft Corporation Microsoft.NET Microsoft Excel Microsoft Corporation Microsoft Office Microsoft Corporation Microsoft Office Excel Microsoft Corporation Microsoft Office Word Microsoft Corporation Microsoft Word Microsoft Corporation ODBC Microsoft Corporation OLE Microsoft Corporation Oracle Java Oracle Corporation PostScript Adobe Systems, Inc. QR Red Hat Red Hat, Inc. RPM RPM Package Manager RSA EMC Corporation SQL Server Microsoft Corporation UNIX The Open Group Windows Microsoft Corporation Windows Server Microsoft Corporation
BBB L-KL P-29D2-5C94 P-1JD2-5C91 P-1MD2-5C91 P-82D2-5C91 EMC Corporation RSA BSAFE(R).NET ActiveX Microsoft(R).NET ActiveX(R) Excel Microsoft(R) Excel Version 2002 Microsoft(R) Office Excel 2003 Microsoft(R) Office Excel 2007 Microsoft(R) Office Excel 2010 Internet Explorer Microsoft(R) Internet Explorer(R) Windows(R) Internet Explorer(R) SQL Server Microsoft(R) SQL Server 2005 Microsoft(R) SQL Server 2008 Microsoft(R) SQL Server 2008 R2 VBScript Visual Basic Visual C++ Windows Windows 7 Windows 7 x86 Windows 7 x64 Microsoft(R) Visual Basic(R) Scripting Edition Microsoft(R) Visual Basic(R) Microsoft(R) Visual C++(R) Microsoft(R) Windows(R) 7 Professional(32 ) Microsoft(R) Windows(R) 7 Enterprise(32 ) Microsoft(R) Windows(R) 7 Ultimate(32 ) Microsoft(R) Windows(R) 7 Professional(64 ) Microsoft(R) Windows(R) 7 Enterprise(64 ) Microsoft(R) Windows(R) 7 Ultimate(64 ) Windows Server 2003 Windows Server 2003 Microsoft(R) Windows Server(R) 2003, Standard Edition Microsoft(R) Windows Server(R) 2003, Enterprise Edition
Windows Server 2008 Windows XP Windows Server 2003 R2 Windows Server 2003 R2 x64 Windows Server 2003 x64 Microsoft(R) Windows Server(R) 2003 R2, Standard Edition Microsoft(R) Windows Server(R) 2003 R2, Enterprise Edition Microsoft(R) Windows Server(R) 2003 R2, Standard x64 Edition Microsoft(R) Windows Server(R) 2003 R2, Enterprise x64 Edition Microsoft(R) Windows Server(R) 2003, Standard x64 Edition Microsoft(R) Windows Server(R) 2003, Enterprise x64 Edition Microsoft(R) Windows Server(R) 2008 R2 Standard Microsoft(R) Windows Server(R) 2008 R2 Enterprise Microsoft(R) Windows Server(R) 2008 R2 Datacenter Microsoft(R) Windows(R) XP Professional Operating System Microsoft(R) Windows(R) XP Home Edition Operating System Word Microsoft(R) Word Version 2002 Microsoft(R) Office Word 2003 Microsoft(R) Office Word 2007 Microsoft(R) Office Word 2010 2012 3 3020-7-713 All Rights Reserved. Copyright (C) 2012, Hitachi, Ltd. All Rights Reserved. Copyright (C) 2012, Hitachi Solutions, Ltd.
ucosminexus EUR Designer ucosminexus EUR Developer ucosminexus EUR Viewer ucosminexus EUR Server Standard ucosminexus EUR Server Enterprise ucosminexus EUR Server Print Edition ucosminexus EUR Server - Cipher option EUR EUR EUR A B A B A B C A B C A A B C B C I
A, A A 1 A B C A B C C GUI GUI II
1 EUR 1 1.1 2 1.1.1 EUR 2 1.1.2 EUR 2 1.1.3 EUR 4 1.2 EUR 6 1.2.1 6 1.2.2 6 1.2.3 7 1.2.4 8 1.3 EUR ODBC Driver 10 1.3.1 UTF-8 10 2 11 2.1 12 2.2 14 2.3 DABroker 15 2.3.1 DABroker 15 2.3.2 16 2.3.3 17 2.3.4 DABroker 18 2.3.5 27 2.4 DABroker 29 2.4.1 29 2.4.2 29 2.5 EUR DABroker 31 2.6 ODBC Driver 32 2.6.1 32 2.6.2 ODBC 32 3 35 3.1 36 i
3.2 38 3.2.1 EUR 38 3.2.2 40 3.3 41 3.3.1 42 3.3.2 47 3.3.3 55 3.3.4 63 3.4 65 3.5 67 3.6 68 3.6.1 EUR 68 3.6.2 69 3.6.3 70 3.7 71 3.7.1 71 3.7.2 72 3.7.3 74 3.7.4 76 3.7.5 80 4 81 4.1 82 4.1.1 82 4.2 86 4.2.1 86 5 89 5.1 91 5.2 95 5.3 98 5.4 100 5.5 101 5.6 103 5.7 106 ii
5.8 108 5.9 109 5.10 111 5.11 115 5.12IN 116 5.13BETWEEN 118 5.14 119 5.15 121 5.16 123 5.17 124 5.18 126 5.19 127 5.20 129 5.21 130 5.22 131 5.22.1 131 5.22.2 131 5.22.3 133 5.23 135 5.24 137 5.25EUR ODBC Driver - - 138 5.26EUR ODBC Driver - - 140 6 EUR 141 6.1 142 6.2 143 6.3 146 6.4 DBL0001 DBL0999 147 6.5 DBL1000 DBL1999 149 6.6 DBP0001 DBP0999 152 6.7 DBP1000 DBP1999 165 6.8 DBP2000 DBP2999 177 6.9 DBP3000 DBP3999 180 6.10 DBP6000 DBP6999 189 6.11 DBP8000 DBP8999 192 iii
7 DABroker 193 7.1 195 7.2 196 7.3 199 7.4 KFDB001DB KFDB999DB 201 7.5 KFDB001EC KFDB999EC 215 7.6 KFDB001LC KFDB999LC 218 7.7 KFDB001LM KFDB999LM 219 7.8 KFDB001MM KFDB999MM 220 7.9 KFDB001NM KFDB999NM 225 7.10 KFDB001RC KFDB999RC 236 7.11 KFDB001RM KFDB999RM 237 7.12 KFDB001RR KFDB999RR 238 7.13 KFDB001SC KFDB999SC 240 7.14 KFDB001SM KFDB999SM 242 7.15 KFDB001TD KFDB999TD 245 7.16 KFDB001TM KFDB999TM 255 7.17 KFDB001TR KFDB999TR 265 7.18 KFDB001YM KFDB999YM 267 277 A DABroker 278 A.1 DABroker 278 B DABroker 293 B.1 DABroker 293 B.2 DABroker 293 C 295 C.1 295 C.2 EUR 9 297 C.3 EUR 9 299 C.4 299 C.5 301 C.6 KB 303 iv
305 v
1 EUR EUR ODBC Driver 1.1 1.2 EUR 1.3 EUR ODBC Driver 1
1. EUR 1.1 EUR 1.1.1 EUR EUR 3. 1.1.2 EUR DABroker 2. 2
1. EUR 1-1 EUR 1. 2. EUR 1 3. 4. CSV 3
1. EUR 4.1 4.2 1.1.3 EUR DABroker 2. 1-2 EUR 4
1. EUR CSV 4.1 4.2 5
1. EUR 1.2 EUR EUR 3 HiRDB Oracle SQL Server EUR 1.2.1 EUR 1-1 EUR HiRDB Oracle SQL Server 1.2.2 1-2 Shift JIS UTF-8 HiRDB Oracle SQL Server SQL Server Unicode nchar nvarchar ntext 6
1. EUR 1.2.3 EUR 1-3 EUR HiRDB CHARACTER(n) CHAR VARCHAR(n) VARCHAR NCHAR(n) NATIONAL CHARACTER(n) NCHAR NVARCHAR(n) NVARCHAR MCHAR(n) MCHAR MVARCHAR(n) MVARCHAR DATE DATE TIME TIME LARGE DECIMAL(m,n) DECIMAL FLOAT DOUBLE PRECISION FLOAT INTEGER INTEGER SMALLFLT REAL REAL SMALLINT SMALLINT Oracle CHAR(n) CHAR VARCHAR2(n) VARCHAR LONG LONG VARCHAR DATE TIMESTAMP RAW VARBINARY FLOAT FLOAT NUMBER(p,s) 1 NUMERIC SQL Server char CHAR varchar VARCHAR text LONG VARCHAR nchar UCHAR 2 nvarchar UVARCHAR 2 ntext LONG UVARCHAR 2 datetime smalldatetime TIMESTAMP binary timestamp BINARY varbinary VARBINARY 7
1. EUR bit BIT decimal money smallmoney DECIMAL float DOUBLE int INTEGER numeric NUMERIC real REAL smallint SMALLINT tinyint TINYINT 1 Oracle NUMBER NUMERIC 38,0 38 EUR EUR EUR 2 Unicode 1.2.4 Shift JIS DABroker DABLANGMODESJIS Shift JIS DABroker 2.3.4 DABroker Shift JIS 1 0x20 0x7E 0xA1 0xDF 2 1 0x81 0x9F 0xE0 0xFC 2 2 0x40 0x7E 0x80 0xFC CHAR 0x00 0x00 0x00 NULL Unicode 8
1. EUR DABroker (DABLANGMODE) UTF-8 UTF-8 UTF-8 UTF-8 1 2 3 00-7F ASCII C0-DF 80-BF UCS-2 0x0080-0x07FF E0-EF 80-BF 80-BF UCS-2 0x0800-0xFFFF ASCII (X'20' X'7E') UCS-2 (0x0080-0x07FF 0x0800-0xFFFF) 0 NULL NULL 0 NULL Shift JIS Shift JIS " 9
1. EUR 1.3 EUR ODBC Driver EUR ODBC Driver EUR ODBC Driver EUR ODBC Driver EUR ODBC Driver EUR ODBC Driver EUR EUR ODBC Driver Shift JIS Unicode DBPARTNER ODBC Driver DBPARTNER ODBC Driver EUR Developer DBPARTNER ODBC Driver Shift JIS EUR ODBC Driver EUR ODBC ODBC Driver ODBC Driver 2.6.2 ODBC 1.3.1 UTF-8 EUR 1 ID ANSI ASCII 0x20 0x7E 2 ID ANSI ASCII 0x20 0x7E GB2312 3 ID ANSI ASCII 0x20 0x7E Shift JIS 10
2 EUR DABroker EUR ODBC Driver 2.1 2.2 2.3 DABroker 2.4 DABroker 2.5 EUR DABroker 2.6 ODBC Driver 11
2. 2.1 EUR DABrokerEUR ODBC Driver EUR DABroker EUR Developer EUR ODBC Driver DABroker ODBC Driver DABroker ODBC Driver EUR EUR Developer EUR EUR Server EUR DABroker DABroker 12
2. DABroker EUR DABroker ODBC Driver 2.2 4.1 EUR DABroker 13
2. 2.2 1. DABroker 2.3 DABroker 2. EUR 2.3.5 3. DABroker 2.4 DABroker 4. DABroker EUR EUR 2.5 EUR DABroker 5. ODBC Driver EUR 2.6 ODBC Driver 14
2. 2.3 DABroker Windows EUR DABroker UNIX/Linux DABroker DABroker DABroker 2-1 DABroker 2.3.1 DABroker EUR DABroker EUR EUR Developer 32bit DABroker EUR Server 64bit DABroker(64) DABroker 2.5 EUR DABroker 32bit DABroker 15
2. 32bit 64bit DABroker(64) 64bit 2.3.2 DABroker DABroker.msi DABroker.msi EUR Developer EUR Server EUR Server Print Edition EUR Server Standard EUR Server Enterprise Component DABROKER DABroker ()="'# 64bit OS 32bit DABroker C: Program Files (x86) Hitachi DABroker DABroker Path DABroker lib DABroker 1 DABroker DABroker DABroker DABroker 2-1 DABroker DABroker DABroker DABroker bin 16
2. lib AGT AGTGRP msg conf spool tmp DABroker DABroker DABroker 2 DABroker(64) DABroker(64) Microsoft Visual C++ 2005 Service Pack 1 Microsoft 2.3.3 TCP/IP DABroker Windows system32 drivers etc services DABroker UNIX Linux services /etc DABROKER_SV 40179/tcp DABROKER_SV DABroker 40179 tcptcp/ip 17
2. services 40179 5001 65535 NIS Network Information Service NIS NIS NIS DABroker IP 2.3.4 DABroker DABroker DABroker(64) 1 DABroker DABroker DABroker DABroker UNIX/Linux DABroker DABroker /conf 2 DABroker Windows Administrators 3 DABroker DABroker DABroker 1. DABroker 2. 18
2. 3. OK 4 2-2 1. DABTMP DABroker tmp DABroker SQL... 2. dabsv.logdabsvlogsize 19
2. 64 0 64 32,767 DABroker DABroker spool dabsv.log 0 64 32,767 1 dabsv.logold1 3. ORACLE DABORACLE_TYPE ORACLE9i ORACLE9i ORACLE 10g ORACLE 11g Oracle DABroker(64) ORACLE9i ORACLE10g 4. HiRDB DABSQL_HiRDB_DICTIONARY_DATATYPE C VARCHAR M C HiRDB M MVARCHAR C 20
2. VARCHAR HiRDB SQL 5. HiRDB DAB_HIRDB_DBINF_ESC @ @! $ % & * + - / :? HiRDB @ 1 DABroker Driver for Java TM Technology HiRDB @ 6. DABSQL_TRCSIZE OFF OFF ON OFFON A.1(2) DABroker DABroker spool db_access DABroker db_xxxxx XXXXX 21
2. A.1(2) DABroker DABroker 7. DABEXSQL_TRC_LINE OFF OFF ON OFFON OFF ON A.1(3) 8. 1,024 0 1,024 32,767 7. DABEXSQL_TRC_LINE ON 0 1,024 32,767 1 134 A.1(3) 22
2. 5 2-3 1. DABCLIENT_TIMEOUT 3,600 0 1 65,535 1 65,535 DABroker DABroker 23
2. 0 2. DABMAXUSERS 10 1 100,000 DABroker EUR 3. DABDBANUMBER 20 1 100,000 DABroker EUR 4. 1 DABMAXBLOCKUSERS 1 1 100 EUR 1 5. DABMAXPROCESS 10 1 1,000 24
2. DABroker 1 6. DABLANGMODE SJIS JIS SJIS JIS UTF-8 UTF-8 ASCII ASCII DABroker 2-2 DABroker JIS UTF-8 ASCII HiRDB Oracle SQL Server SQL Server 2000 DABroker DABroker SQL Server 2005 UTF-16 DABroker UTF-8 DABroker EUC ASCII UTF-8 DBPARTNER ODBC Driver DABroker SJIS JIS 7. TCP/IP DABKEEPALIVE OFF 25
2. OFF ON OFFON TCP/IP ON OFF 8. IP DABIPCONVERT ON OFF ON OFFON IP ON IP OFF IP 9. DABTCP_TRCSIZE OFF OFF ON OFFON A.1(2) DABroker 26
2. DABroker spool dabcltrc DABroker XXXXXXXX.cmt XXXXXXXX.cmt_AA AA XXXXXXXX AA AA DABroker DABroker 2.3.5 EUR DABroker 1 HiRDB DABroker HiRDB HiRDB PDHOST PDNAMEPORT IP ODBC Driver HiRDB HiRDB UAP 2 Oracle a Oracle DABroker Oracle Oracle Oracle b Oracle Oracle DABroker Oracle 27
2. c Oracle UTF-8 DABroker Oracle NLS_LANG NLS_LANG Oracle NLS_LANG=JAPANESE_JAPAN.UTF8 3 SQL Server DABroker SQL Server ODBC SQL Server ODBC SQL Server ID SQL Server ID SQL Server ODBC 64bit OS 32bit DABroker Windows SysWow64 ODBC odbcad32.exe 28
2. 2.4 DABroker DABroker 2.4.1 a Windows Administrators b DABroker 1. 2. DABroker 3. EUR 1 2 c DABroker DABroker DABroker Windows DABroker 2.4.2 a Windows Administrators b DABroker 1. EUR 2. DABroker 3. 29
2. 2 3 c DABroker EUR 1. DABroker DABroker 2. 3. DABroker EUR DABroker DABroker A.1 DABroker DABroker EUR 2 EUR DABroker 1. 2. DABroker DABroker DABroker 30
2. 2.5 EUR DABroker EUR DABroker DABroker EUR DABroker DABROKER_SV services 2.3.3 40179 EUR 2.6 ODBC Driver 31
2. 2.6 ODBC Driver EUR ODBC Driver ODBC Driver EUR 2.6.1 EUR ODBC Driver DABroker DBPARTNER_SV DABroker services DABroker 2.3.3 40179 2.5 EUR DABroker DBPARTNER_SV 40179/tcp 2.6.2 ODBC ODBC Driver DABroker ODBC EUR ODBC Driver ODBC 1. 2. ODBC ODBC 3. ODBC DSN 4. EUR ODBC Driver EUR ODBC Driver - - EUR ODBC Driver - -DABroker 64bit OS Windows system32 ODBC odbcad32.exeeur ODBC EUR 32
2. ODBC DriverEUR ODBC Windows SysWow64 ODBC 33
3 EUR 3.1 3.2 3.3 3.4 3.5 3.6 3.7 35
3. 3.1 EUR 1.2 EUR 2.1 36
3. 3-1 37
3. 3.2 EUR EUR 3.2.1 EUR 1 1. 2. 3. ID * 38
3. EUR ODBC Driver 2.1 4. OK OK ID OK 3-1 39
3. EUR 2 3.2.2 1 1. 2. 2 40
3. 3.3 EUR SQL Shift JIS UTF-8 1 3-2 3.3.1 ( ) 50,000 AND 50,000 3.3.1(2) 3.3.1(3) 3.3.1(4) 3.3.2 3.3.3 3.3.3 3.4 41
3. EUR 3.7 3.3.1 3.7 1 1. (2) 2. Shift JIS 15 15 (4) (3) 42
3. 3. OK 2 a 1. 43
3. 2. 3. 4. OK 3 *? * 0? 1 + 254 *? * * 44
3.???? * *3 a 5.5 1. 2. 3. 4. OK 4 EUR = <> > >= < <= 45
3. 3-3 CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR NCHAR NVARCHAR UCHAR UVARCHAR LONG UVARCHAR NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE DATE TIME BINARY VARBINARY LONG VARBINARY TIMESTAMP CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR NCHAR NVARCHAR UCHAR UVARCHAR LONG UVARCHAR NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE DATE TIME BINARY VARBINARY LONG VARBINARY TIMESTAMP SQL Server Unicode 46
3. a 1. (1) 2. 3. 4. 1 2 1 2 =<>> >=<<= 5. OK OK b c A h B i h i HiRDB ALIAS ALIAS 3.3.2 47
3. 3-4 1 a 1. 2. (2) (4) ( ) (5) 48
3. 3. OK 2 3-5 49
3. 3-6 NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE CHAR VARCHAR LONG VARCHAR NCHAR NVARCHAR MCHAR MVARCHAR UCHAR UVARCHAR LONG UVARCHAR DATE TIME TIMESTAMP BINARY VARBINARY SQL Server Unicode a 1. 2. 3. 50
3. 4. OK OK 3 3-2 a 1. 2. 51
3. 3. 4. OK OK 4 255 52
3. 255 a 1. 2. 3. 4. 53
3. 5. OK OK 5 ( ) 46 30,000 LONG VARBINARY 3-3 54
3. SQL SQL a 1. 2. 3. 46 " 4. OK OK 3.3.3 55
3. 3-7 = <> > >= < <= NULL NULL NULL NULL NOT NULL NULL NULL LIKE LIKE NOT LIKE IN BETWEE N 1 2 ( 1 2 ) ( 1 2 ) + * / ( ) WHERE SQL WHERE 1 1. 2. 56
3. NULL LIKE IN BETWEEN WHERE 3. OK OK 2 3-8 CHAR '' ' '' VARCHAR '' ' '' 1 255 1 255 LONG VARCHAR '' ' '' 1 255 MCHAR '' ' '' MVARCHAR '' ' '' 1 255 1 255 NCHAR '' 1 254 NVARCHAR '' 1 254 UCHAR '' ' '' UVARCHAR '' ' '' LONG '' UVARCHAR ' '' 1 255 1 255 1 255 57
3. BINARY 16 ' 0 9 A F ' 1 254 VARBINARY LONG VARBINARY NUMERIC 10. DECIMAL 10. SMALLINT -32768 32767 INTEGER -2147483648 2147483647 TINYINT -256 255 BIT 0 1 0 1 REAL FLOAT DOUBLE E 1.7E 308 18 3 E 1.7E 308 18 3 E 1.7E 308 18 3 DATE ' YYYY-MM-DD ' YYYYMMDD - YYYY 0001 9999 MM 01 12 DD 01 TIME ' hh:mm:ss ' hhmmss : hh 00 23 mm 00 59 ss 00 59 TIMESTAMP(1 6 ) ' YYYY-MM-DD hh:mm ' YYYY 0001 9999 MM 01 12 DD 01 hh 00 23 mm 00 59 58
3. TIMESTAMP(1 9 ) ' YYYY-MM-DD hh:mm:ss ' YYYY 0001 9999 MM 01 12 DD 01 hh 00 23 mm 00 59 ss 00 59 TIMESTAMP(2 3 ) ' YYYY-MM-DD hh:mm:ss.nnn '. 3 YYYY 0001 9999 MM 01 12 DD 01 hh 00 23 mm 00 59 ss 00 59 nnn 000 999 TIMESTAMP(2 6 ) ' YYYY-MM-DD hh:mm:ss.nnnnnn '. 6 YYYY 0001 9999 MM 01 12 DD 01 hh 00 23 mm 00 59 ss 00 59 nnn 000 999 SQL Server Unicode 3 3-8 = <> > >= < <= 59
3. 4 NULL NULL NULL NULL NULL NULL NOT NULL 5 LIKE LIKE _ % NCHAR NVARCHAR _ % CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR UCHAR UVARCHAR LONG UVARCHAR UCHAR UVARCHAR LONG UVARCHAR SQL Server Unicode 3-9 ABC% ABC %ABC ABC %ABC% ABC ABC ABC ABC_ 6 3 5 ABC ABC%DE ABC DE %ABC%DE% ABC DE ABC DE% ABC 2 DE LIKE LIKE NOT LIKE 60
3. 3-8 6 IN IN IN IN IN 11 IN OK 3-8 7 BETWEEN 1 2 ( 1 2 ) ( 1 2 ) BETWEEN BETWEEN BETWEENBETWEEN 1 2 BETWEEN OK 3-8 8 + * / ( ) {= <> > >= < <=} {= <> > >= < <=} ::= { {+ -} {+ - * /} } ::= { } 61
3. ::= + * / ( ) 3-8 3-10 NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE OK 9 WHERE SQL WHERE WHERE 3-11 CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR NCHAR NVARCHAR NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE DATE TIME CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR NCHAR NVARCHAR NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE DATE TIME 62
3. BINARY VARBINARY LONG VARBINARY TIMESTAMP BINARY VARBINARY LONG VARBINARY TIMESTAMP OK 10 3.3.1(4) 11 a A Z a z 0 9 1 b 255 3-8 3.3.4 63
3. 3-12 1 64
3. 3.4 3-13 CSV CSV.NET Framework 1. 65
3. 2. 66
3. 3.5 1 1. OK OKOK 2. 3. 67
3. 3.6 EUR 3.6.1 EUR EUR EUR 3-14 EUR CHAR VARCHAR NCHAR NVARCHAR MCHAR MVARCHAR LONG VARCHAR UCHAR 1 UVARCHAR 1 LONG UVARCHAR 1 DATE TIME TIMESTAMP 2 BINARY VARBINARY 3 DECIMAL FLOAT INTEGER REAL SMALLINT NUMERIC BIT DOUBLE TINYINT 1 SQL Server Unicode 2 3 68
3. EUR 3.6.2 1 3-15 EUR 2 2 3.6.1 EUR 3 69
3. 3.6.3 3-14 EUR EUR 70
3. 3.7 3.7.1 1 1. 2. 3. 4. 71
3. DB 5. EUR Designer EUR Designer partnerw EUR Developer EUR Developer EUR Designer partnerw... DB ( ) 3.7.2 72
3. 1 1. 2. 3. 4. OK OK OK 73
3. Shift JIS 5. 3-16 0 30 0 46 6. 7. 3.7.3 1 74
3. 1. 2. 3. 4. 5. 3-17 0 30 0 46 75
3. Shift JIS 6. 7. 3.7.4 1 EUR EUR Designer EUR Designer partnerw EUR Developer EUR Developer EUR Designer partnerw 3-18 Dptindex.dpd Dptindex2.dpd Dpt00001.dpd Dpt65535.dpd a 1. 2. 76
3. 3. Shift 4. F 5. 4. OK 6. 2 a 1. 2. 3. OK OK 4. 77
3. 5. OK 3 a 1. 2. 3. Shift 4. 78
3. 5. 4 a 1. 2. 3. F... 4. OK 3 5. 79
3. 6. 5 3.7.5 1 1. 2. 3. 4. 5. 80
4 4.1 4.2 81
4. 4.1 EUR 4.1.1 1 = 0 2 EUR 4651 EUR KEEU055-E 4-1 DABrokerHost DABroker IP DBType HiRDBORACLE SQLServer SendBufferSize 1 16,000 KB TimeoutInterval 0 3,600 Hostname 1 2 HiRDB IP PDHOST ORACLE SQLServer ODBC 82
4. HostInfo 1 2 HiRDB PDNAMEPORT ORACLE SQLServer User 1 3 ID Password 1 3 QueryExclusiveStrin g 1 EncryptPassword EUR 4.1.1(5) EUR SQL QueryExclusiveString HiRDB HiRDB UAP EUR 1 2 DABroker 2.3.5 3 EUR ID 83
4. 3 DABrokerHost = hostname DBType = HiRDB SendBufferSize = 64 TimeoutInterval = 60 User = USERID QueryExclusiveString = WITH ROLLBACK 4 2.3.5 a HiRDB Hostname HiRDB IP PDHOST DABroker PDHOST HostInfo HiRDB PDNAMEPORT DABroker PDNAMEPORT b Oracle Hostname DABroker Oracle Hostname DABroker ORACLE_SID c SQL Server Hostname DABroker ODBC DSN SQL Server 5 EUR Password EncryptPassword TRUE a EUR Developer EUR Server EUR Server Print Edition EUR Server Standard EUR Server Enterprise 84
4. Windows Windows eurecdif.exe eurecdif.exe EUR Developer Windows EUR Server EUR Server Print Edition EUR Server Standard EUR Server Enterprise Cipher x64 eurecdif.exe /if /of /if 259 /of 259 UNIX Linux UNIX Linux eurecdif eurecdif /opt/eur/print/bin/ eurecdif -if -of -if 1,023 -of 1,023 b 85
4. 4.2 4.2.1 1 1 =1 2 =2 n =n 0 n EUR 255 1 254 2 A Z 0 9 1 1 EUR 86
4. 4658 4672 EUR KEEU056-E 2 = = 100 87
5 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 5.10 5.11 5.12IN 5.13BETWEEN 5.14 5.15 89
5. 5.16 5.17 5.18 5.19 5.20 5.21 5.22 5.23 5.24 5.25EUR ODBC Driver - - 5.26EUR ODBC Driver - - 90
5. 5.1 2.1 1 5-1 (A) (C)... (D) (S) (T)... (U)... (C)... (E).NET Framework (N) 91
5. 92 2 nnn 1 99,999 30 (X) (L)... (O)... (H) (W)
5. 1 999,999,999 1 9 10 20 30 40 50 100 200 300 400 500 1000 2000 3000 4000 5000 10000 999,999,999 5.2.NET Framework 10 OK 93
5. 3 94
5. 5.2.NET Framework 3. 1 5-2 (F) (X) (S) (N) (A) (O)... CSV (C) (H) (W) 95
5. 2 1 1,000 1,000 20,000 1 a 96
5. b c CSV UTF-16 3 97
5. 5.3 1 5.4 15 15 5.5 98
5. 2 99
5. 5.4 1 2 100
5. 5.5 1 5 Unicode * * 0? 1 ( ABC*) ABC ( *ABC) ABC (?ABC?) 5 2 4 ABC ( *ABC*) ABC *? 254 101
5. abc ABC 2 102
5. 5.6 1 103
5. 5.9 1 10,000 5.9 104
5. 5.7 5.8 5.9 2 105
5. 5.7 1 255 2 106
5. 2 107
5. 5.8 1 255 2 108
5. 5.9 1 46 Unicode LONG VARBINARY 30,000 Unicode 1 1 () +-*/0 9000. 109
5. 2 110
5. 5.10 1 5.22 UNQ UNQ DUP DUP 2 2 111
5. IN NOT IN IN IN BETWEEN NOT BETWEEN = <> < <= > >= ( ) E+ E- / * - + = <> < <= > >= ( ) / * - + = <> < <= > >= NULL NOT NULL LIKE NOT LIKE BETWEEN BETWEEN 3-8 LIKE NOT LIKE & 5.16 = <> < <= > >= NULL NOT NULL LIKE NOT LIKELIKE NOT LIKE 112
5. CHAR VARCHAR LONG VARCHAR NCHAR NVARCHAR MCHAR MVARCHAR UCHAR UVARCHAR LONG UVARCHAR UCHAR UVARCHAR LONG UVARCHAR SQL Server Unicode Unicode? ANDORNOT () 255 (1 OR 2) AND (3 OR 4) AND 113
5. 2 114
5. 5.11 1 1 1 1 2 =<>>>=<<= 2 2 1 2 = 2 115
5. 5.12IN IN IN 1IN IN IN IN NOT IN 255 Unicode 3-8 10 10 & 5.16 116
5. 2 117
5. 5.13BETWEEN BETWEEN BETWEEN 1BETWEEN BETWEEN BETWEEN 3-8 BETWEEN 1 2 NOT BETWEEN 1 2 1 2 Unicode 1 2 & 5.16 2 118
5. 5.14 1 Unicode <<==<>>=> 1 1 ()E+E-+-*/0 9000. 64 + - * /( ) /0 10 119
5. 2 120
5. 5.15 IN BETWEEN 1 SQL WHERE Unicode EUR <<==<>>=> 1 1 () +-*/0 9000. EUR 121
5. 2 122
5. 5.16 1 (V)...255 1 254 A Z a z 0 9 1 Unicode 255 Unicode 2 123
5. 5.17 1 Shift JIS 30 5.19 Shift JIS 46 5.19 124
5. 5.3 5.3 5.18 EUR 2 125
5. 5.18 1 2 126
5. 5.19 1 32,767 32,767 5.20 Shift JIS 127
5. 5.21 2 128
5. 5.20 1 2 129
5. 5.21 1 2 130
5. 5.22 5.22.1 1 1 999 2 5.22.2 1 131
5. 1 2 1 2 MAX MIN AVG SUMCOUNT MAX 5.10 132
5. 2 5.22.3 1 133
5. DB Unicode 5.24 2 134
5. 5.23 1 255 Unicode ' 3-8 5-3 BINARY ' 0 9 A F ' BIT 0 1 CHAR VARCHAR LONG VARCHAR DATE DOUBLE FLOAT REAL LONG VARBINARY MCHAR MVARCHAR NCHAR NVARCHAR NUMERIC DECIMAL '' ' YYYY-MM-DD ' YYYYMMDD - E '' ''. 135
5. TIME TIMESTAMP 16 TIMESTAMP 19 TIMESTAMP 23 TIMESTAMP 26 TINYINT INTEGER SMALLINT UCHAR UVARCHAR LONG UVARCHAR VARBINARY ' hh:mm:ss ' hhmmss : ' YYYY-MM-DD hh:mm ' ' YYYY-MM-DD hh:mm:ss ' ' YYYY-MM-DD hh:mm:ss.nnn '. 3 ' YYYY-MM-DD hh:mm:ss.nnnnnn '. 6 '' 2 SQL Server Unicode 136
5. 5.24... 1 2 137
5. 5.25EUR ODBC Driver - - EUR ODBC Driver - - 1EUR ODBC Driver - - 32 DABroker IP 32 ODBC Driver EUR HiRDB Oracle SQL Server EUR 2.3.5 HiRDB HiRDB PDNAMEPORT DABroker PDNAMEPORT Oracle DABroker Oracle DABroker ORACLE_SID SQL Server DABroker ODBC DSN SQL Server SQL Server 138
5. HiRDB HiRDB DABroker PDHOST 1 16,000 KB64 KB EUR ODBC Driver - - 2 139
5. 5.26EUR ODBC Driver - - EUR ODBC Driver - - 1EUR ODBC Driver - - WINSOCK 0 3,60060 0 2 140
6 EUR EUR EUR 6.1 6.2 6.3 6.4 DBL0001 DBL0999 6.5 DBL1000 DBL1999 6.6 DBP0001 DBP0999 6.7 DBP1000 DBP1999 6.8 DBP2000 DBP2999 6.9 DBP3000 DBP3999 6.10 DBP6000 DBP6999 6.11 DBP8000 DBP8999 141
6. EUR 6.1 1 DBPxxxxy 6-1 DBPxxxxy ID xxxx y I InformationW Warning E Error 2 ODBC Driver EUR DBLxxxxy 6-2 ODBC Driver DBLxxxxy ID xxx y I InformationW Warning E Error 142
6. EUR 6.2 ID ID 6-3 ID ID ID ID OS error OS OS 143
6. EUR EUR eurps U R F P D DI DO E 10 C I Information W WarningE Error I InformationW Warning E Error /nomessage UNIX Linux -nomessage /message UNIX Linux -message EUR 0 4 EUR 8 10 12 16 2008 ActiveX 2016 ActiveX 144
6. EUR 32 145
6. EUR 6.3 EUR EUR 1 EUR EUR 2 Windows Error Windows Windows 3 EUR EUR EUR EUR HITACHI EUR HIEUR.LOG C: Users AppData Roaming 146
6. EUR 6.4 DBL0001 DBL0999 DBL0010E 0 3600 0 3600 DBL0020E DBL0100E EUR ODBC Driver EUR ODBC Driver - - DBL0101E EUR ODBC Driver EUR ODBC Driver EUR ODBC Driver 147
6. EUR EUR ODBC Driver EUR ODBC Driver DBL0401E [ (),errno= ] OS 148
6. EUR 6.5 DBL1000 DBL1999 DBL1001E EUR ODBC Driver DBL1002E [errno= ] DBL1003E TCP [errno= ] TCP DABroker 149
6. EUR TCP/IP TCP DBL1004E [errno= ] DABroker EUR ODBC Driver DBL1005E DABroker EUR ODBC Driver EUR ODBC Driver - - DBL1006E 150
6. EUR DBL1007E [errno= ] DBL1011E EUR ODBC Driver - - 151
6. EUR 6.6 DBP0001 DBP0999 DBP0001E Windows DBP0002E DBP0005W DBP0006W nnn 152
6. EUR nnn nnn DBP0007E EUR EUR EUR Form EUR EUR EUR Form DBP0010W DBP0011W 153
6. EUR DBP0012W DBP0013W DBP0018W. 154
6. EUR DBP0019I DBP0020W 254 DBP0022I DBP0025W 256 155
6. EUR DBP0501W DBP0502W 3.3.3EUR EUR Form DBP0503W DBP0505W 3.3.3(2)EUR EUR Form 156
6. EUR DBP0507W SQL SQL DBP0508W 64 64 OR AND DBP0509W AND OR NOT 255 AND OR NOT 255 AND OR NOT 255 DBP0510W 157
6. EUR 3.3.3(5) LIKE EUR EUR Form DBP0511W ' ' ' DBP0512W DBP0513W 6-4 1 CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR NCHAR NVARCHAR UCHAR UVARCHAR LONG UVARCHAR 2 CHAR VARCHAR LONG VARCHAR MCHAR MVARCHAR NCHAR NVARCHAR UCHAR UVARCHAR LONG UVARCHAR 158
6. EUR NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE DATE TIME BINARY VARBINARY LONG VARBINARY TIMESTAMP 1 NUMERIC DECIMAL SMALLINT INTEGER REAL FLOAT BIT TINYINT DOUBLE DATE TIME BINARY VARBINARY LONG VARBINARY TIMESTAMP 2 SQL Server Unicode DBP0514W DBP0515W DBP0516W 159
6. EUR DBP0517W DBP0518W DBP0519W 64 64 DBP0520W () 160
6. EUR DBP0521W DBP0522W DBP0523W " DBP0524W NULL IN LIKE BETWEEN 161
6. EUR DBP0525W 3.3.3EUR EUR Form DBP0526W 3.3.3(2)EUR EUR Form DBP0527W DBP0529W 162
6. EUR DBP0530W DBP0532W 3.3.3(2)EUR EUR Form DBP0533W 64 64 64 DBP0534W AND OR 254 AND OR 254 AND OR 254 163
6. EUR DBP0535W 3.3.3EUR EUR Form 164
6. EUR 6.7 DBP1000 DBP1999 DBP1005W DBP1013E DBP1015W IN IN IN DBP1019W 165
6. EUR DBP1024W 255 DBP1025W 255 DBP1029W DBP1030W 166
6. EUR DBP1032W HiRDB Oracle DBP1038W LONG VARBINARY LONG VARBINARY DBP1040W DBP1045I 167
6. EUR DBP1046I DBP1048I DBP1049W 1 nnn 1 999 168
6. EUR DBP1050W aa...aa aa...aa aa...aa DBP1055W nnn nnn DBP1056W nnn nnn 1 1 DBP1058W nnn nnn 1 169
6. EUR DBP1082I DBP1083W DBP1084W DBP1085W 170
6. EUR DBP1087W ALIAS ALIAS ALIAS DBP1117W 1 nnn nnn DBP1118W " 171
6. EUR " 256 DBP1119W DBP1120W DBP1123W DBP1124W aa...aa 172
6. EUR DBP1127W LONG VARBINARY EUR LONG VARBINARY EUR EUR Form LONG VARBINARY EUR LONG VARBINARY EUR EUR Form LONG VARBINARY DBP1128W 10,000 10,000 DBP1129W 10,000 DBP1133W 173
6. EUR " " 256 DBP1136I DBP1137W aa...aa DBP1138W DBP1140W nnn mmm 174
6. EUR DBP1141W nnn mmm DBP1143W nnn DBP1144W nnn DBP1151W 175
6. EUR HiRDB Oracle 176
6. EUR 6.8 DBP2000 DBP2999 DBP2001W 350,000 +1 * +1 350,000 DBP2002E nnn mmm nnn mmm DBP2007W 20000 1000 20,000 1,000 20,000 1,000 DBP2008W 20000 20,000 20,000 177
6. EUR DBP2009W 1000 1,000 1,000 DBP2010E nnn mmm CSV nnn mmm TMP TEMP TMP TEMP 1. TMP 2. TMP TEMP 3. TMP TEMP Windows DBP2017E 178
6. EUR 179
6. EUR 6.9 DBP3000 DBP3999 DBP3000W ODBC ODBC SQLState ID SQL ODBC ODBC ODBC ODBC HITACHIDBPARTNER SQLState SQLState 01004 22001 08S01 22003 22008 DATE TIME IM002 IM003 SI090 28000 ID ODBC ID ID S1001 DBL03 180
6. EUR SQLState S1000 SQLState Restricted Datatype attribute violation. Too many number of columns. HITACHIDBPARTNERORACLE ORA-01918 ID MicrosoftODBCDLL SQLState SQLState IM004 SQLState DBP3001E DBP3007E ODBC32.DLL ODBC32.DLL 181
6. EUR EUR Designer EUR Developer DBP3008E DBP3009E " ".* " "," " DBP3600E DBP3601E 182
6. EUR DBP3602E 65,536 DBP3603I DBP3604I DBP3605W 183
6. EUR DBP3606E EDBWDIC.DLL EUR EDBWDIC.DLL 02 EDBWDIC.DLL 08 EDBWDIC.DLL EUR EUR Form EUDBDIC.DLL 02 EUDBDIC.DLL 08 EUDBDIC.DLL 02 EUR Designer EUR Developer 08 DBP3607I DBP3608I 184
6. EUR DBP3609E DBP3610I DBP3611I 185
6. EUR DBP3612I nnn aa aa nnnaa aa DBP3613I nnn nnn DBP3614W 186
6. EUR DBP3701W DBP3702W DBP3703W DBP3704W 187
6. EUR DBP3706W 255 255 255 DBP3904W 188
6. EUR 6.10 DBP6000 DBP6999 DBP6201W OK DBP6202E EUR EUR EUR Form EUR EUR EUR Form DBP6203E EUR EUR EUR Form 189
6. EUR EUR EUR EUR Form DBP6204E LONG VARBINARY EUR LONG VARBINARY EUR EUR Form LONG VARBINARY EUR LONG VARBINARY EUR EUR Form LONG VARBINARY DBP6205W DBP6206W 190
6. EUR DBP6208E SJIS Shift JIS Shift JIS Shift JIS Shift JIS DBP6215W (aa...aa) (bb...bb) (aa...aa) (bb...bb) 191
6. EUR 6.11 DBP8000 DBP8999 DBP8007E Shift JIS Shift JIS 192
7 DABroker DABroker 7.1 7.2 7.3 7.4 KFDB001DB KFDB999DB 7.5 KFDB001EC KFDB999EC 7.6 KFDB001LC KFDB999LC 7.7 KFDB001LM KFDB999LM 7.8 KFDB001MM KFDB999MM 7.9 KFDB001NM KFDB999NM 7.10 KFDB001RC KFDB999RC 7.11 KFDB001RM KFDB999RM 7.12 KFDB001RR KFDB999RR 7.13 KFDB001SC KFDB999SC 7.14 KFDB001SM KFDB999SM 7.15 KFDB001TD KFDB999TD 7.16 KFDB001TM KFDB999TM 7.17 KFDB001TR KFDB999TR 193
7. DABroker 7.18 KFDB001YM KFDB999YM 194
7. DABroker 7.1 DABroker KFDBxxxxx-y 7-1 DABroker KFDBxxxxx-y ID xxxxx y I InformationW WarningE Error Q question 195
7. DABroker 7.2 ID ID 7-2 ID ID ID ID OS error OS OS 196
7. DABroker EUR eurps U R F P D DI DO E 10 C I Information W WarningE Error I InformationW Warning E Error /nomessage UNIX Linux -nomessage /message UNIX Linux -message EUR 0 4 EUR 8 10 12 16 2008 ActiveX 2016 ActiveX 197
7. DABroker 32 198
7. DABroker 7.3 DABroker Windows DABroker spool dabsv.log dabsv.logold 1 DBMS * 79 2 DABroker DABroker DABroker 7-3 DABroker DABroker DABTMP DABSVLOGSIZE DABSELECTCOLCNT DABSELECTINFCNT DABSQL_TRC_CANCEL DABSQL_TRC_CLOSE DABSQL_TRC_COMMIT DABSQL_TRC_CONNECT DABSQL_TRC_DECLARE DABSQL_TRC_DESCRIBE DABSQL_TRC_DISCONNECT [dabsv.log] CANCEL CLOSE COMMIT CONNECT DECLARE DESCRIBE DISCONNECT 199
7. DABroker DABSQL_TRC_EXECUTE DABSQL_TRC_FETCH DABSQL_TRC_PREPARE DABSQL_TRC_ROLLBACK DABSQL_TRC_OPEN DABSQL_TRC_BIND DABSQL_TRC_GETDIAG DABSQL_TRC_AUTO_COMMIT_OFF DABSQL_TRC_AUTO_COMMIT_ON DABSQL_TRC_GET_INFO DABSQL_TRC_SET_INFO DABSQL_TRC_EXECUTE_DIRECT DABCLIENT_TIMEOUT DABMAXUSERS DABDBANUMBER DABMAXBLOCKUSERS DABMAXPROCESS DABORADBA_LONGBUFSIZE DABroker EXECUTE FETCH PREPARE ROLLBACK OPEN BIND GETDIAG AUTO_COMMIT_OFF AUTO_COMMIT_ON GET_INFO SET_INFO EXECUTE_DIRECT 1 LONG (ORACLE) 200
7. DABroker 7.4 KFDB001DB KFDB999DB KFDB001DB-E Required memory cannot be obtained. ErrInfo XXXX XXXX KFDB002DB-E RDBMS ErrInfo XXXX The request sequence for the RDBMS is invalid. ErrInfo[XXXX] XXXX RDBMS RDBMS KFDB003DB-E ErrInfo XXXX() errno=yyyy An error occurred in a system call. ErrInfo[XXXX() errno=yyyy] XXXX YYYY 201
7. DABroker OS OS KFDB004DB-I DBMS DBMS processing was canceled. DBMS DBMS KFDB005DB-E DABroker XXXX A data attribute that is not supported by DABroker was found. [XXXX] XXXX16 XXXX DABroker DABroker KFDB006DB-E DBMS DBMS user DBMS=XXXX system DBMS=YYYY nodename=zzzz 202
7. DABroker The specified DBMS differs from the connected DBMS. user DBMS=XXXX system DBMS=YYYY nodename=zzzz XXXX DBMS YYYY DABroker DBMS ZZZZ RD DBMS DBMS DBMS KFDB007DB-E DABroker DABroker does not support tables containing multivalue columns and array columns. DABroker KFDB011DB-E DBMS nodename=xxxx SQLCODE=YYYY Info=[ZZZZ] An error occurred in the connected DBMS. nodename=xxxx SQLCODE=YYYY Info=[ZZZZ] XXXX RD YYYY DBMS SQL ZZZZ DBMS SQL DBMS 203
7. DABroker DBMS KFDB012DB-E DBMS nodename=xxxx SQLCODE=YYYY IPADDR=ZZZZ An error occurred in the connected DBMS. nodename=xxxx SQLCODE=YYYY IPADDR=ZZZZ XXXX RD YYYY DBMS SQL ZZZZ IP DBMS DBMS KFDB013DB-E DBMS 32 The permission identifier, password or DBMS information specified by the user exceeded 32 bytes. DBMS 32 DBMS KFDB017DB-E ErrInfo XXXX The specified table attribute is incorrect. ErrInfo[XXXX] 204
7. DABroker XXXX 1 ` 2 3 KFDB018DB-E ErrInfo XXXX YYYY ZZZZ The specified input parameter is incorrect. ErrInfo XXXX YYYY ZZZZ XXXX YYYY ZZZZ KFDB019DB-E ErrInfo XXXX YYYY The specified output parameter is incorrect. ErrInfo[XXXX, YYYY] XXXX YYYY 205
7. DABroker KFDB020DB-E DBMS ErrInfo XXXX Incorrect version of the DBMS. ErrInfo[XXXX] XXXX DBMS DBMS KFDB021DB-E SQL ErrInfo XXXX YYYY The specified multiple SQL execution is incorrect. ErrInfo[XXXX,YYYY] XXXX SQL YYYY SQL SQL KFDB024DB-E DBMS NULL XXXX You cannot specify NULL in the? parameter because of a limit of the connected DBMS. [XXXX] XXXX NULL 206
7. DABroker NULL KFDB025DB-E HiRDB ORACLE =XXXX Not prepared to connect to HiRDB or ORACLE. Error code=xxxx XXXX DBMS ORACLE OCI -1 xaoenv -2 xaosvcctx -3 OCIHandleAlloc -4 OCISvcCtxToLda 1. OTS 2. HiRDB TPBroker(OTS) 3. DABroker for C++ UAP DBRDatabase Connect lpctdbn xa_open DB 1. OTS DABroker OTS 2. TPBroker HiRDB TPBroker HiRDB TPBroker HiRDB 3. DABroker for C++ UAP DBRDatabase Connect lpctdbn xa_open DB 207
7. DABroker KFDB026DB-E ORACLE OCI =XXXX =YYYY The error occurred by the OCI function of ORACLE. Function name=xxxx return code=yyyy XXXX OCI YYYY OCI OCI XXXX Oracle KFDB030DB-E ODBC DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in an ODBC access. DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ WWWW XXXX SQL DABroker YYYY SQLSTATE ZZZZ ODBC DBMS KFDB031DB-E ODBC SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in an ODBC access. 208
7. DABroker SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ XXXX SQL DABroker YYYY SQLSTATE ZZZZ ODBC DBMS KFDB032DB-E ODBC ErrInfo=XXXX A request parameter is invalid for ODBC access. ErrInfo=XXXX XXXX ODBC KFDB040DB-E DABroker ODBC DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in a DABroker ODBC access. DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ WWWW XXXX SQL DABroker YYYY SQLSTATE ZZZZ 209
7. DABroker DABroker ODBC DBMS KFDB041DB-E DABroker ODBC SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in a DABroker ODBC access. SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ XXXX SQL DABroker YYYY SQLSTATE ZZZZ DABroker ODBC DBMS KFDB042DB-E DABroker ODBC ErrInfo=XXXX A request parameter is invalid for DABroker ODBC access. ErrInfo=XXXX XXXX DABroker ODBC 210
7. DABroker KFDB043DB-E ODBC Driver [XXXX] DABroker does not support the ODBC Driver version.[xxxx] XXXX:ODBC Driver ODBC Driver ODBC Driver KFDB044DB-E DBMS [XXXX] DABroker does not support the DBMS. [XXXX] XXXX DBMS DBMS KFDB045DB-E DBMS DBMS user DBMS=XXXX system DBMS=YYYY The specified DBMS differs from the connected DBMS. user DBMS=XXXX system DBMS=YYYY XXXX DBMS YYYY DABroker DBMS 211
7. DABroker DBMS DBMS DBMS KFDB051DB-E [XXXX,YYYY] DABroker does not support the connected server system. [XXXX,YYYY] XXXX YYYY DBMS KFDB052DB-E [XXXX] A system error occurred in the connected server system. [XXXX] XXXX DBMS KFDB053DB-E DABroker DBMS [XXXX] A system error occurred in the DABroker DBMS driver. [XXXX] 212
7. DABroker XXXX DBMS DBMS KFDB054DB-E Processing was canceled because a timeover occurred. DABDBA_TIMEOUT KFDB070DB-E [XXXX] There is a data type which is different in element of arrangement.[xxxx] XXXX HiRDB 213
7. DABroker KFDB071DB-E [XXXX] The size of data is over the effective range of character data.[xxxx] XXXX KFDB101DB-E Memory is insufficient for processing. 214
7. DABroker 7.5 KFDB001EC KFDB999EC KFDB002EC-E DABroker DABroker is not running. DABroker KFDB008EC-E DABroker The user does not have authorization to stop DABroker. DABroker Administrators DABroker Administrators KFDB012EC-E DABroker DABroker is starting. DABroker 215
7. DABroker KFDB013EC-E DABroker DABroker is terminating. DABroker KFDB014EC-E DABroker DABroker is terminating in the planned termination mode. DABroker KFDB015EC-E DABroker DABroker is terminating in the forced termination mode. DABroker KFDB016EC-E DABroker cannot terminate because of current processing. DABroker DABroker 216
7. DABroker 1 2 3 1 DABroker 2 DABroker 3 DABroker KFDB017EC-E The specified client processing was not found. 1 1 DABroker 2 2 DABroker 217
7. DABroker 7.6 KFDB001LC KFDB999LC KFDB003LC-E Memory became insufficient during execution of a utility program. KFDB005LC-E IP Communication information with the specified IP address or host name cannot be traced. IP IP 218
7. DABroker 7.7 KFDB001LM KFDB999LM KFDB001LM-E XXXX()error=YYYY An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS 219
7. DABroker 7.8 KFDB001MM KFDB999MM KFDB001MM-E XXXX The DABroker environment definition file was not found. [XXXX] XXXX DABroker DABroker DABroker conf DABroker DABroker KFDB002MM-E XXXX The environment definition is incorrect. [XXXX] XXXX DABroker DABroker 220
7. DABroker KFDB003MM-E LINE=XXXX YYYY The environment definition is incorrect. LINE=XXXX [YYYY] XXXX YYYY DABroker DABroker DABroker KFDB004MM-E DABroker is not installed. DABroker DABroker DABroker KFDB005MM-E XXXX errno=yyyy An error occurred in a system call. [XXXX errno=yyyy] XXXX YYYY XXXX 221
7. DABroker OS KFDB006MM-E System call error occured. [XXXX errno=yyyy] XXXX YYYY XXXX OS KFDB009MM-E XXXX Required memory cannot be obtained. XXXX XXXX DABroker DABroker KFDB011MM-E XXXX The user does not have authority to access the environment definition file. [XXXX] XXXX DABroker 222
7. DABroker DABroker DABroker KFDB019MM-E XXXX The directory was not found. DABroker will use the default directory. [XXXX] XXXX DABroker DABroker DABroker KFDB020MM-E XXXX The directory was not found. [XXXX] XXXX 223
7. DABroker DABroker DABroker 224
7. DABroker 7.9 KFDB001NM KFDB999NM KFDB001NM-E XXXXYYYY An error occurred in a system call. (Error function:xxxx, error code:yyyy) XXXX YYYY GetLastError Windows KFDB002NM-E DABroker DABroker ( XXXX YYYY An abnormality occurred during DABroker processing. DABroker terminates. (File name:xxxx, Line number:yyyy) XXXX YYYY DABroker KFDB003NM-E DABroker 225
7. DABroker Memory became insufficient during DABroker processing. DABroker KFDB004NM-E DABroker The environment is incorrect. Re-install DABroker. DABroker DABroker DABroker KFDB005NM-E DABroker An error occurred during DABroker initialization processing. DABroker 226
7. DABroker dabsv.log KFDB101NM-E XXXX YYYY An error occurred during service controlled processing. (Error code 1:XXXX, error code 2:YYYY) XXXX YYYY GetLastError Windows DABroker KFDB102NM-E Memory became insufficient during service controlled processing. DABroker 227
7. DABroker KFDB103NM-I DABroker DABroker service has started. DABroker DABroker DABroker KFDB104NM-Q DABroker Do you want to terminate the DABroker service? DABroker DABroker DABroker KFDB105NM-E DABroker XXXX DABroker cannot start because a DABroker service parameter is invalid. (Error code:xxxx) XXXX GetLastError DABroker DABroker DABroker 228
7. DABroker KFDB201NM-E The directory is invalid. KFDB202NM-E The entered numerical data is outside the range. KFDB203NM-Q IP XXXXYYYY The client processing was canceled. IP address:xxxx host name:yyyy XXXX IP YYYY 229
7. DABroker KFDB204NM-E XXXX The registry name XXXX is too long. XXXX XXXX 1,024 XXXX 1,024 KFDB205NM-E XXXX DABroker DABroker found a non-supported data type in the registry name XXXX. XXXX XXXX DABroker KFDB206NM-E XXXX YYYYZZZZ 230
7. DABroker DABroker failed to get the value of registry name XXXX. (Error function:yyyy, error code:zzzz) XXXX YYYY ZZZZ GetLastError DABroker DABroker Windows DABroker DABroker KFDB207NM-E XXXX YYYYZZZZ DABroker failed to update the value of registry name XXXX. (Error function:yyyy, error code:zzzz) XXXX YYYY ZZZZ GetLastError DABroker DABroker Windows DABroker 231
7. DABroker DABroker KFDB211NM-E DABroker An environment definition cannot be updated because DABroker is running. DABroker DABroker DABroker KFDB213NM-E The user does not have authority to execute the environment setting utility. Administrators Administrators KFDB214NM-E The type of information to be acquired is not specified. 232
7. DABroker KFDB215NM-E DABroker Cannot update because DABroker is running. DABroker DABroker DABroker KFDB216NM-W DABroker Cannot update because DABroker is running. DABroker DABroker DABroker KFDB250NM-I The trace has been output. 233
7. DABroker KFDB251NM-I The trace to be output was not found. 1 KFDB252NM-E An error occurred during output processing for the communication-trace. KFDB253NM-E An error occurred during output processing for the access-trace. 234
7. DABroker 235
7. DABroker 7.10 KFDB001RC KFDB999RC KFDB003RC-E Memory became insufficient during execution of a utility program. 236
7. DABroker 7.11 KFDB001RM KFDB999RM KFDB001RM-E XXXX()error=YYYY An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS 237
7. DABroker 7.12 KFDB001RR KFDB999RR KFDB001RR-E ID The access-trace for the database that has the specified user ID could not be found. ID ID KFDB002RR-E The access-trace for the database that has the specified program name could not be found. KFDB003RR-E ID The access-trace for the database that has the specified user ID or program name could not be found. ID 238
7. DABroker ID 239
7. DABroker 7.13 KFDB001SC KFDB999SC KFDB002SC-E DABroker DABroker is not running. DABroker DABroker KFDB005SC-I DABroker DABroker is terminating in the planned termination mode. DABroker DABroker DABroker KFDB007SC-E DABroker DABroker is starting. DABroker DABroker 240
7. DABroker KFDB008SC-E DABroker DABroker is terminating. DABroker DABroker KFDB009SC-E DABroker DABroker is terminating in the forced termination mode. DABroker DABroker 241
7. DABroker 7.14 KFDB001SM KFDB999SM KFDB001SM-E XXXX()errno=YYYY An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS KFDB002SM-E shmget()errno=xxxx Shared memory cannot be obtained. [shmget() errno=xxxx] XXXX OS shmget KFDB003SM-E shmctl()errno=xxxx Shared memory cannot be deleted. [shmctl() errno=xxxx] XXXX 242
7. DABroker OS shmctl KFDB004SM-E semget()errno=xxxx The semaphore cannot be obtained. [semget() errno=xxxx] XXXX OS semget KFDB005SM-E semctl()errno=xxxx The semaphore cannot be deleted. [semctl() errno=xxxx] XXXX OS semctl KFDB006SM-E Memory is insufficient during execution of a utility program. 243
7. DABroker 244
7. DABroker 7.15 KFDB001TD KFDB999TD KFDB001TD-E [XXXX errno=yyyy] An error occurred in a system call. [XXXX errno=yyyy] XXXX YYYY XXXX OS KFDB002TD-E Memory is insufficient. KFDB003TD-E CursorId=XXXX The specified cursor is being used, or it is not initialized. [CursorId=XXXX] XXXX 245
7. DABroker KFDB004TD-E CursorId=XXXX The cursor value is invalid. [CursorId=XXXX] XXXX 1 64 KFDB005TD-E ErrorCode=XXXX Invalid data was received. [ErrorCode=XXXX] XXXX DABroker KFDB006TD-E XXXX 246
7. DABroker The required parameter was not found, or the parameter value is invalid. [XXXX] XXXX USER ID ID RD NODE NAME RD TABLE TYPE ABSTRACT KIND ABSTRACT NAME DATASOURCE ODBC3.0 KFDB007TD-E RequestCode=XXXX DABroker does not support the specified function. [RequestCode=XXXX] XXXX DABroker B.2 DABroker KFDB008TD-E ErrorCode=XXXX An error occurred in the system. [ErrorCode=XXXX] XXXX 247
7. DABroker DABroker KFDB009TD-E ResponseSize=XXXX The request size of reply data is invalid. [ResponseSize=XXXX] XXXX KFDB010TD-E [RequestCode=XXXX-YYYY] A sequence error of the request code occurred. [RequestCode=XXXX-YYYY] XXXX YYYY B.2 DABroker 248
7. DABroker KFDB011TD-E DABroker does not support the specified database. KFDB012TD-E SQL The specified SQL is incorrect. SQL : SQL KFDB013TD-E ErrorCode=XXXX An error occurred in the database access library. [ErrorCode=XXXX] XXXX 249
7. DABroker B.1 DABroker KFDB015TD-E Processing was canceled because a timeover occurred. KFDB016TD-E ErrorCode=XXXX A database access error occurred. [ErrorCode=XXXX] XXXX DBMS DBMS KFDB030TD-W Processing was canceled. 250
7. DABroker KFDB031TD-W Processing cannot be canceled because it has already ended KFDB032TD-E (DataType=XXXX) A data type that the client does not support was found. (DataType=XXXX) XXXX DABroker KFDB033TD-E Not connected to the database. 251
7. DABroker KFDB034TD-E XXXX The user does not have authorization to delete the specified file. File:XXXX XXXX KFDB035TD-E XXXX The specified file was not found. File:XXXX XXXX KFDB036TD-E XXXX unlinkerrno YYYY DABroker failed to delete the specified file. File:XXXX [unlink() errno=yyyy] XXXX YYYY unlink() 252
7. DABroker unlink() KFDB037TD-E XXXX The area for sending information to the client was insufficient. Cause=XXXX XXXX EXT-CMD <Prepare> EXT-CMD <Fetch> 1 4 PROCEDURE PREPARE PROCEDURE EXECUTE PROCEDURE-PARAMETER 253
7. DABroker PROCEDURE-RESULT EXT-CMD <EXECUTE> 52 4 KFDB049TD-E ErrInfo[XXXX] Memory is insufficient during data processing. ErrInfo[XXXX] XXXX 254
7. DABroker 7.16 KFDB001TM KFDB999TM KFDB001TM-E services DABroker (DABROKER_SV) The services name and port number(dabroker_sv) of DABroker are not listed in the "services" file. services DABroker services DABROKER_SV 40179/tcp NIS NIS KFDB002TM-E socket() errno=xxxx The socket cannot be opened. [socket() errno=xxxx] XXXX OS socket 255
7. DABroker KFDB003TM-E bind() errno=xxxx The address cannot be allocated to the socket. [bind() errno=xxxx] XXXX OS bind DABroker LAN DABroker KFDB004TM-E listen() errno=xxxx An error occurred when a requested connection was accepted. [listen() errno=xxxx] XXXX OS listen KFDB005TM-E accept() errno=xxxx An error occurred when a connection was established. [accept() errno=xxxx] XXXX OS accept 256
7. DABroker KFDB006TM-I XXXX A connection is established. [XXXX] XXXX IP KFDB007TM-I XXXX A connection is released. [XXXX] XXXX IP KFDB008TM-E Incorrect version of the client program. 257
7. DABroker KFDB009TM-E IPADDR=XXXX Cannot connect the database because of insufficient memory. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker KFDB010TM-E =XXXX IPADDR=YYYY Invalid data was received. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB011TM-E =XXXX IPADDR=YYYY An error occurred during communication processing. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY 258
7. DABroker KFDB012TM-E =XXXX IPADDR=YYYY A sequence error occurred during sending or receiving of data. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB013TM-E DABroker IPADDR=XXXX The processing request cannot be accepted because DABroker is terminating in the planned termination mode. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker DABroker DABroker DABroker 259
7. DABroker KFDB014TM-I TCP/IP XXXXIPADDR=YYYY The TCP/IP communication thread is terminated. Cause:[XXXX] IPADDR=YYYY XXXX CANCEL_REQUEST TERM_REQUEST YYYY IP IPADDR=XXXX 1 2 TCP/IP 1 DABroker 2 DABroker KFDB016TM-E IPADDR=XXXX A timeout occurred during the wait for the request from the client. DABroker releases the connection. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker DABCLIENT_TIMEOUT 260
7. DABroker DABCLIENT_TIMEOUT KFDB017TM-E IPADDR=XXXX A timeout occurred during the wait for termination of the database access. DABroker releases the connection. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker DABDBA_TIMEOUT DABDBA_TIMEOUT KFDB018TM-E IPADDR=XXXX The connection was forcibly released. IPADDR=XXXX XXXX IP IPADDR=XXXX 261
7. DABroker KFDB019TM-E IPADDR=XXXX The connection was forcibly released. IPADDR=XXXX XXXX IP IPADDR=XXXX TCP/IP 1. 2. KFDB020TM-E =XXXX IPADDR=YYYY The database access process terminated abnormally. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB021TM-E TCP/IP [XXXX] 262
7. DABroker The TCP/IP communication process terminated. Cause:[XXXX] XXXX TCP/IP kill KFDB022TM-W XXXXIPADDR=YYYY The cancel processing request cannot be accepted. [XXXX] IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY DABroker KFDB023TM-E DBMS XXXX=YYYY IPADDR=ZZZZ The specified DBMS environment variable is incorrect. [XXXX] IPADDR=YYYY XXXX YYYY ZZZZ IP IPADDR=ZZZZ 263
7. DABroker DBMS 264
7. DABroker 7.17 KFDB001TR KFDB999TR KFDB001TR-E Memory became insufficient during collection of a trace of communication with a client. KFDB002TR-E Disk space became insufficient during collection of a trace of communication with a client. KFDB003TR-E XXXX()errno=YYYY An error occurred in a system call during collection of a trace of communication with a client. [XXXX() errno=yyyy] XXXX YYYY 265
7. DABroker OS DABroker 266
7. DABroker 7.18 KFDB001YM KFDB999YM KFDB003YM-I DABroker DABroker initialization processing has finished. DABroker DABroker DABroker DABroker KFDB004YM-I DABroker mode=normal DABroker termination processing has started. mode=normal DABroker DABroker DABroker DABroker KFDB005YM-I DABroker mode=forced DABroker termination processing has started. mode=forced DABroker DABroker DABroker 267
7. DABroker KFDB006YM-I DABroker mode=planned DABroker termination processing has started. mode=planned DABroker DABroker DABroker DABroker KFDB007YM-E DABroker DABroker is terminating in the planned termination mode. A client cannot be connected. DABroker DABroker DABroker DABroker DABroker KFDB008YM-E DABMAXUSERS=XXX The number of clients exceeds the maximum that can be connected. A client cannot be connected. [DABMAXUSERS=XXXX] XXX 268
7. DABroker DABroker DABMAXUSERS DABroker DABroker DABMAXUSERS KFDB009YM-E DABroker DABroker is already running. DABroker DABroker DABroker DABroker DABroker KFDB010YM-E DABroker [XXXX] The user does not have authority to execute the load module of DABroker. Name:[XXXX] XXXX DABroker 269
7. DABroker DABroker KFDB011YM-E DABroker [XXXX] DABroker cannot start because there are too many symbolic links. Name:[XXXX] XXXX DABroker DBMS DBMS DABroker KFDB012YM-E DABroker [XXXX] A load module of DABroker was not found. Name:[XXXX] XXXX DABroker DABroker 270
7. DABroker KFDB013YM-E DABroker [XXXX] DABroker cannot start because of insufficient memory. Name:[XXXX] XXXX DABroker KFDB014YM-E DABroker The user does not have authority to execute DABroker. DABroker DABroker Administrators DABroker DABroker DABroker KFDB015YM-E TCP/IP XXXX The TCP/IP communication process terminated abnormally. Cause:[XXXX] XXXX TCP/IP 271
7. DABroker kill KFDB016YM-E DABroker [XXXX] DABroker terminated abnormally. Cause:[XXXX] XXXX kill DABroker DABroker DABroker DABroker spool KFDB019YM-E [DABMAXPROCESS=XXXX] The number of users exceeds the maximum that can be executed. A client cannot be connected. [DABMAXPROCESS=XXXX] XXXX DABroker DABroker DABMAXPROCESS 272
7. DABroker DABroker DABroker DABMAXPROCESS KFDB020YM-E DABroker DABroker cannot start. DABroker DABroker DABroker KFDB021YM-E DABDBANUMBER=XXX The number of database accesses exceeds the maximum that can be executed. Database access is not possible. [DABDBANUMBER=XXXX] XXX DABroker DABDBANUMBER DABroker DABDBANUMBER KFDB022YM-I DABroker 273
7. DABroker DABroker has terminated. DABroker KFDB023YM-E TCP/IP The TCP/IP communication process cannot start. TCP/IP DABroker DABroker KFDB100YM-E XXXX() errno=yyyy An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS DABroker KFDB101YM-E Required memory cannot be obtained. 274
7. DABroker DABroker DABroker KFDB301YM-I Clean up. {xxx,yyy,zzz}, {sss} xxx yyy zzz sss DABroker 0 1 2 3 KFDB302YM-I dabtcpdmn {xxx} start. [yyyy] 275
7. DABroker xxx dabtcpdmn yyyy ID KFDB303YM-I dabtcpdmn end. [xxxx] yyyy ID KFDB310YM-I Thread stack size = xxxx yyyy xxxx xxx yyyy DABPTHREAD_STACK_SIZE is undefined. DABPTHREAD_STACK_SIZE DABPTHREAD_STACK_SIZE=aaa aaa DABPTHREAD_STACK_SIZE 55 276
A DABroker B DABroker C 277
A DABroker A DABroker EUR DABroker DABroker EUR Developer Windows EUR Server EUR Server Print Edition EUR Server Standard EUR Server Enterprise DABroker A.1 DABroker DABroker EUR EUR DABroker DABroker EUR DABroker DABroker DABroker DABroker 1 DABroker DABroker a DABroker DABroker EUR EUR EUR DABroker 278
A DABroker b Windows Administrators c DABroker DABroker 1. DABroker 2. DABrokerDABroker DABroker DABroker A-1DABroker DABroker DABroker IP EUR IP EUR EUR EUR EUR 279
A DABroker EUR IP hosts Windows SYSTEM32 DRIVERS ETC 3. DABroker DABroker DABroker d EUR EUR 1. DABroker 2. DABrokerDABroker DABroker DABroker 3. DABroker EUR 4. DABroker 2 DABroker DABroker a DABroker 2 DABroker EUR DABroker DABroker DABroker spool dabcltrc 280
A DABroker DABroker DABroker DABroker spool db_access b DABroker c 1. DABroker DABroker DABroker A-2DABroker 1. 2. IP IP IP IP IP 3. DABroker spool DABTT.TXT 281
A DABroker 1. 2. UAP ID UAP ID ID ID ID UAP 3. DABroker spool DABDT.TXT 2. 2 d IPADDR=xx.xx.1.10 PROT=TCP PAP-NAME=DBPARTNER2 Runtime 00000a0c DATE TIME EVT SIZE DATA 2008/09/02 15:23:28.98 PUT 164 Connection(0,0) 2008/09/02 15:23:28.98 GET 148 Connect(Database) 2008/09/02 15:23:29.18 PUT 64 Result(0,0) 2008/09/02 15:23:29.18 GET 187 EXT-CMD <Prepare> 2008/09/02 15:23:29.18 PUT 461 Result(0,0) IPADDR=XXXXXXXX EUR IP PROT=XXX TCP TCP/IP PAP-NAME=XXXXXX UAP DBPODBC IP DBPARTNER2 Runtime ID DATE 282
A DABroker TIME : :.n n 100 1 EVT DABroker PUT EUR GET EUR SIZE DATA aa aa <bb bb> cc cc,dd dd aa aa bb bb LIST xxxxx EXT-CMD cc cc dd dd A-1 Connect Database Disconnect Database Disconnect Connection Commit Rollback LIST Table LIST Column LIST Index LIST Table Privileges LIST Column Privileges EXT-CMD SQL Fetch Option File Delete Save SQL SQL SQL 283
A DABroker Cancel Illegal Request Connection Result Error Result Cancel Error Cancel 80+ * 2 PUT GET * 36 PUT GET UID=EUR PAPNAME=DBPARTNER2 Runtime 00000a0c DBNAME=HiRDB DATE TIME EVT RETCODE INFORMATION 2008/09/02 15:23:28.98 CONNECT 2008/09/02 15:23:29.18 CONNECT 0 2008/09/02 15:23:29.18 PREPARE (SQL) SELECT " "," ","","","",""," "," ","" FROM "EUR"."ZAIKO" 2008/09/02 15:23:29.18 PREPARE 0 2008/09/02 15:23:29.18 DESCRIBE 2008/09/02 15:23:29.18 DESCRIBE 0 2008/09/02 15:23:29.18 DESCRIBE 2008/09/02 15:23:29.18 DESCRIBE 0 2008/09/02 15:23:29.18 DESCRIBE 2008/09/02 15:23:29.18 DESCRIBE 0 2008/09/02 15:23:29.19 OPEN 2008/09/02 15:23:29.19 OPEN 0 2008/09/02 15:23:29.19 FETCH BLOCK COUNT(1) 2008/09/02 15:23:29.19 FETCH 0 BLOCK COUNT(1) UID=XXXXXXXX ID PAPNAME=XXXXXXX UAP DBPODBC IP DBPARTNER2 Runtime ID DBNAME=XXXXXXX 284
A DABroker HiRDB HiRDB Oracle7 Oracle Oracle ODBC3.0 Microsoft SQL Server DATE TIME : :.n n 100 1 EVT DABroker EVT A-2 EVT DABroker EVT CONNECT PREPARE DESCRIBE DECLARE OPEN FETCH CLOSE EXECUTE COMMIT ROLLBACK DISCONNECT CANCEL LOGGING LOGLESS SQL SQL SELECT SQL HiRDB HiRDB RETCODE DABroker 285
A DABroker 0 0 DABroker RETCODE INFORMATION FETCH SQL SQL Microsoft SQL Server EVT PREPARE A-3SQL (SQL) ODBC:{SQLTables} (SQL) ODBC:{SQLColumns } (SQL) ODBC:{SQLTablePrivileges} (SQL) ODBC:{SQLColumnPrivileges} (SQL) ODBC:{SQLStatistics} (SQL) ODBC:{SQLPrimaryKeys} SQL 1 80 SQL {( SQL * 2) + 2 [ + ( SQL /73) -1] } * 80 SQL 73 3 286
A DABroker a 24 DABroker DABroker DABroker 2 b DABroker DABroker DABroker c *-------------------------------------------------------* *- DataBase Access Information (DRV) -* *- Date YYYY/MM/DD hh:mm:ss.nnnnnn -* *-------------------------------------------------------* DABroker Connect ID : AAAAA(BBBBB) Process ID : CCCCC UserID : DDDDD Client Name : EEEEE (DB ) Lang Mode : GGGGG THREAD-ID CID EVT START-TIME END-TIME RETCODE BLOCKCNT (SQL) DRV DABroker 287
A DABroker A-4 HiRDB Oracle Microsoft SQL Server HiRDB Driver ORACLE7 Driver ODBC30 Date YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn DABroker Connect ID Process ID ID UserID ID Client Name UAP DBPODBC IP DBPARTNER2 Runtime ID (DB ) A-5 HiRDB PDHOST: HiRDB PDHOST "Not Indicator" 288
A DABroker PDNAMEPORT: HiRDB PDNAMEPORT "Not Indicator" Oracle SQLNET: Oracle "Not Indicator" Microsoft SQL Server ODBC Dara Sourcs: ODBC "Not Indicator" ODBC Key Word: ODBC "Not Indicator" Lang Mode THREAD-ID ID CID EVT DABroker OFF EVT ON GET_DIAG A-6 EVT EVT DESC_OUT DESC_IN GET_DIAG BIND DEFINE DESALLOC DESFREE ERRGET HDLALLOC SQL SQL 289
A DABroker HEDLFREE EVT START-TIME YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn END-TIME YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn RETCODE BLOCKCNT FETCH (SQL) SQL d DABroker spool db_access 290
A DABroker spdb_xxxxxxxx_yyyyyyyy_****zzzzz.iiiiii XXXXXXXX ID 1 YYYYYYYY **** 2 ZZZZZ IIIIII log logold 1 1 ID 00000 32767 2 A-7 HiRDB Oracle Microsoft SQL Server HiRDB Driver ORACLE7 Driver ODBC30 DABroker 1 4 DABroker DABroker DABroker 291
A DABroker a DABroker b DABroker c DABroker DABroker 1. DABroker DABroker A-3 DABroker 292
B DABroker B DABroker DABroker B.1 DABroker DABroker B-1 DABroker -12001-16002 DBMS -16004 DABroker DABroker DBMS DABroker DABroker B.2 DABroker DABroker B-2 DABroker / 1001 1002 1003 1004 Commit 1005 Rollback 1006 1007 293
B DABroker / 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 SQL 1022 SQL 1023 SQL 1024 SQL 1035 SQL 1037 1038 1039 1041 Commit 1042 Commit 2001 2002 294
C C C.1 1 EUR EUR 3020-7-532 EUR ucosminexus EUR 3020-7-702 EUR ucosminexus EUR 3020-7-703 EUR ucosminexus EUR 3020-7-533 EUR ucosminexus EUR 3020-7-705 EUR ucosminexus EUR EUR Form 3020-7-534 EUR Form EUR Form ucosminexus EUR 3020-7-535 EUR ucosminexus EUR EUR Server 3020-7-708 EUR ucosminexus EUR EUR Server 3020-7-710 EUR API ucosminexus EUR 3020-7-536 EUR Server V8 ucosminexus EUR 3020-7-714 EUR ucosminexus EUR 3020-7-715 295
C EUR Windows 8 9 2 TPBroker 3000-3-660 TPBroker Developer's Kit - Extension for C++ 3000-3-680 TPBroker Object Transaction Monitor 3000-3-689 COBOL2002 3000-3-D42 COBOL2002 3000-3-D43 COBOL2002 3020-3-D47 COBOL20023020-3-D48 SEWB+/REPOSITORY 3020-3-698 SEWB+/REPOSITORY 3020-3-N82 DBPARTNER2 Client 3020-6-027 DABroker 3020-6-031 HiRDB Version 8 UAP 3020-6-356 HiRDB Version 8 3020-6-358 HiRDB Version 9 UAP 3020-6-456 HiRDB Version 9 3020-6-458 3 ucosminexus EUR ucosminexus EUR ucosminexus EUR ucosminexus EUR EUR Server ucosminexus EUR EUR Server ucosminexus EUR ucosminexus EUR ucosminexus EUR EUR EUR EUR EUR EUR Server EUR EUR Server EUR EUR EUR 296
C ucosminexus EUR ucosminexus EUR EUR Form ucosminexus EUR ucosminexus EUR HiRDB Version 8 UAP HiRDB Version 9 UAP HiRDB Version 8 HiRDB Version 9 EUR EUR EUR Form EUR EUR HiRDB UAP HiRDB C.2 EUR 9 EUR 9 297
C 298
C C.3 EUR 9 EUR 9 EUR 8 EUR 9 EUR EUR EUR EUR EUR Print Manager EUR EUR EUR EUR Print Manager EUR 5 EUR EUR Print Manager API EUR 7 EUR Print Manager 8 15 EUR EUR EUR EUR EUR EUR Print Manager EUR A EUR Print Manager H EUR EUR EUR EUR EUR Server EUR EUR Server EUR EUR EUR C.4 ucosminexus EUR 299
C EUR Client EUR Designer EUR Developer EUR Viewer ucosminexus EUR Client ucosminexus EUR Designer ucosminexus EUR Developer ucosminexus EUR Viewer EUR Server EUR Server Enterprise ucosminexus EUR Server Enterprise EUR Server - Cipher option EUR Server Standard EUR Server Print Edition ucosminexus EUR Server Standard ucosminexus EUR Server Print Edition ucosminexus EUR Server - Cipher option EUR Form EUR Form Service ucosminexus EUR Form Service EUR Form Service - Data Store option ucosminexus EUR Form Service - Data Store option ucosminexus EUR COBOL DABroker HiRDB IPF COBOL2002 DABroker 03-17 DABroker 03-21 DABroker(64) 03-20 DABroker(64) 03-21 HiRDB/Run Time Version 8 08-00 HiRDB/Developer's Kit Version 8 08-00 HiRDB/Run Time Version 8(64) 08-00 HiRDB/Developer's Kit Version 8(64) 08-00 HiRDB/Run Time Version 9 09-00 HiRDB/Developer's Kit Version 9 09-00 HiRDB/Developer's Suite Version 9 09-00 HiRDB/Run Time Version 9(64) 09-00 HiRDB/Developer's Kit Version 9(64) 09-00 HiRDB Server Version 9 09-00 HiRDB Server with Additional Function Version 9 09-00 Itanium(R) Processor Family Linux Linux(R) Red Hat Enterprise Linux Server 6 (64-bit x86_64) 300
C Oracle Oracle 10g Oracle 10g 10.1.0 Oracle 10g 10.2.0 Oracle 11g Oracle Database 11g 11.1.0 Oracle Database 11g R2 11.2.0 SEWB+ ucosminexus Application Server Software Engineering Workbench+ ucosminexus Application Server Enterprise UNIX AIX AIX V6.1 AIX V7.1 ucosminexus Application Server Standard HP-UX HP-UX 11i V3(IPF) EUR EUR EUR Designer EUR Developer EUR EUR Developer EUR Form EUR EUR Form EUR Designer EUR Developer EUR Viewer EUR EUR Developer EUR Server Enterprise EUR Server Standard EUR Server Print Edition EUR C.5 API ASP BOM COBOL CPI CSV DLL DPI Application Programming Interface Active Server Pages Byte Order Mark COmmon Business Oriented Language Characters Per Inch Comma Separated Value Dynamic Linking Library Dot Per Inch 301
C EJB EMF EOF EUR GIF GUI HTTP ID IPF ISO JDK JIS JPEG JSP LAN LIPS LPI MFC MIME MSI MUI OCR OCX ODBC OLE PCF PDF PDL RPM TIFF UAP WAN XML Enterprise JavaBeans Enhanced Metafile End Of File End-User Reporting Graphics Interchange Format Graphical User Interface Hyper Text Transfer Protocol IDentifier Itanium(R) Processor Family International Organization for Standardization Java TM Development Kit Japanese Industrial Standards Joint Photographic Experts Group Java Server Pages Local Area Network LBP Image Processing System Lines Per Inch Microsoft Foundation Class Multipurpose Internet Mail Extension Microsoft Windows Installer Multi User Interface Optical Character Reader OLE Custom Control (OLE Control extension) Open Database Connectivity Object Linking and Embedding Portable Compiled Format Portable Document Format Page Description Language RPM Package Manager Tagged Image File Format User Application Program Wide Area Network extensible Mark-up Language 302
C C.6 KB 1KB1MB1GB1TB 1,024 1,024 2 1,024 3 1,024 4 303
B BETWEEN 61 [BETWEEN ] 118 D DABroker 278 DABroker 278 DABroker 278 DABroker 29 DABroker 278 DABroker 278 DBPARTNER ODBC Driver 10 E EUR ODBC Driver 10 [EUR ODBC Driver - -] 140 [EUR ODBC Driver - -] 138 EUR 6 H HiRDB 84 I IN 61 [IN ] 116 L LIKE 60 N NULL 60 O ODBC Driver 10 ODBC 32 Oracle 84 S SQL 41 SQL Server 84 W WHERE 62 280 45 [ ] 131 278 [ ] 130 54 [ ] 109 86 86 86 87 [ ] 123 305
29 51 63 [ ] 129 [ ] 137 [ ] 135 [ ] 106 49 85 [ ] 121 [ ] 111 55 43 84 82 82 82 84 6 [ ] 108 52 69 65 280 67 41 95 BETWEEN 61 EUR 6 IN 61 LIKE 60 NULL 60 WHERE 62 45 54 51 63 49 55 52 69 65 67 41 40 38 14 12 EUR 68 59 45 47 47 47 42 45 80 306
72 76 71 74 61 47 48 6 91 41 40 38 38 14 12 EUR 7 EUR 68 84 84 84 32 80 72 76 71 74 [ ] 127 [ ] 124 [ ] 126 61 [ ] 119 [ ] 103 45 50 57 47 48 59 46 [ ] 100 45 [ ] 115 47 47 47 [ ] 98 44 [ ] 101 42 45 307