untitled

FORCS Co., LTD 1

OZ Query Designer User's Guide 2 FORCS Co., LTD

FORCS Co., LTD 3

OZ Query Designer User's Guide 4 FORCS Co., LTD

FORCS Co., LTD 5

OZ Query Designer User's Guide UI. (ODI)., ODI. 6 FORCS Co., LTD

...,.. /HTTP XML, CSV HTTP. FORCS Co., LTD 7

OZ Query Designer User's Guide XML XML-DTD XML-XSD. SAP SAP..... 8 FORCS Co., LTD

,. Getting Started Getting Started.......... FORCS Co., LTD 9

OZ Query Designer User's Guide 10 FORCS Co., LTD

FORCS Co., LTD 11

OZ Query Designer User's Guide OS Windows NT(Service pack4 )/2000(Service pack2 )/XP/2003 Windows 95/98/ME Unicode. CPU Pentium 500MHz Main Memory 256MB (512MB ) HDD 50MB XGA (1024 x 768 ) 12 FORCS Co., LTD

. %OZQ_HOME% Console.txt %OZQ_HOME% bin %OZQ_HOME% bin/res %OZQ_HOME% config %OZQ_HOME% lib OZQueryDesigner.exe OZRepositoryManager.ini OZUSLClientDes128.dll OZUSLClientSession.dll user.cif MultiLanguageList.xml qd.dll qd_error_msg.xml rm.dll rm_error_msg.xml server_error_msg.xml launch.cfg OZServerList.xml QDEnv.ini crimson.jar dtdparser120.jar jcert.jar jnet.jar jsee.jar log4j.jar ozsfw35.jar parser.jar USL XML DTD J2EE (HTTPS/SSL ) JRE 1.3.X Log XML FORCS Co., LTD 13

OZ Query Designer User's Guide xerces.jar xalan.jar xercesimpl.jar XML XPath %OZA_HOME% license UniversalDriver xml-apis.jar ozlicense.xml classes12.jar classes12.zip db2java.jar db2java.zip db2jcc.jar db2jcc_license_ cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar msbase.jar mssqlserver.jar msutil.jar mysql.jar unisqljdbc10.jar unsqljdbc205.zip Oracle 8i, 9i JDBC Driver IBM DB2 JDBC Driver IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Driver Oracle 7i JDBC Driver Sybase ASE JDBC Driver MSSQL 97 JDBC IBM JT400 JDBC MSSQL 2000 JDBC Mysql JDBC UniSQL JDBC : JDBC "UniversalDriver" JDBC, RDB JDBC. RDB JDBC. 14 FORCS Co., LTD

[] [OZ XStudio] [OZ Query Designer 3.5] 'OZ Query Designer 3.5'.. FORCS Co., LTD 15

OZ Query Designer User's Guide. config launch.cfg. launch.cfg. CLASSPATH =.\lib\ozsfw35.jar;.\lib\log4j.jar;.\lib\xalan.jar;.\lib\xercesimpl.jar;.\xmlapis.jar;.\lib\parser.jar;.\lib\xerces.jar;.\lib\dtdparser120.jar;.\lib\jcert.jar;.\lib\jnet.jar;.\lib\jsse.jar;.\universaldriver\classes12.zip;.\universaldriver\db2java.zip;.\uni versaldriver\ifxjdbc.jar;.\universaldriver\jconn2.jar;.\universaldriver\msbase.jar;.\ UniversalDriver\mssqlserver.jar;.\UniversalDriver\msutil.jar;.\UniversalDriver\mysql.jar;.\UniversalDriver\unisqljdbc10.jar;.\UniversalDriver\sapjco.jar JRE_PATH = "C:\Program Files\Java\j2re1.4.2_03\bin\client\jvm.dll" JDBC CLASSPATH. JDBC lib JDBC launch.cfg. 16 FORCS Co., LTD

: Java Java launch.cfg Java. "-" Java, Java "-" launch.cfg. Java launch.cfg. CLASSPATH =.\lib\ozsfw35.jar;.\lib\log4j.jar;.\lib\xalan.jar;.\lib\xercesimpl.jar;.\x mlapis.jar;.\lib\parser.jar;.\lib\xerces.jar;.\lib\dtdparser120.jar;.\lib\jcert.jar;.\lib\jnet.jar;.\lib\jsse.jar;.\universaldriver\classes12.zip;.\univers aldriver\db2java.zip;.\universaldriver\ifxjdbc.jar;.\universaldriver\jco nn2.jar;.\universaldriver\msbase.jar;.\universaldriver\mssqlserver.jar ;.\UniversalDriver\msutil.jar;.\UniversalDriver\mysql.jar;.\UniversalDri ver\unisqljdbc10.jar;.\universaldriver\sapjco.jar JRE_PATH = "C:\Program Files\Java\j2re1.4.2_03\bin\client\jvm.dll" -Djava.version=AAA -Djava.vendor=ABC -Dos.name=DEF -Dos.arch=GHI -Dos.version=JKL -Duser.name=MNO -Duser.home=PQR -Dsystem.IPs=STU -Dforcs=Forcs FORCS Co., LTD 17

OZ Query Designer User's Guide 18 FORCS Co., LTD

FORCS Co., LTD 19

OZ Query Designer User's Guide.. 20 FORCS Co., LTD

ODI(OZ Data Info). (pull down),,,,,,,.,.,,,, ' ', ' ', ' '.. ODI(OZ Data Info),,.... FORCS Co., LTD 21

OZ Query Designer User's Guide ODI(OZ Data Info).. OZ Query Designer ODI. Untitled#. - OZProduct.odi - 22 FORCS Co., LTD

[]. (Ctrl+N) ODI. (Ctrl+O) ODI.. (Ctrl+S).. FORCS Co., LTD 23

OZ Query Designer User's Guide SDM ODI SDM(Server Data Module). SDM.. [ ]. [ ].. ODI.. [ ] ODI 24 FORCS Co., LTD

.. [ ].,.... FORCS Co., LTD 25

OZ Query Designer User's Guide ODI. ODI.. : []. ODI.. : "ForceLocal" " ",. OpenType Local OZServer ForceLocal ForceOZServe r ForceOpenTy pe ODI..... ODI.. 26 FORCS Co., LTD

,... SQL SQL. SQL.. SQL, JDBC Driver. JDBC Driver. SQL ASCII REPLACE SUM MIN USER DUMP SYSDATE LAST_DAY NEXT_DAY (Space Tab), 4. 1, 2, 3, 4. ODI 4.. FORCS Co., LTD 27

OZ Query Designer User's Guide. (Ctrl+Z). : Undo. (Ctrl+Y),. (Ctrl+X). [].. (Ctrl+C)., [ ].. (Ctrl+V).. 28 FORCS Co., LTD

(Ctrl+F). []. (Ctrl+H). []. (Ctrl+G). []. (Alt+0). FORCS Co., LTD 29

OZ Query Designer User's Guide (Alt+1). (Alt+2). (F5). (Ctrl+F5). [ ], ' ' 'true'. [ ] 2. 30 FORCS Co., LTD

- (Ctrl+W). - (Ctrl+M).,. 9.,. FORCS Co., LTD 31

OZ Query Designer User's Guide. []. OZ QueryDesigner,. 32 FORCS Co., LTD

,,,,.,,,,., FORCS Co., LTD 33

OZ Query Designer User's Guide.,,,,,, 34 FORCS Co., LTD

FORCS Co., LTD 35

OZ Query Designer User's Guide,.. HTTP, XML...,. 36 FORCS Co., LTD

. (UDS) /HTTP XML SAP JDBC ODBC SQL. (, CSV, XML) (EJB, Servlet, ASP, JSP, Stored Procedure) Java Interface., UDS. /. XML(DTD XML ), CSV. DTD/XSD XML. SAP R/3 SAP ABAP.,,,.. FORCS Co., LTD 37

OZ Query Designer User's Guide DB_{} SQL_{} {1}, {2}, {3} (UDS) CLASS_{} SET_{} {1}, {2}, {3} Group_{} SHADOW_{} {1}, {2}, {3} FileXML_{} {1}, {2}, {3} FileCSV_{} {1}, {2}, {3} FileDYNAMIC_{} {1}, {2}, {3} HTTP HTTPXML_{} {1}, {2}, {3} HTTPCSV_{} {1}, {2}, {3} HTTPDYNAMIC_{} {1}, {2}, {3} XML SAP XML _{} DataSet_{} {1}, {2}, {3} SAP _{} Function_{} SET_{} {1}, {2}, {3} {1} {2} {3} INCLUDE ODI Include_{} 38 FORCS Co., LTD

,,,.,,. True False ""( ), 0. Null Null Data( ), null Null Data.. FORCS Co., LTD 39

OZ Query Designer User's Guide Concurrent '#'. '#' #OZParam.#. ' ' 'True' '#'.. Byte.. : '0'. :,,.. : " " " ", " ". " Default ". () OZServer Local.. : " " " ". 40 FORCS Co., LTD

OpenType Local OZServer Default OZServer Local Default OZServer Local Default OZServer Local ODI.,,.. :.... :... :.. :.. ForceLocal ForceOZServer ForceOpenType.. :. ODI.,,. FORCS Co., LTD 41

OZ Query Designer User's Guide JDBC ODBC. [ ], [ ] [ ] []. (DB_).. JDBC.. ODBC/JDBC.... db.properties.. (Commit).. JDBC.. Oracle dblink DB2. DB JDBC. JDBC com.setautocommit(false) com.preparedstatement(sqlstr) =false OZ =true 42 FORCS Co., LTD

(SQL_).... DataAction.. ". // ". DataAction.. ". // ". DataAction.. ". // ".. (Row).. 'True', 'True'.. ( JDBC preparedstatement.) : 'True' ". ". :,. FORCS Co., LTD 43

OZ Query Designer User's Guide Concurrent Concurrent Row. : 'True' ". ".. 'True'.. //. 'True' //,. : 'True' // ". // ". Byte.. : '0'. :,,... : '0'. :,,,.... 44 FORCS Co., LTD

.. (UDS) (UDS: ) EJB,, Non-DB. UDS "API. ". (CLASS_) UDS. UDS.. (SET_) UDS. UDS UDS. DataAction.. ". // ". DataAction.. ". // ". FORCS Co., LTD 45

OZ Query Designer User's Guide Concurrent Concurrent Row DataAction.. ". // ".. (Row).. 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. UDS. UDS.. 46 FORCS Co., LTD

,. -. (GROUP_).. (Shadow_) Consume Row Concurrent... Comsum Row. 'True'. 'True'. (Row).. 'True'. Byte.. : '0'. :,,. FORCS Co., LTD 47

OZ Query Designer User's Guide Concurrent Row.. : '0'. :,,,...... XML (FileXML_).. (Row). XML. XML.. 'True'. 48 FORCS Co., LTD

Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. CSV (FileCSV_).. (Row).... 'True'. FORCS Co., LTD 49

OZ Query Designer User's Guide Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. : PGP CSV UDS.... HTTP. HTTP XML (HTTPXML_) 50 FORCS Co., LTD

Concurrent Concurrent Row Http.. (Row). XML. XML.. 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. HTTP CSV (HTTPCSV_) Http.. (Row)... FORCS Co., LTD 51

OZ Query Designer User's Guide Concurrent Concurrent Row. 'True'. Byte.. : '0'. :,,... : '0'. :,,,..... XML DTD/XSD XML. XML DTD/XSD 52 FORCS Co., LTD

XML. XML DTD/XSD (DTDSet_, XSDSet_) Concurrent Concurrent Row XML... 'True'. Byte.. : '0'. :,,... : '0'. :,,,... (Full Name). XML. XML... FORCS Co., LTD 53

OZ Query Designer User's Guide SAP SAP R/3 RFC(Remote Function Call). SAP ().. SAP. SAP. SAP SAP. SAP Concurrent SAP.. Byte.. : '0'. :,,. 54 FORCS Co., LTD

Concurrent Row.. : '0'. :,,,.......... FORCS Co., LTD 55

OZ Query Designer User's Guide Include ODI LocalExplorer ODI Include. Include OZURL Include. URL. ODI OZ URL [Repository Root], [LocalExplorer]. ) ozp://// 56 FORCS Co., LTD

ODBC/JDBC.. Step 1 [] [ ]. Step 2 [ ]. Step 3 [] [DATABASE]. FORCS Co., LTD 57

OZ Query Designer User's Guide ' ', ' SQL', ' SQL'. JDBC ODBC. IP. (). JDBC JDBC Driver Type, ODBC ( ODBC ) ODBC. ' JDBC '. IP. 58 FORCS Co., LTD

DB. ( ). (Oracle, Informix )... ID... db.properties DB. DB, DB DB. db.properties. : / "Appendix. ". SQL / SQL SQL SQL. FORCS Co., LTD 59

OZ Query Designer User's Guide SQL SQL SQL SQL. SQL SQL. SQL JDBC SQL SQL. ) INSERT, UPDATE, DELETE SQL SQL. SQL. SQL. SQL. : SQL. ODBC JDBC. ODBC ODBC ODBC MS Access, dbase, Foxpro. ODBC. 60 FORCS Co., LTD

ODBC. " " " ". " " "ODBC". " " "ODBC ". " ", "". " " FORCS Co., LTD 61

OZ Query Designer User's Guide. JDBC JDBC JDBC MS-SQL, Oracle, Sybase. JDBC " ".. - MS-SQL " " " ". " " "MS-SQL". " IP ", " ", " " IP,,. " ", "". " ". - Oracle 62 FORCS Co., LTD

" " " ". " " "Oracle". " " Oracle JDBC. Oracle JDBC thin(type-4) oci(type-2),. " IP ", " " IP,. " " Oracle SID(). Oracle "ORCL". " ", "". " ". - Sybase FORCS Co., LTD 63

OZ Query Designer User's Guide " " " ". " " "Sybase". " " Sybase JDBC jconnect "Tds". Tds(Tabular Data Stream) Adative Server Sybase. " IP ", " ", " " IP,,. ' ", "". " ". - Informix 64 FORCS Co., LTD

" " " ". " " "Informix". " IP ", " ", " ", " " IP,,,. " ", "". " ". - Informix_NLS FORCS Co., LTD 65

OZ Query Designer User's Guide " " " ". " " 'Informix_NLS'. " IP ", " ", " ", " " IP,,,. " ", "". " ". - Uni-SQL 66 FORCS Co., LTD

" " " ". " " "Uni-SQL". " IP ", " " " " IP,,. " ", "". " ". - IBM-DB2 FORCS Co., LTD 67

OZ Query Designer User's Guide " " " ". " " "IBM-DB2". " IP ", " ", " " IP,,. " ", "". " ". - User-Definded User-Definded JDBC JDBC Connection URL. 68 FORCS Co., LTD

" " " ". " " "User-defined". " ", "". " ". DB DB Connection URL " ", "".. Step 1 'Foodmart' [ ]. FORCS Co., LTD 69

OZ Query Designer User's Guide Step 2 [ ]. Step 3 []. Step 4 (). ". ". 70 FORCS Co., LTD

, SQL.. Step 1 IP,,,. ' ' [ ]. FORCS Co., LTD 71

OZ Query Designer User's Guide.. (Default).. Step 2, []. 'IP', 'PortNo', 'UserName', 'Password',. [] ''. 72 FORCS Co., LTD

Step 3. '' [ ]. Step 4..,. FORCS Co., LTD 73

OZ Query Designer User's Guide (Alias) db.properties. [/conf] db.properties. MS_SQL, "ProductSales" db.properties. # setting for MS-SQL with Alias ProductSales ProductSales.vendor=mssql ProductSales.serverAddress=127.0.0.1 ProductSales.portNo=1433 ProductSales.dbName=marketing ProductSales.user=sa ProductSales.password= ProductSales.maxconns=20 ProductSales.initconns=5 ProductSales.timeout=5 ODI ( :DB_Aliase, :ProductSales).. 74 FORCS Co., LTD

: DB UI. FORCS Co., LTD 75

OZ Query Designer User's Guide 76 FORCS Co., LTD

FORCS Co., LTD 77

OZ Query Designer User's Guide. RDB... () / / [] [ ].. SQL., SQL. 78 FORCS Co., LTD

[] -> [] -> [] ( ).. Step 1 []. Step 2 [] [ ] ( ) <F5>. []. FORCS Co., LTD 79

OZ Query Designer User's Guide :.. Step 3. 80 FORCS Co., LTD

Where. [ ].. [ ]... FORCS Co., LTD 81

OZ Query Designer User's Guide [] -> [] -> [ ] (. ) [],,.. Step 1 [] &.., From. 82 FORCS Co., LTD

(. ) Step 2.,. ' '. DB Primary, Foreign Key JDBC (Oracle, MS-SQL ) : Primay, Foreign Key DB Primary, Foreign Key JDBC (ODBC ) : FORCS Co., LTD 83

OZ Query Designer User's Guide ' ' [] []. &. [ ]. 84 FORCS Co., LTD

. :,.. 9i. <Delete> [ ]. FORCS Co., LTD 85

OZ Query Designer User's Guide. Step 3 &. <Shift> <Ctrl>, <Delete>. 86 FORCS Co., LTD

Step 4. [] -> [ ] [ ]. [ ].,,. ' '. Step 5,. Step 6. FORCS Co., LTD 87

OZ Query Designer User's Guide : MDB MS-SQL " ex) Car Sales [Car Sales]. ex) 9Sales [9Sales]. ex) Sales.Sales [Sales].Sales Step 7 [] [ ] ( ) <F5>. []. 88 FORCS Co., LTD

Step 8. FORCS Co., LTD 89

OZ Query Designer User's Guide SQL. SQL SELECT UI.. From.. Select.. Where.. Where.. Group by, Select.. Order by. <Shift> <Ctrl>,... From. 90 FORCS Co., LTD

UI >, >> <, <<. ' '. ' '.. '',. ' ' ' ' ' '. ' ' ' '.. FORCS Co., LTD 91

OZ Query Designer User's Guide UI..,,,,. : DB2. DB,.,.., DB2 [] [ ].,. 92 FORCS Co., LTD

,. UI > >>,,,.. [].. ' ' ' '. ' ' ' '. < ' '. << ' '., [ ]... JDBC SQL (,,,, ). FORCS Co., LTD 93

OZ Query Designer User's Guide.,., ','.., &.,. " ". SQL Where. 94 FORCS Co., LTD

UI AND / OR /NOT/IN/BETW EEN/ = /<>/( / ) /,.... JDBC SQL (,,,, )..,.. SQL Group by. FORCS Co., LTD 95

OZ Query Designer User's Guide UI >. ' '. ' ' ' '. <, << ' '.. (AVG, COUNT, MAX, MIN, SUM) (Having).... - [ ]. 96 FORCS Co., LTD

,. SQL Order by. UI. ' '. FORCS Co., LTD 97

OZ Query Designer User's Guide >, >> ' ' ' '. <, << ' '.,. /,. ' '.. ' ' ' '. 98 FORCS Co., LTD

., UDS, XML, CSV,. Step 1 [ ]. Step 2 [] [] []. FORCS Co., LTD 99

OZ Query Designer User's Guide UI.. " ". : setfielddata(), setquerystring(),.. /.,. Functions : Mathematics, Sting opr., Database I/O, Date opr., Miscellaneous. Database :. Parameter :. 100 FORCS Co., LTD

Step 3 []. FORCS Co., LTD 101

OZ Query Designer User's Guide ODI ODI. Include Step 1 [INCLUDE ODI] []. Step 2 ODI [], 'Include '. 'Include ' ODI. Step 3 ODI,, Include. Include,, [,, ]. 102 FORCS Co., LTD

Include Include [ODI ]. Include, [] Include,,. FORCS Co., LTD 103

OZ Query Designer User's Guide Include "Include ODI" ODI ODI. ODI ODI. ODI ODI,,. ODI., A.odi B.odi C.odi C.odi A.odi, B.odi. 104 FORCS Co., LTD

/. : (MemberGrade) : (Customer) Step 1.. SELECT customer.member_card FROM customer FORCS Co., LTD 105

OZ Query Designer User's Guide GROUP BY customer.member_card Step 2.. SELECT customer.customer_id, customer.fname, customer.lname, customer.phone1, customer.gender FROM customer WHERE customer.member_card = '#MemberGrade.member_card#' Step 3 (Customer) (MemberGrade) 106 FORCS Co., LTD

. FORCS Co., LTD 107

OZ Query Designer User's Guide JDBC "PreparedStatement", " " "True".,.. " " " ". = "False", = "True"/"False" #OZParam.# '#OZParam.#'. - SELECT * FROM WHERE = #OZParam.# - SELECT * FROM WHERE = '#OZParam.#' SELECT * FROM WHERE LIKE '%#OZParam.#%' = "True", = "True" #OZParam.# '#OZParam.#',. - string sql; sql = "SELECT * FROM WHERE = #OZParam.#"; setquerystring(sql); 108 FORCS Co., LTD

- string sql; sql = "SELECT * FROM WHERE = '#OZParam.#' "; setquerystring(sql); string sql; sql = "SELECT * FROM WHERE LIKE '%#OZParam.#%' "; setquerystring(sql); = "True", = "False" #OZParam.# '#OZParam.#',. ex) '#OZParam.#' "'" + #OZParam.# + "'" - string sql; sql = "SELECT * FROM WHERE = " + #OZParam.#; setquerystring(sql); - string sql; sql = "SELECT * FROM WHERE = " + "'" + #OZParam.# + "'"; setquerystring(sql); string sql; sql = "SELECT * FROM WHERE LIKE " + " '%" + #OZParam. # + "%' "; setquerystring(sql); FORCS Co., LTD 109

OZ Query Designer User's Guide " // " DataAction(Insert, Delete, Update), (UDS). " // ", //. // [ ], [ ], [ ]. [ // ]. 110 FORCS Co., LTD

- [ ] ' ' ' '. ' ' ' ' []. "ARG_SF", "ARG_SV", "ARG_DF", "ARG_DV". "ARG_S_", "ARG_D_". FORCS Co., LTD 111

OZ Query Designer User's Guide - " ". " ". [ ] [] //. // // " " " ". // -. -. - /,. ex) 4 #@ARG_SV1#, '#@ARG_SV2#', '#@ARG_SV3#', '#@ARG_SV4#' - " " "False" "" "null". 112 FORCS Co., LTD

null. "null", "". "null" TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, BIT, NUMERIC, DECIMAL, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, BLOB, CLOB "null" CHAR, VARCHAR, LONGVARCHAR = "False", = "True"/"False" #@ARG_SF# '#@ARG_SF#'. - ( ) INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#',..., '#@ARG_SVn#') ( ) INSERT INTO (1, 2,..., n) VALUES (#@ARG_S_1#, '#@ARG_S_2#',..., '#@ARG_S_n#') - ( ) DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' ( ) DELETE FROM WHERE 1 = #@ARG_D_1# FORCS Co., LTD 113

OZ Query Designer User's Guide AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' - ( / ) UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#',... #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' ( / ) UPDATE SET 1 = #@ARG_S_1#, 2 = '#@ARG_S_2#',... n = '#@ARG_S_n#' WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' = "True", = "True" #@ARG_SF# '#@ARG_SF#',. - ( ) string sql; sql = " INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#',..., '#@ARG_SVn#') "; 114 FORCS Co., LTD

setquerystring(sql); ( ) string sql; sql = " INSERT INTO (1, 2,..., n) VALUES (#@ARG_S_1#, '#@ARG_S_2#',..., '#@ARG_S_n#') "; setquerystring(sql); - ( ) string sql; sql = " DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); ( ) string sql; sql = " DELETE FROM WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); - ( / ) string sql; sql = " UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#',..., #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); ( / ) string sql; sql = " UPDATE SET 1 = #@ARG_S_1#, 2 = '#@ARG_S_2#',..., n = '#@ARG_S_n#' WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_ 2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); FORCS Co., LTD 115

OZ Query Designer User's Guide = "True", = "False" #@ARG_SF1# '#@ARG_SF1#'. :. ex) '#@ARG_SF1#' "'" + #@ARG_SF1# + "'" - ( ) string sql; sql = " INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#',..., '#@ARG_SVn#') "; setquerystring(sql); string sql; sql = " INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (" + #@ARG_SV1# + ", " + "'" + #@ARG_SV2# + "'" + ",..., " + "'" + #@ARG_SVn# + "'" + ") "; setquerystring(sql); ( ) string sql; sql = " INSERT INTO (1, 2,..., n) VALUES (#@ARG_S_1#, '#@ARG_S_2#',..., '#@ARG_S_n#') "; setquerystring(sql); string sql; sql = " INSERT INTO (1, 2,..., n) VALUES (" + #@ARG_S_1# + ", " + "'" + #@ARG_S_2# + "'" + ",..., " + "'" + #@ARG_S_n# + "'" + ") "; setquerystring(sql); - ( ) string sql; 116 FORCS Co., LTD

sql = " DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); string sql; sql = " DELETE FROM WHERE #@ARG_DF1# = " + #@ARG_DV1# + " AND #@ARG_DF2# = " + "'" + #@ARG_DV2# + "'" + "... AND #@ARG_DFn# = " + "'" + #@ARG_DVn# + "'"; setquerystring(sql); ( ) string sql; sql = " DELETE FROM WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); string sql; sql = " DELETE FROM WHERE 1 = " + #@ARG_D_1 # + " AND 2 = " + "'" + #@ARG_D_2# + "'" + "... AND n = " + "'" + #@ARG_D_n# + "'"; setquerystring(sql); - ( / ) string sql; sql = " UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#',..., #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); string sql; sql = " UPDATE SET #@ARG_SF1# = " + #@ARG_SV1# + ", #@ARG_SF2# = " + "'" + #@ARG_SV2# + "'" + ",... #@ARG_SFn# = " + "'" + #@ARG_SVn# + "'" + " WHERE #@ARG_DF1# = " + FORCS Co., LTD 117

OZ Query Designer User's Guide #@ARG_DV1# + " AND #@ARG_DF2# = " + "'" + #@ARG_DV2# + "'" + "... AND #@ARG_DFn# = " + "'" + #@ARG_DVn# + "'"; setquerystring(sql); ( / ) string sql; sql = " UPDATE SET 1 = #@ARG_S_1#, 2 = '#@ARG_S_2#',..., n = '#@ARG_S_n#' WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_ 2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); string sql; sql = " UPDATE SET 1 = " + #@ARG_S_1# + ", _ 2 = " + "'" + #@ARG_S_2# +"'" + ",..., n = " + "'" + #@ARG_S_n# + "'" + " WHERE 1 = " + #@ARG_D_1# + " AND 2 = " + "'" + #@ARG_D_2 # + "'" + "... AND n = " + "'" + #@ARG_D_n# + "'"; setquerystring(sql); // - ODI //. #<>.<>#, '#<>.<>#'. //, / /. // = "False", = "False". //. = "False", = "True" "MDSet", "",, 118 FORCS Co., LTD

. - ( ) INSERT INTO (#@ARG_SF1#, #@ARG_SF2#, #@ARG_SF3#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#', '#MDSet.#'..., '#@ARG_SVn#') - ( ) DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF2# = '#MDSet.#'... AND #@ARG_DFn# = '#@ARG_DVn#' - ( / ) UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#MDSet.#',... #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF2# = '#MDSet.#'... AND #@ARG_DFn# = '#@ARG_DVn#' FORCS Co., LTD 119

OZ Query Designer User's Guide // = "False", = "True"/"False" "Customer", // - INSERT INTO Customer (#@ARG_SF1#,#@ARG_SF2#,#@ARG_SF3#,#@ARG_SF4#,#@ARG_SF5#,#@ARG_SF6#,#@ARG_SF7#,#@ARG_SF8#) VALUES(#@ARG_SV1#,'#@ARG_SV2#','#@ARG_SV3#','#@ARG_SV4#','#@ARG_SV5#','# @ARG_SV6#','#@ARG_SV7#','#@ARG_SV8#') - DELETE FROM Customer WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' - UPDATE Customer SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', #@ARG_SF7# = '#@ARG_SV7#', #@ARG_SF8# = '#@ARG_SV8#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' = "True", = "True" "Customer", // - string sql; sql = "INSERT INTO Customer (#@ARG_SF1#,#@ARG_SF2#,#@ARG_SF3#,#@ARG_SF4#,#@ARG_SF5#,#@ARG_SF6#,#@ARG_SF7#,#@ARG_SF8#) VALUES(#@ARG_SV1#,'#@ARG_SV2#','#@ARG_SV3#','#@ARG_SV4#','#@ARG_SV5#','# @ARG_SV6#','#@ARG_SV7#','#@ARG_SV8#')"; setquerystring(sql); 120 FORCS Co., LTD

- string sql; sql = "DELETE FROM Customer WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' "; setquerystring(sql); - string sql; sql = "UPDATE Customer SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', #@ARG_SF7# = '#@ARG_SV7#', #@ARG_SF8# = '#@ARG_SV8#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' "; setquerystring(sql); FORCS Co., LTD 121

OZ Query Designer User's Guide 122 FORCS Co., LTD

FORCS Co., LTD 123

OZ Query Designer User's Guide. ODI, OZR, OZA,,,.... Repository. Repository.,, C:\Program Files\FORCS\OZ XStudio\QueryDesigner. C:\Program Files\FORCS\OZ XStudio\Repository 124 FORCS Co., LTD

. [ ].. FORCS Co., LTD 125

OZ Query Designer User's Guide Step 1 ' ' [ ]. Step 2 ' ' ' '. Button Description XML. 126 FORCS Co., LTD

XML... [ ]..... Option IP URL Description. OZ Server. Daemon TCP, Servlet HTTP. Daemon OZ Server IP. Daemon OZ Server Port. Servlet OZ Server URL.... Step 3 [].. FORCS Co., LTD 127

OZ Query Designer User's Guide 'admin'. Step 4. [ ].. 128 FORCS Co., LTD

ODI. [] [] ( ). FORCS Co., LTD 129

OZ Query Designer User's Guide.. [] [] ( ).. 130 FORCS Co., LTD

,.,,,,. [ ]. ' ' []. FORCS Co., LTD 131

OZ Query Designer User's Guide & ' '. []. <Ctrl> <Shift>. ' '. []. ' ' 132 FORCS Co., LTD

: odi. []. ' ' []. ' ' ' ' ( ). FORCS Co., LTD 133

OZ Query Designer User's Guide., [] ' '. [] 134 FORCS Co., LTD

. [ ] ' ' ' '. []. FORCS Co., LTD 135

OZ Query Designer User's Guide,,. Admin 'None',, BuiltIn RDB. ' '.,.,.,.. []. 136 FORCS Co., LTD

' ' [Check In]. ' ' [].. : Admin 'None' Admin,.. [], ' ' [].. FORCS Co., LTD 137

OZ Query Designer User's Guide [ ], ' ' [ ]. ' '. 138 FORCS Co., LTD

FORCS Co., LTD 139

OZ Query Designer User's Guide /HTTP HTTP, CSV DTD XSD XML. CSV(Comma-Separated Value) CSV,. CSV, /HTTP. CSV /HTTP CSV. -,. -,. -. CSV ',' CSV. no,jumin_id,name,address INT,VARCHAR,VARCHAR,VARCHAR 1,7411231932347,kim,seoul 2,6305212983717,lee,pusan 3,7006031837261,park,daegu 4,7271722848281,song,daejeon 140 FORCS Co., LTD

XML(Extensible Markup Language) XML, The World Wide Web Consortium(W3C)., HTML UI XML. XML /HTTP XML. DTD XSD XML /HTTP, XML DTD XSD XML. XML /HTTP XML. - DTD XML. -. -. XML. <FIELDINFO> <FIELD NAME>="ID" TYPE="INT"/> <FIELD NAME>="NAME" TYPE="CHAR"/> <FIELD NAME>="ADDRESS" TYPE="VARCHAR"/>. </FIELDINFO>. XML, 'DATASET', 'RECORD' XML. <?xml version="1.0" encoding="ksc5601"?> <XMLSET> <DATASET> <FIELDINFO> <FIELD NAME-"ID" TYPE="INT"/> <FIELD NAME-"NAME" TYPE="CHAR"/> FORCS Co., LTD 141

OZ Query Designer User's Guide <FIELD NAME-"ADDRESS" TYPE="VARCHAR"/> </FIELDINFO> <RECORD> <ID>1</ID> <NAME>Park Chan Ho</NAME> <ADDRESS>Texas</ADDRESS> </RECORD> <RECORD> <ID>2</ID> <NAME>Shin Ki Sung</NAME> <ADDRESS>Seoul</ADDRESS> </RECORD> <RECORD> <ID>3</ID> <NAME>Kim Byung Hyun</NAME> <ADDRESS>Arizona</ADDRESS> </RECORD> </DATASET> </XMLSET> 142 FORCS Co., LTD

. XML CSV. XML XML XML XML. XML. XML XML. XML. 'DATASET'. XML. 'RECORD'. FORCS Co., LTD 143

OZ Query Designer User's Guide. ". ". XML.. XML <?xml version="1.0" encoding="ksc5601"?> <!-- Data Sample of OZ XML Dataset--> <XMLSET> <DATASET> <FIELDINFO> <FIELD NAME="ID" TYPE="INT"/> <FIELD NAME="NAME" TYPE="CHAR"/> <FIELD NAME="ADDRESS" TYPE="VARCHAR"/> </FIELDINFO> <RECORD> <ID>1</ID> <NAME>Park Chan Ho</NAME> <ADDRESS>USA</ADDRESS> </RECORD> </DATASET> </XMLSET> CSV 144 FORCS Co., LTD

CSV CSV CSV. CSV. CSV CSV.. TAB, SPACE, SEMICOLON, COLON, COMMA. CSV. 'VARCHAR'. NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. ". ". CSV.. CSV XML FORCS Co., LTD 145

OZ Query Designer User's Guide CSV XML. ". ". - - CSV CSV CSV CSV. ROW INDEX. '0' ROW INDEX 0. 0. CSV. CSV CSV. 146 FORCS Co., LTD

. TAB, SPACE, SEMICOLON, COLON, COMMA. CSV. 'VARCHAR'. NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. "V. ". CSV.. - - XML FORCS Co., LTD 147

OZ Query Designer User's Guide XML XML XML (). ROW INDEX. '0' ROW INDEX 0. 0. XML. XML XML. XML. 'DATASET'. XML. 'RECORD'.. ". ". XML.. 148 FORCS Co., LTD

(XML/CSV/ ). XML Step 1 [ ] [XML ]. Step 2 ' ' 'XML ' [ ]. FORCS Co., LTD 149

OZ Query Designer User's Guide Step 3 [] [ ] XML. CSV Step 1 [ ] [CSV ]. 150 FORCS Co., LTD

Step 2 ' ' 'CSV ' [ ]. Step 3 [] [ ] CSV. FORCS Co., LTD 151

OZ Query Designer User's Guide Step 1 [ ] [ ]. Step 2 ' ' 'CSV ' ' -CSV'. Step 3 ' ' ' -CSV' [ ]. 152 FORCS Co., LTD

Step 4 [] [ ]. FORCS Co., LTD 153

OZ Query Designer User's Guide JSP ASP HTTP. HTTP XML CSV. XML XML (URL) XML. HTTP.. 154 FORCS Co., LTD

URL... Server URL. URL 'TRUE'. XML. 'DATASET'. XML. 'RECORD'. URL GET POST.. ". ". XML.. CSV FORCS Co., LTD 155

OZ Query Designer User's Guide CSV (URL) CSV URL. HTTP..... Server URL. URL 'TRUE'.. TAB, SPACE, SEMICOLON, COLON, COMMA. CSV. 'FALSE' 'VARCHAR'. (TRUE/FALSE) NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV. URL GET POST. 156 FORCS Co., LTD

. ". ". CSV.. " ". HTTP HTTP HTTP (XML/CSV/ ). XML Step 1 XML (Sales.xml). FORCS Co., LTD 157

OZ Query Designer User's Guide Step 2 [HTTP ] [XML ]. Step 3 'HTTP ' 'XML ' [ ]. 158 FORCS Co., LTD

Step 4 [] [HTTP ] XML. CSV Step 1 HTTP CSV. http CSV. CSV. FORCS Co., LTD 159

OZ Query Designer User's Guide Step 2 [HTTP ] [CSV ]. Step 3 'HTTP ' 'CSV ' [ ]. 160 FORCS Co., LTD

Step 4 [] [HTTP ] CSV. FORCS Co., LTD 161

OZ Query Designer User's Guide " ". 162 FORCS Co., LTD

FORCS Co., LTD 163

OZ Query Designer User's Guide XML XML, The World Wide Web Consortium(W3C)., HTML UI XML. XML DTD/XSD DTD/XSD XML (Schema). DTD/XSD XML,.. XML XML DTD/XSD XML XML. XML XML. XML XML XML, DTD XSD XML /HTTP DTD XSD XML. XML XML DTD XML XSD. XML XML 164 FORCS Co., LTD

XML XML DTD/XSD. XML XML. XML XML XML ( URL) XML (DTD XSD). XML. XML. DTD/XSD.. "V. ". FORCS Co., LTD 165

OZ Query Designer User's Guide XML DTD. : " " XSD [] " ". " " Prefix Namespace URI. Prefix Namespace URI XSD Prefix Prefix. XSD Prefix. " " "ns1, ns2, ns3 ". URI,. XML XML (DTD/XSD ). XSD DTD DTD. XML DTD 166 FORCS Co., LTD

Step 1 [XML] [XML ]. Step 2 'XML ' [] 'XML '. Step 3 XML [ ] ' '. FORCS Co., LTD 167

OZ Query Designer User's Guide ' '. XML XPath XPath XML. XPath. XPath XPath. XPath XPath. XPath. XPath XPath. XPath. XML. [ ].. 168 FORCS Co., LTD

() () ( ) ( ), Type, XPath. " _1", "_2".. : " XPath " "" " "..... : XPath []., " XPath". - : /rsm:utradebusinessdocument/sbd:etsfad - : /.sbd:id : XPath XPath [ XPath ]. XPath ( ). XPath. FORCS Co., LTD 169

OZ Query Designer User's Guide : 1, 1 () 0, 0, 1 1, XPath Step 4 ' ' XPath [ XPath ] XPath. Step 5 [. ] ( ) 170 FORCS Co., LTD

Step 6 ' ' []. FORCS Co., LTD 171

OZ Query Designer User's Guide 172 FORCS Co., LTD

FORCS Co., LTD 173

OZ Query Designer User's Guide SAP SAP, SAP R/3. SAP,. SAP SAP SAP. SAP. SAP RFC(Remote Function Call: R/3 ) 174 FORCS Co., LTD

SAP. SAP SAP SAP ID () SAP...... SAP IP Address. SAP. SAP,. FORCS Co., LTD 175

OZ Query Designer User's Guide (sap.properties). : sap.properties " ". SAP SAP. Step 1 [SAP] [SAP ]. Step 2 [SAP ] 'SAP ' SAP. SAP. - 176 FORCS Co., LTD

- SAP ' [] 'SAP '. FORCS Co., LTD 177

OZ Query Designer User's Guide Step 3 SAP [ ] SAP 'SAP RFC Set '. RFC., []., '*', '?' [] RFC. 178 FORCS Co., LTD

[] (RFC). RFC []. Step 4. RFC [] RFC. FORCS Co., LTD 179

OZ Query Designer User's Guide [] RFC. RFC. Step 5 [] RFC. ODI. 180 FORCS Co., LTD

RFC, RFC FORCS Co., LTD 181

OZ Query Designer User's Guide 182 FORCS Co., LTD

FORCS Co., LTD 183

OZ Query Designer User's Guide (, UDS, /HTTP, XML DTD ) 2,.. - GDS, /.... - 184 FORCS Co., LTD

.,. 10 ACCOUNTING NEW YORK CLARK MANAGER 2572.2 10 ACCOUNTING NEW YORK KING PRESIDENT 5500 10 ACCOUNTING NEW YORK MILLER CLERK 920 20 RESEARCH DALLAS JONES MANAGER 3123.75 20 RESEARCH DALLAS CHAN ANALYST 3450 30 SALES CHICAGO ALLEN SALESMAN 1600 30 SALES CHICAGO MARTIN SALESMAN 1312.5,. FORCS Co., LTD 185

OZ Query Designer User's Guide <> <> ACCOUNT CLARK, KING, MILLER RESEARCH JOHNS, CHAN SALES ALLEN, MARTIN : true : #.# == #.# true. 'true'..... A FLAT TV 19" 500,000 A FLAT TV 21" 800,000 A FLAT TV 25" 1,500,000 B 100,000... B V 180,000 C 500 C 500 - < A > () #.# == "A"... A FLAT TV 19" 500,000... 186 FORCS Co., LTD

A FLAT TV 21" 800,000 A FLAT TV 25" 1,500,000 - < B > () #.# == "B"... B 100,000 B V 180,000... - < C > () #.# == "C"... C 500 C 500... :. FORCS Co., LTD 187

OZ Query Designer User's Guide UDS. [ ] [ ]., []. 188 FORCS Co., LTD

[ ]. []... FORCS Co., LTD 189

OZ Query Designer User's Guide Consume Row Comsum Row. 'True'. 'True'.. " ".. [ ]. [].. 190 FORCS Co., LTD

[], [ ]. FORCS Co., LTD 191

OZ Query Designer User's Guide 192 FORCS Co., LTD

FORCS Co., LTD 193

OZ Query Designer User's Guide UDS(User Data Store) (, CSV, XML) (EJB, Servlet, ASP, JSP, Applet) Java Interface. UDS JDBC/ODBC XML,,, EJB. UDS UDS Java Interface 194 FORCS Co., LTD

ResultSet., UDS UDS.. UDS "API ". FORCS Co., LTD 195

OZ Query Designer User's Guide UDS,. [ ]. UDS. UDS.. UDS. Step 1 [ (UDS)] [ ]. 196 FORCS Co., LTD

Step 2 [ ]. []. Step 3 [] [ ]. Step 4 [ ]. Step 5 ' '. FORCS Co., LTD 197

OZ Query Designer User's Guide. UDS UDS... " ". UDS. [], []. 198 FORCS Co., LTD

. :.,. Step 1 [ (UDS)] [ ]. Step 2 [ ] " ",. Step 3 [] [ ]. [ ]. FORCS Co., LTD 199

OZ Query Designer User's Guide Step 4 [ ]. Step 5 [ ] ' '.. 200 FORCS Co., LTD

[]. FORCS Co., LTD 201

OZ Query Designer User's Guide 202 FORCS Co., LTD

FORCS Co., LTD 203

OZ Query Designer User's Guide...,, /HTTP, XML DTD 2. ROWIDX, COLUMN, VALUE,.,.. - ROWIDX : - COLUMN : - VALUE : 1 2 ROWIDX, COLUMN, VALUE.,, Row Index. 204 FORCS Co., LTD

1 Region Sales2000 Sales2001 157000 890235 5234991 5432123 1234789 1123454 4563300 4992100 3551090 3901234 2 ROWIDX COLUMN VALUE 0 Region 0 Sales2000 257000 0 Sales2001 890235 1 Region 1 Sales2000 5234991 1 Sales2001 5432123 2 Region 2 Sales2000 1234789 2 Sales2001 1123454 3 Region 3 Sales2000 4563300 3 Sales2001 4992100 4 Region 4 Sales2000 3551090 4 Sales2002 3901234 FORCS Co., LTD 205

OZ Query Designer User's Guide. Step 1 [] [ ]. Step 2 [ ]. 206 FORCS Co., LTD

Step 3 ' ' []. Step 4. Step 5 ( ). ROWIDX, COLUMN, VALUE. FORCS Co., LTD 207

OZ Query Designer User's Guide 208 FORCS Co., LTD

FORCS Co., LTD 209

OZ Query Designer User's Guide,.. : " ". ASCII Big5 us-ascii, ascii, 646, iso646-us, default, ascii7 big5 Cp037 ibm037, ibm-037, cp037, 037 Cp1006 ibm1006, ibm-1006, cp1006, 1006 Cp1025 ibm1025, ibm-1025, cp1025, 1025 Cp1026 ibm1026, ibm-1026, cp1026, 1026 Cp1046 Cp1097 ibm1097, ibm-1097, cp1097, 1097 Cp1098 ibm1098, ibm-1098, cp1098, 1098 Cp1112 ibm1112, ibm-1112, cp1112, 1112 Cp1122 ibm1122, ibm-1122, cp1122, 1122 Cp1123 ibm1123, ibm-1123, cp1123, 1123 Cp1124 ibm1124, ibm-1124, cp1124, 1124 Cp1140 Cp1141 Cp1142 Cp1143 Cp1144 Cp1145 Cp1146 Cp1147 Cp1148 Cp1149 Cp1250 Cp1251 windows-1250 windows-1251 210 FORCS Co., LTD

Cp1252 Cp1253 Cp1254 Cp1255 Cp1256 Cp1257 Cp1258 windows-1252 windows-1253 windows-1254 windows-1255 windows-1256 windows-1257 windows-1258 Cp1381 ibm1381, ibm-1381, cp1381, 1381 Cp1383 ibm1383, ibm-1383, cp1383, 1383 Cp273 ibm273, ibm-273, cp273, 273 Cp277 ibm277, ibm-277, cp277, 277 Cp278 ibm278, ibm-278, cp278, 278 Cp280 ibm280, ibm-280, cp280, 280 Cp284 ibm284, ibm-284, cp284, 284 Cp285 ibm285, ibm-285, cp285, 285 Cp297 ibm297, ibm-297, cp297, 297 Cp33722 Ibm33722, ibm-33722, cp33722, 33722 Cp420 ibm420, ibm-420, cp420, 420 Cp424 ibm424, ibm-424, cp424, 424 Cp437 ibm437, ibm-437, cp437, 437 Cp500 ibm500, ibm-500, cp500, 500 Cp737 ibm737, ibm-737, cp737, 737 Cp775 ibm775, ibm-775, cp775, 775 Cp838 ibm838, ibm-838, cp838, 838 Cp850 Cp852 Cp855 ibm850, ibm-850, cp850, 850, cspc850multilingual ibm852, ibm-852, cp852, 852, cspcp852 ibm855, ibm-855, cp855, 855, cspcp855 Cp856 ibm856 ibm-856, cp856 856 Cp857 ibm857, ibm-857, cp857, 857, csibm857 Cp858 FORCS Co., LTD 211

OZ Query Designer User's Guide Cp860 Cp861 Cp862 Cp863 Cp864 Cp865 Cp866 ibm860, ibm-860, cp860, 860, csibm860 ibm861, ibm-861, cp861, cp-is, 861, csibm861 ibm862, ibm-862, cp862, cp862, 862, cspc862latinhebrew ibm863, ibm-863, cp863, 863, csibm863 ibm864, ibm-864, cp864, csibm864 ibm865, ibm-865, cp865, 865, csibm865 ibm866, ibm-866, cp866, 866, csibm866 Cp868 ibm868, ibm-868, cp868, 868 Cp869 ibm869, ibm-869, cp869, 869, cp-gr, csibm869 Cp870 ibm870, ibm-870, cp870, 870 Cp871 ibm871, ibm-871, cp871, 871 Cp874 ibm874, ibm-874, cp874, 874 Cp875 ibm875, ibm-875, cp875, 875 Cp918 ibm918, ibm-918, cp918, 918 Cp921 ibm921, ibm-921, cp921, 921 Cp922 ibm922, ibm-922, cp922, 922 Cp923 Cp930 ibm930, ibm-930, cp930, 930 Cp933 ibm933, ibm-933, cp933, 933 Cp935 ibm935, ibm-935, cp935, 935 Cp937 ibm937, ibm-937, cp937, 937 Cp939 ibm939, ibm-939, cp939, 939 Cp942 ibm942, ibm-942, cp942, 942 Cp942C cp942c Cp943 ibm943, ibm-943, cp943, 943 Cp943C cp943c Cp948 ibm948, ibm-948, cp948, 948 Cp949 ibm949, ibm-949, cp949, 949 Cp949C cp949c Cp950 ibm950, ibm-950, cp950, 950 212 FORCS Co., LTD

Cp964 ibm964, ibm-964, cp964, 964 Cp970 ibm970, ibm-970, cp970, 970 DBCS_ASCII DBCS_EBCDIC Default DoubleByte EUC EUC_CN EUC_JP EUC_KR EUC_TW gb2312, gb2312-80, gb2312-1980, euc-cn, euccn eucjis, euc-jp, eucjp, extended_unix_code_packed_format_for_japanese, cseucpkdfmtjapanese, x-euc-jp, x-eucjp ksc5601, euc-kr, euckr, ks_c_5601-1987, ksc5601-1987, ksc5601_1987, ksc_5601, 5601 cns11643, euc-tw, euctw GBK ISO2022 ISO2022CN ISO2022JP jis, iso-2022-jp, csiso2022jp, jis_encoding, csjisencoding ISO2022KR ISO8859_1 ISO8859_15_FDIS ISO8859_2 ISO8859_3 ISO8859_4 8859_1, iso_8859-1:1978, iso-ir-100, iso_8859-1, iso-8859-1, iso8859-1, latin1, l1, ibm819, ibm-819, cp819, 819, csisolatin1 8859_15, iso-8859-15, iso_8859-15, iso8859-15, ibm923, ibm-923, cp923, 923, latin0, latin9, csisolatin0, csisolatin9 8859_2, iso_8859-2:1987, iso-ir-101, iso_8859-2, iso-8859-2, iso8859-2, latin2, l2, ibm912, ibm-912, cp912, 912, csisolatin2, 8859_3, iso_8859-3:1988, iso-ir-109, iso_8859-3, iso-8859-3, iso8859-3, latin3, l3, ibm913, ibm-913, cp913, 913, csisolatin3 8859_4, iso_8859-4:1988, iso-ir-110, iso_8859-4, iso-8859-4, iso8859-4, latin4, l4, ibm914, ibm-914, cp914, 914, csisolatin4 FORCS Co., LTD 213

OZ Query Designer User's Guide ISO8859_5 ISO8859_6 ISO8859_7 ISO8859_8 ISO8859_9 ISO8859_13 8859_5, iso_8859-5:1988, iso-ir-144, iso_8859-5, iso-8859-5,iso8859-5, cyrillic, csisolatincyrillic, ibm915, ibm-915, cp915, 915, 8859_6, iso_8859-6:1987, iso-ir-127, iso_8859-6, iso-8859-6, iso8859-6, ecma-114, asmo-708, arabic, csisolatinarabic, ibm1089, ibm-1089, cp1089, 1089 8859_7, iso_8859-7:1987, iso-ir-126, iso_8859-7, iso-8859-7, iso8859-7, elot_928, ecma-118, greek, greek8, csisolatingreek, ibm813, ibm-813, cp813, 813 8859_8, iso_8859-8:1988, iso-ir-138, iso_8859-8, iso-8859-8, iso8859-8, hebrew, csisolatinhebrew, ibm916, ibm-916, cp916, 916 8859_9, iso-ir-148, iso_8859-9, iso-8859-9, iso8859-9, latin5, l5, ibm920, ibm-920, cp920, 920, csisolatin5 8859_13, iso_8859-13, iso-8859-13, iso8859-13, JIS0201 JIS0208 JIS0212 JISAutoDetect Johab KOI8_R MS874 MS932 jis auto detect ksc5601-1992, ksc5601_1992, ms1361 koi8-r, koi8, cskoi8r windows-874 shift_jis, ms_kanji, csshiftjis, windows-31j, cswindows31j, x-sjis MS932DB MS936 MS949 windows-949 MS950 MacArabic MacCentralEurope MacCroatian 214 FORCS Co., LTD

MacCyrillic MacDingbat MacGreek MacHebrew MacIceland MacRoman MacRomania MacSymbol MacThai MacTurkish MacUkraine SJIS?, pck SingleByte TIS620 UTF8 UTF16 Unicode UnicodeBig UnicodeLittle tis620.2533 utf-8, unicode-1-1-utf-8 utf-16 unicode unicode-1-1, iso-10646-ucs-2, utf-16be, x-utf-16be utf-16le, x-utf-16le FORCS Co., LTD 215