untitled
|
|
- 주형 호
- 5 years ago
- Views:
Transcription
1 FORCS Co., LTD 1
2 OZ Query Designer User's Guide 2 FORCS Co., LTD
3 FORCS Co., LTD 3
4 OZ Query Designer User's Guide 4 FORCS Co., LTD
5 FORCS Co., LTD 5
6 OZ Query Designer User's Guide UI. (ODI)., ODI. 6 FORCS Co., LTD
7 ...,.. /HTTP XML, CSV HTTP. FORCS Co., LTD 7
8 OZ Query Designer User's Guide XML XML-DTD XML-XSD. SAP SAP FORCS Co., LTD
9 ,. Getting Started Getting Started FORCS Co., LTD 9
10 OZ Query Designer User's Guide 10 FORCS Co., LTD
11 FORCS Co., LTD 11
12 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
13 . %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
14 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
15 [] [OZ XStudio] [OZ Query Designer 3.5] 'OZ Query Designer 3.5'.. FORCS Co., LTD 15
16 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
17 : 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
18 OZ Query Designer User's Guide 18 FORCS Co., LTD
19 FORCS Co., LTD 19
20 OZ Query Designer User's Guide.. 20 FORCS Co., LTD
21 ODI(OZ Data Info). (pull down),,,,,,,.,.,,,, ' ', ' ', ' '.. ODI(OZ Data Info),,.... FORCS Co., LTD 21
22 OZ Query Designer User's Guide ODI(OZ Data Info).. OZ Query Designer ODI. Untitled#. - OZProduct.odi - 22 FORCS Co., LTD
23 []. (Ctrl+N) ODI. (Ctrl+O) ODI.. (Ctrl+S).. FORCS Co., LTD 23
24 OZ Query Designer User's Guide SDM ODI SDM(Server Data Module). SDM.. [ ]. [ ].. ODI.. [ ] ODI 24 FORCS Co., LTD
25 .. [ ].,.... FORCS Co., LTD 25
26 OZ Query Designer User's Guide ODI. ODI.. : []. ODI.. : "ForceLocal" " ",. OpenType Local OZServer ForceLocal ForceOZServe r ForceOpenTy pe ODI..... ODI.. 26 FORCS Co., LTD
27 ,... 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
28 OZ Query Designer User's Guide. (Ctrl+Z). : Undo. (Ctrl+Y),. (Ctrl+X). [].. (Ctrl+C)., [ ].. (Ctrl+V).. 28 FORCS Co., LTD
29 (Ctrl+F). []. (Ctrl+H). []. (Ctrl+G). []. (Alt+0). FORCS Co., LTD 29
30 OZ Query Designer User's Guide (Alt+1). (Alt+2). (F5). (Ctrl+F5). [ ], ' ' 'true'. [ ] FORCS Co., LTD
31 - (Ctrl+W). - (Ctrl+M).,. 9.,. FORCS Co., LTD 31
32 OZ Query Designer User's Guide. []. OZ QueryDesigner,. 32 FORCS Co., LTD
33 ,,,,.,,,,., FORCS Co., LTD 33
34 OZ Query Designer User's Guide.,,,,,, 34 FORCS Co., LTD
35 FORCS Co., LTD 35
36 OZ Query Designer User's Guide,.. HTTP, XML...,. 36 FORCS Co., LTD
37 . (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
38 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
39 ,,,.,,. True False ""( ), 0. Null Null Data( ), null Null Data.. FORCS Co., LTD 39
40 OZ Query Designer User's Guide Concurrent '#'. '#' #OZParam.#. ' ' 'True' '#'.. Byte.. : '0'. :,,.. : " " " ", " ". " Default ". () OZServer Local.. : " " " ". 40 FORCS Co., LTD
41 OpenType Local OZServer Default OZServer Local Default OZServer Local Default OZServer Local ODI.,,.. :.... :... :.. :.. ForceLocal ForceOZServer ForceOpenType.. :. ODI.,,. FORCS Co., LTD 41
42 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
43 (SQL_).... DataAction.. ". // ". DataAction.. ". // ". DataAction.. ". // ".. (Row).. 'True', 'True'.. ( JDBC preparedstatement.) : 'True' ". ". :,. FORCS Co., LTD 43
44 OZ Query Designer User's Guide Concurrent Concurrent Row. : 'True' ". ".. 'True'.. //. 'True' //,. : 'True' // ". // ". Byte.. : '0'. :,,... : '0'. :,,, FORCS Co., LTD
45 .. (UDS) (UDS: ) EJB,, Non-DB. UDS "API. ". (CLASS_) UDS. UDS.. (SET_) UDS. UDS UDS. DataAction.. ". // ". DataAction.. ". // ". FORCS Co., LTD 45
46 OZ Query Designer User's Guide Concurrent Concurrent Row DataAction.. ". // ".. (Row).. 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. UDS. UDS.. 46 FORCS Co., LTD
47 ,. -. (GROUP_).. (Shadow_) Consume Row Concurrent... Comsum Row. 'True'. 'True'. (Row).. 'True'. Byte.. : '0'. :,,. FORCS Co., LTD 47
48 OZ Query Designer User's Guide Concurrent Row.. : '0'. :,,, XML (FileXML_).. (Row). XML. XML.. 'True'. 48 FORCS Co., LTD
49 Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. CSV (FileCSV_).. (Row).... 'True'. FORCS Co., LTD 49
50 OZ Query Designer User's Guide Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. : PGP CSV UDS.... HTTP. HTTP XML (HTTPXML_) 50 FORCS Co., LTD
51 Concurrent Concurrent Row Http.. (Row). XML. XML.. 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. HTTP CSV (HTTPCSV_) Http.. (Row)... FORCS Co., LTD 51
52 OZ Query Designer User's Guide Concurrent Concurrent Row. 'True'. Byte.. : '0'. :,,... : '0'. :,,,..... XML DTD/XSD XML. XML DTD/XSD 52 FORCS Co., LTD
53 XML. XML DTD/XSD (DTDSet_, XSDSet_) Concurrent Concurrent Row XML... 'True'. Byte.. : '0'. :,,... : '0'. :,,,... (Full Name). XML. XML... FORCS Co., LTD 53
54 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
55 Concurrent Row.. : '0'. :,,, FORCS Co., LTD 55
56 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
57 ODBC/JDBC.. Step 1 [] [ ]. Step 2 [ ]. Step 3 [] [DATABASE]. FORCS Co., LTD 57
58 OZ Query Designer User's Guide ' ', ' SQL', ' SQL'. JDBC ODBC. IP. (). JDBC JDBC Driver Type, ODBC ( ODBC ) ODBC. ' JDBC '. IP. 58 FORCS Co., LTD
59 DB. ( ). (Oracle, Informix )... ID... db.properties DB. DB, DB DB. db.properties. : / "Appendix. ". SQL / SQL SQL SQL. FORCS Co., LTD 59
60 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
61 ODBC. " " " ". " " "ODBC". " " "ODBC ". " ", "". " " FORCS Co., LTD 61
62 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
63 " " " ". " " "Oracle". " " Oracle JDBC. Oracle JDBC thin(type-4) oci(type-2),. " IP ", " " IP,. " " Oracle SID(). Oracle "ORCL". " ", "". " ". - Sybase FORCS Co., LTD 63
64 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
65 " " " ". " " "Informix". " IP ", " ", " ", " " IP,,,. " ", "". " ". - Informix_NLS FORCS Co., LTD 65
66 OZ Query Designer User's Guide " " " ". " " 'Informix_NLS'. " IP ", " ", " ", " " IP,,,. " ", "". " ". - Uni-SQL 66 FORCS Co., LTD
67 " " " ". " " "Uni-SQL". " IP ", " " " " IP,,. " ", "". " ". - IBM-DB2 FORCS Co., LTD 67
68 OZ Query Designer User's Guide " " " ". " " "IBM-DB2". " IP ", " ", " " IP,,. " ", "". " ". - User-Definded User-Definded JDBC JDBC Connection URL. 68 FORCS Co., LTD
69 " " " ". " " "User-defined". " ", "". " ". DB DB Connection URL " ", "".. Step 1 'Foodmart' [ ]. FORCS Co., LTD 69
70 OZ Query Designer User's Guide Step 2 [ ]. Step 3 []. Step 4 (). ". ". 70 FORCS Co., LTD
71 , SQL.. Step 1 IP,,,. ' ' [ ]. FORCS Co., LTD 71
72 OZ Query Designer User's Guide.. (Default).. Step 2, []. 'IP', 'PortNo', 'UserName', 'Password',. [] ''. 72 FORCS Co., LTD
73 Step 3. '' [ ]. Step 4..,. FORCS Co., LTD 73
74 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= 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
75 : DB UI. FORCS Co., LTD 75
76 OZ Query Designer User's Guide 76 FORCS Co., LTD
77 FORCS Co., LTD 77
78 OZ Query Designer User's Guide. RDB... () / / [] [ ].. SQL., SQL. 78 FORCS Co., LTD
79 [] -> [] -> [] ( ).. Step 1 []. Step 2 [] [ ] ( ) <F5>. []. FORCS Co., LTD 79
80 OZ Query Designer User's Guide :.. Step FORCS Co., LTD
81 Where. [ ].. [ ]... FORCS Co., LTD 81
82 OZ Query Designer User's Guide [] -> [] -> [ ] (. ) [],,.. Step 1 [] &.., From. 82 FORCS Co., LTD
83 (. ) Step 2.,. ' '. DB Primary, Foreign Key JDBC (Oracle, MS-SQL ) : Primay, Foreign Key DB Primary, Foreign Key JDBC (ODBC ) : FORCS Co., LTD 83
84 OZ Query Designer User's Guide ' ' [] []. &. [ ]. 84 FORCS Co., LTD
85 . :,.. 9i. <Delete> [ ]. FORCS Co., LTD 85
86 OZ Query Designer User's Guide. Step 3 &. <Shift> <Ctrl>, <Delete>. 86 FORCS Co., LTD
87 Step 4. [] -> [ ] [ ]. [ ].,,. ' '. Step 5,. Step 6. FORCS Co., LTD 87
88 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
89 Step 8. FORCS Co., LTD 89
90 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
91 UI >, >> <, <<. ' '. ' '.. '',. ' ' ' ' ' '. ' ' ' '.. FORCS Co., LTD 91
92 OZ Query Designer User's Guide UI..,,,,. : DB2. DB,.,.., DB2 [] [ ].,. 92 FORCS Co., LTD
93 ,. UI > >>,,,.. [].. ' ' ' '. ' ' ' '. < ' '. << ' '., [ ]... JDBC SQL (,,,, ). FORCS Co., LTD 93
94 OZ Query Designer User's Guide.,., ','.., &.,. " ". SQL Where. 94 FORCS Co., LTD
95 UI AND / OR /NOT/IN/BETW EEN/ = /<>/( / ) /,.... JDBC SQL (,,,, )..,.. SQL Group by. FORCS Co., LTD 95
96 OZ Query Designer User's Guide UI >. ' '. ' ' ' '. <, << ' '.. (AVG, COUNT, MAX, MIN, SUM) (Having) [ ]. 96 FORCS Co., LTD
97 ,. SQL Order by. UI. ' '. FORCS Co., LTD 97
98 OZ Query Designer User's Guide >, >> ' ' ' '. <, << ' '.,. /,. ' '.. ' ' ' '. 98 FORCS Co., LTD
99 ., UDS, XML, CSV,. Step 1 [ ]. Step 2 [] [] []. FORCS Co., LTD 99
100 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
101 Step 3 []. FORCS Co., LTD 101
102 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
103 Include Include [ODI ]. Include, [] Include,,. FORCS Co., LTD 103
104 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
105 /. : (MemberGrade) : (Customer) Step 1.. SELECT customer.member_card FROM customer FORCS Co., LTD 105
106 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
107 . FORCS Co., LTD 107
108 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
109 - 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
110 OZ Query Designer User's Guide " // " DataAction(Insert, Delete, Update), (UDS). " // ", //. // [ ], [ ], [ ]. [ // ]. 110 FORCS Co., LTD
111 - [ ] ' ' ' '. ' ' ' ' []. "ARG_SF", "ARG_SV", "ARG_DF", "ARG_DV". "ARG_S_", "ARG_D_". FORCS Co., LTD 111
112 OZ Query Designer User's Guide - " ". " ". [ ] [] //. // // " " " ". // /,. ex) 4 #@ARG_SV1#, '#@ARG_SV2#', '#@ARG_SV3#', '#@ARG_SV4#' - " " "False" "" "null". 112 FORCS Co., LTD
113 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
114 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
115 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
116 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
117 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
118 OZ Query Designer User's Guide + " AND = " + "'" + #@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
119 . - ( ) 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
120 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#) - 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#) setquerystring(sql); 120 FORCS Co., LTD
121 - 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
122 OZ Query Designer User's Guide 122 FORCS Co., LTD
123 FORCS Co., LTD 123
124 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
125 . [ ].. FORCS Co., LTD 125
126 OZ Query Designer User's Guide Step 1 ' ' [ ]. Step 2 ' ' ' '. Button Description XML. 126 FORCS Co., LTD
127 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
128 OZ Query Designer User's Guide 'admin'. Step 4. [ ] FORCS Co., LTD
129 ODI. [] [] ( ). FORCS Co., LTD 129
130 OZ Query Designer User's Guide.. [] [] ( ) FORCS Co., LTD
131 ,.,,,,. [ ]. ' ' []. FORCS Co., LTD 131
132 OZ Query Designer User's Guide & ' '. []. <Ctrl> <Shift>. ' '. []. ' ' 132 FORCS Co., LTD
133 : odi. []. ' ' []. ' ' ' ' ( ). FORCS Co., LTD 133
134 OZ Query Designer User's Guide., [] ' '. [] 134 FORCS Co., LTD
135 . [ ] ' ' ' '. []. FORCS Co., LTD 135
136 OZ Query Designer User's Guide,,. Admin 'None',, BuiltIn RDB. ' '.,.,.,.. []. 136 FORCS Co., LTD
137 ' ' [Check In]. ' ' [].. : Admin 'None' Admin,.. [], ' ' [].. FORCS Co., LTD 137
138 OZ Query Designer User's Guide [ ], ' ' [ ]. ' '. 138 FORCS Co., LTD
139 FORCS Co., LTD 139
140 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, ,kim,seoul 2, ,lee,pusan 3, ,park,daegu 4, ,song,daejeon 140 FORCS Co., LTD
141 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
142 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
143 . XML CSV. XML XML XML XML. XML. XML XML. XML. 'DATASET'. XML. 'RECORD'. FORCS Co., LTD 143
144 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
145 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
146 OZ Query Designer User's Guide CSV XML. ". ". - - CSV CSV CSV CSV. ROW INDEX. '0' ROW INDEX CSV. CSV CSV. 146 FORCS Co., LTD
147 . TAB, SPACE, SEMICOLON, COLON, COMMA. CSV. 'VARCHAR'. NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. "V. ". CSV XML FORCS Co., LTD 147
148 OZ Query Designer User's Guide XML XML XML (). ROW INDEX. '0' ROW INDEX XML. XML XML. XML. 'DATASET'. XML. 'RECORD'.. ". ". XML FORCS Co., LTD
149 (XML/CSV/ ). XML Step 1 [ ] [XML ]. Step 2 ' ' 'XML ' [ ]. FORCS Co., LTD 149
150 OZ Query Designer User's Guide Step 3 [] [ ] XML. CSV Step 1 [ ] [CSV ]. 150 FORCS Co., LTD
151 Step 2 ' ' 'CSV ' [ ]. Step 3 [] [ ] CSV. FORCS Co., LTD 151
152 OZ Query Designer User's Guide Step 1 [ ] [ ]. Step 2 ' ' 'CSV ' ' -CSV'. Step 3 ' ' ' -CSV' [ ]. 152 FORCS Co., LTD
153 Step 4 [] [ ]. FORCS Co., LTD 153
154 OZ Query Designer User's Guide JSP ASP HTTP. HTTP XML CSV. XML XML (URL) XML. HTTP FORCS Co., LTD
155 URL... Server URL. URL 'TRUE'. XML. 'DATASET'. XML. 'RECORD'. URL GET POST.. ". ". XML.. CSV FORCS Co., LTD 155
156 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
157 . ". ". CSV.. " ". HTTP HTTP HTTP (XML/CSV/ ). XML Step 1 XML (Sales.xml). FORCS Co., LTD 157
158 OZ Query Designer User's Guide Step 2 [HTTP ] [XML ]. Step 3 'HTTP ' 'XML ' [ ]. 158 FORCS Co., LTD
159 Step 4 [] [HTTP ] XML. CSV Step 1 HTTP CSV. http CSV. CSV. FORCS Co., LTD 159
160 OZ Query Designer User's Guide Step 2 [HTTP ] [CSV ]. Step 3 'HTTP ' 'CSV ' [ ]. 160 FORCS Co., LTD
161 Step 4 [] [HTTP ] CSV. FORCS Co., LTD 161
162 OZ Query Designer User's Guide " ". 162 FORCS Co., LTD
163 FORCS Co., LTD 163
164 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
165 XML XML DTD/XSD. XML XML. XML XML XML ( URL) XML (DTD XSD). XML. XML. DTD/XSD.. "V. ". FORCS Co., LTD 165
166 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
167 Step 1 [XML] [XML ]. Step 2 'XML ' [] 'XML '. Step 3 XML [ ] ' '. FORCS Co., LTD 167
168 OZ Query Designer User's Guide ' '. XML XPath XPath XML. XPath. XPath XPath. XPath XPath. XPath. XPath XPath. XPath. XML. [ ] FORCS Co., LTD
169 () () ( ) ( ), Type, XPath. " _1", "_2".. : " XPath " "" " "..... : XPath []., " XPath". - : /rsm:utradebusinessdocument/sbd:etsfad - : /.sbd:id : XPath XPath [ XPath ]. XPath ( ). XPath. FORCS Co., LTD 169
170 OZ Query Designer User's Guide : 1, 1 () 0, 0, 1 1, XPath Step 4 ' ' XPath [ XPath ] XPath. Step 5 [. ] ( ) 170 FORCS Co., LTD
171 Step 6 ' ' []. FORCS Co., LTD 171
172 OZ Query Designer User's Guide 172 FORCS Co., LTD
173 FORCS Co., LTD 173
174 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
175 SAP. SAP SAP SAP ID () SAP SAP IP Address. SAP. SAP,. FORCS Co., LTD 175
176 OZ Query Designer User's Guide (sap.properties). : sap.properties " ". SAP SAP. Step 1 [SAP] [SAP ]. Step 2 [SAP ] 'SAP ' SAP. SAP FORCS Co., LTD
177 - SAP ' [] 'SAP '. FORCS Co., LTD 177
178 OZ Query Designer User's Guide Step 3 SAP [ ] SAP 'SAP RFC Set '. RFC., []., '*', '?' [] RFC. 178 FORCS Co., LTD
179 [] (RFC). RFC []. Step 4. RFC [] RFC. FORCS Co., LTD 179
180 OZ Query Designer User's Guide [] RFC. RFC. Step 5 [] RFC. ODI. 180 FORCS Co., LTD
181 RFC, RFC FORCS Co., LTD 181
182 OZ Query Designer User's Guide 182 FORCS Co., LTD
183 FORCS Co., LTD 183
184 OZ Query Designer User's Guide (, UDS, /HTTP, XML DTD ) 2,.. - GDS, / FORCS Co., LTD
185 .,. 10 ACCOUNTING NEW YORK CLARK MANAGER ACCOUNTING NEW YORK KING PRESIDENT ACCOUNTING NEW YORK MILLER CLERK RESEARCH DALLAS JONES MANAGER RESEARCH DALLAS CHAN ANALYST SALES CHICAGO ALLEN SALESMAN SALES CHICAGO MARTIN SALESMAN ,. FORCS Co., LTD 185
186 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, B V 180,000 C 500 C < A > () #.# == "A"... A FLAT TV 19" 500, FORCS Co., LTD
187 A FLAT TV 21" 800,000 A FLAT TV 25" 1,500,000 - < B > () #.# == "B"... B 100,000 B V 180, < C > () #.# == "C"... C 500 C :. FORCS Co., LTD 187
188 OZ Query Designer User's Guide UDS. [ ] [ ]., []. 188 FORCS Co., LTD
189 [ ]. []... FORCS Co., LTD 189
190 OZ Query Designer User's Guide Consume Row Comsum Row. 'True'. 'True'.. " ".. [ ]. [] FORCS Co., LTD
191 [], [ ]. FORCS Co., LTD 191
192 OZ Query Designer User's Guide 192 FORCS Co., LTD
193 FORCS Co., LTD 193
194 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
195 ResultSet., UDS UDS.. UDS "API ". FORCS Co., LTD 195
196 OZ Query Designer User's Guide UDS,. [ ]. UDS. UDS.. UDS. Step 1 [ (UDS)] [ ]. 196 FORCS Co., LTD
197 Step 2 [ ]. []. Step 3 [] [ ]. Step 4 [ ]. Step 5 ' '. FORCS Co., LTD 197
198 OZ Query Designer User's Guide. UDS UDS... " ". UDS. [], []. 198 FORCS Co., LTD
199 . :.,. Step 1 [ (UDS)] [ ]. Step 2 [ ] " ",. Step 3 [] [ ]. [ ]. FORCS Co., LTD 199
200 OZ Query Designer User's Guide Step 4 [ ]. Step 5 [ ] ' ' FORCS Co., LTD
201 []. FORCS Co., LTD 201
202 OZ Query Designer User's Guide 202 FORCS Co., LTD
203 FORCS Co., LTD 203
204 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
205 1 Region Sales2000 Sales ROWIDX COLUMN VALUE 0 Region 0 Sales Sales Region 1 Sales Sales Region 2 Sales Sales Region 3 Sales Sales Region 4 Sales Sales FORCS Co., LTD 205
206 OZ Query Designer User's Guide. Step 1 [] [ ]. Step 2 [ ]. 206 FORCS Co., LTD
207 Step 3 ' ' []. Step 4. Step 5 ( ). ROWIDX, COLUMN, VALUE. FORCS Co., LTD 207
208 OZ Query Designer User's Guide 208 FORCS Co., LTD
209 FORCS Co., LTD 209
210 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 FORCS Co., LTD
211 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, 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, cp Cp857 ibm857, ibm-857, cp857, 857, csibm857 Cp858 FORCS Co., LTD 211
212 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, FORCS Co., LTD
213 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, gb , gb , 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_ , ksc , 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 , iso8859-1, latin1, l1, ibm819, ibm-819, cp819, 819, csisolatin1 8859_15, iso , iso_ , iso , ibm923, ibm-923, cp923, 923, latin0, latin9, csisolatin0, csisolatin9 8859_2, iso_8859-2:1987, iso-ir-101, iso_8859-2, iso , iso8859-2, latin2, l2, ibm912, ibm-912, cp912, 912, csisolatin2, 8859_3, iso_8859-3:1988, iso-ir-109, iso_8859-3, iso , iso8859-3, latin3, l3, ibm913, ibm-913, cp913, 913, csisolatin3 8859_4, iso_8859-4:1988, iso-ir-110, iso_8859-4, iso , iso8859-4, latin4, l4, ibm914, ibm-914, cp914, 914, csisolatin4 FORCS Co., LTD 213
214 OZ Query Designer User's Guide ISO8859_5 ISO8859_6 ISO8859_7 ISO8859_8 ISO8859_9 ISO8859_ _5, iso_8859-5:1988, iso-ir-144, iso_8859-5, iso ,iso8859-5, cyrillic, csisolatincyrillic, ibm915, ibm-915, cp915, 915, 8859_6, iso_8859-6:1987, iso-ir-127, iso_8859-6, iso , iso8859-6, ecma-114, asmo-708, arabic, csisolatinarabic, ibm1089, ibm-1089, cp1089, _7, iso_8859-7:1987, iso-ir-126, iso_8859-7, iso , iso8859-7, elot_928, ecma-118, greek, greek8, csisolatingreek, ibm813, ibm-813, cp813, _8, iso_8859-8:1988, iso-ir-138, iso_8859-8, iso , iso8859-8, hebrew, csisolatinhebrew, ibm916, ibm-916, cp916, _9, iso-ir-148, iso_8859-9, iso , iso8859-9, latin5, l5, ibm920, ibm-920, cp920, 920, csisolatin5 8859_13, iso_ , iso , iso , JIS0201 JIS0208 JIS0212 JISAutoDetect Johab KOI8_R MS874 MS932 jis auto detect ksc , 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
215 MacCyrillic MacDingbat MacGreek MacHebrew MacIceland MacRoman MacRomania MacSymbol MacThai MacTurkish MacUkraine SJIS?, pck SingleByte TIS620 UTF8 UTF16 Unicode UnicodeBig UnicodeLittle tis utf-8, unicode-1-1-utf-8 utf-16 unicode unicode-1-1, iso ucs-2, utf-16be, x-utf-16be utf-16le, x-utf-16le FORCS Co., LTD 215
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
More informationuntitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting Started 'OZ
More informationuntitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer
More informationuntitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer
More informationuntitled
Push... 2 Push... 4 Push... 5 Push... 13 Push... 15 1 FORCS Co., LTD A Leader of Enterprise e-business Solution Push (Daemon ), Push Push Observer. Push., Observer. Session. Thread Thread. Observer ID.
More informationuntitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started (ver 5.1) 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting
More informationuntitled
FORCS Co., LTD 1 OZ Enterprise Server Administrator's Guide (for Java) 2 FORCS Co., LTD FORCS Co., LTD 3 OZ Enterprise Server Administrator's Guide (for Java)..,,... 4 FORCS Co., LTD Shell Command Shell
More informationuntitled
FORCS Co., LTD 1 2 FORCS Co., LTD . Publishing Wizard Publishing Wizard Publishing Wizard Publishing Wizard FORCS Co., LTD 3 Publishing Wizard Publidhing Wizard HTML, ASP, JSP. Publishing Wizard [] []
More information10.ppt
: SQL. SQL Plus. JDBC. SQL >> SQL create table : CREATE TABLE ( ( ), ( ),.. ) SQL >> SQL create table : id username dept birth email id username dept birth email CREATE TABLE member ( id NUMBER NOT NULL
More informationConnection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET
135-080 679-4 13 02-3430-1200 1 2 11 2 12 2 2 8 21 Connection 8 22 UniSQLConnection 8 23 8 24 / / 9 3 UniSQL 11 31 OID 11 311 11 312 14 313 16 314 17 32 SET 19 321 20 322 23 323 24 33 GLO 26 331 GLO 26
More informationuntitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Enterprise Server Administrator's Guide (for Java) 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Enterprise
More informationFileMaker 15 ODBC 및 JDBC 설명서
FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker.
More informationFileMaker ODBC 및 JDBC 가이드
FileMaker ODBC JDBC 2004-2019 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker, FileMaker Cloud, FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker,
More informationuntitled
(shared) (integrated) (stored) (operational) (data) : (DBMS) :, (database) :DBMS File & Database - : - : ( : ) - : - : - :, - DB - - -DBMScatalog meta-data -DBMS -DBMS - -DBMS concurrency control E-R,
More informationORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O
Orange for ORACLE V4.0 Installation Guide ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration
More informationuntitled
FORCS Co., LTD 1 OZ Scheduler User's Guide 2 FORCS Co., LTD .,. Manual Getting Started Getting Started Description....... FORCS Co., LTD 3 OZ Scheduler User's Guide API,,. API, UDS, USL, API API... 4 FORCS
More informationuFOCS
1 기 : 기 UF_D_V250_002 기 기 기 품 ufocs 기 v2.5.0 히기기기기기기기기기 기 Manual 기 version 기 3.2 기품 2011.7.29 히기 345-13 1 Tel : 02-857-3051 Fax : 02-3142-0319 : http://www.satu.co.kr 2010 SAT information Co., Ltd. All
More information1217 WebTrafMon II
(1/28) (2/28) (10 Mbps ) Video, Audio. (3/28) 10 ~ 15 ( : telnet, ftp ),, (4/28) UDP/TCP (5/28) centralized environment packet header information analysis network traffic data, capture presentation network
More information<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770>
i ii iii iv v vi 1 2 3 4 가상대학 시스템의 국내외 현황 조사 가상대학 플랫폼 개발 이상적인 가상대학시스템의 미래상 제안 5 웹-기반 가상대학 시스템 전통적인 교수 방법 시간/공간 제약을 극복한 학습동기 부여 교수의 일방적인 내용전달 교수와 학생간의 상호작용 동료 학생들 간의 상호작용 가상대학 운영 공지사항,강의록 자료실, 메모 질의응답,
More informationuntitled
PowerBuilder 連 Microsoft SQL Server database PB10.0 PB9.0 若 Microsoft SQL Server 料 database Profile MSS 料 (Microsoft SQL Server database interface) 行了 PB10.0 了 Sybase 不 Microsoft 料 了 SQL Server 料 PB10.0
More informationPCServerMgmt7
Web Windows NT/2000 Server DP&NM Lab 1 Contents 2 Windows NT Service Provider Management Application Web UI 3 . PC,, Client/Server Network 4 (1),,, PC Mainframe PC Backbone Server TCP/IP DCS PLC Network
More informationChap7.PDF
Chapter 7 The SUN Intranet Data Warehouse: Architecture and Tools All rights reserved 1 Intranet Data Warehouse : Distributed Networking Computing Peer-to-peer Peer-to-peer:,. C/S Microsoft ActiveX DCOM(Distributed
More informationOPCTalk for Hitachi Ethernet 1 2. Path. DCOMwindow NT/2000 network server. Winsock update win95. . . 3 Excel CSV. Update Background Thread Client Command Queue Size Client Dynamic Scan Block Block
More informationuntitled
FORCS Co., LTD 1 2 FORCS Co., LTD FORCS Co., LTD 3 4 FORCS Co., LTD FORCS Co., LTD 5 ..,,..... 6 FORCS Co., LTD ,. Shell Command, Shell Command.,. Getting Started....,.. FORCS Co., LTD 7 WAS API, OZC,
More informationuntitled
OZ User Data Store Manual... 6 UDS... 6 JDBC UDS... 12 Connection UDS... 17 Connection UDS... 23 DataAction... 31 DataAction... 31 - DataAction... 46... 68 HttpRequest... 76 ResultSet... 83 OZ User Data
More information초보자를 위한 ADO 21일 완성
ADO 21, 21 Sams Teach Yourself ADO 2.5 in 21 Days., 21., 2 1 ADO., ADO.? ADO 21 (VB, VBA, VB ), ADO. 3 (Week). 1, 2, COM+ 3.. HTML,. 3 (week), ADO. 24 1 - ADO OLE DB SQL, UDA(Universal Data Access) ADO.,,
More informationNoSQL
MongoDB Daum Communications NoSQL Using Java Java VM, GC Low Scalability Using C Write speed Auto Sharding High Scalability Using Erlang Read/Update MapReduce R/U MR Cassandra Good Very Good MongoDB Good
More informationUser's Guide Manual
1. 롯데 통합구매 시스템 사용자 매뉴얼 (공급사용) 2006.01-1 - 문서 이력(Revision History) Date Version Description Author(s) 2006/01 V1.0 사용자 매뉴얼 - 공급사용 롯데CFD 주) 이 사용자 안내서의 내용과 롯데 통합구매 시스템은 저작권법과 컴퓨터 프로그램 보호법으로 보호 받고 있으며, 롯데CFD의
More information오늘날의 기업들은 24시간 365일 멈추지 않고 돌아간다. 그리고 이러한 기업들을 위해서 업무와 관련 된 중요한 문서들은 언제 어디서라도 항상 접근하여 활용이 가능해야 한다. 끊임없이 변화하는 기업들 의 경쟁 속에서 기업내의 중요 문서의 효율적인 관리와 활용 방안은 이
C Cover Story 05 Simple. Secure. Everywhere. 문서관리 혁신의 출발점, Oracle Documents Cloud Service 최근 문서 관리 시스템의 경우 커다란 비용 투자 없이 효율적으로 문서를 관리하기 위한 기업들의 요구는 지속적으로 증가하고 있다. 이를 위해, 기업 컨텐츠 관리 솔루션 부분을 선도하는 오라클은 문서관리
More information13주-14주proc.PDF
12 : Pro*C/C++ 1 2 Embeded SQL 3 PRO *C 31 C/C++ PRO *C NOT! NOT AND && AND OR OR EQUAL == = SQL,,, Embeded SQL SQL 32 Pro*C C SQL Pro*C C, C Pro*C, C C 321, C char : char[n] : n int, short, long : float
More informationuntitled
OZ User Data Store Manual OZ User Data Store Manual,,,,, DataAction,, Http Request.. DLL DLL lib launch.cfg. // lib OZUDSSample_Csharp.dll, OZUDSSample_VBNET.dll lib. // config assembly.properties OZUDSSample_Csharp.dll,
More informationDBMS & SQL Server Installation Database Laboratory
DBMS & 조교 _ 최윤영 } 데이터베이스연구실 (1314 호 ) } 문의사항은 cyy@hallym.ac.kr } 과제제출은 dbcyy1@gmail.com } 수업공지사항및자료는모두홈페이지에서확인 } dblab.hallym.ac.kr } 홈페이지 ID: 학번 } 홈페이지 PW:s123 2 차례 } } 설치전점검사항 } 설치단계별설명 3 Hallym Univ.
More informationRemote UI Guide
Remote UI KOR Remote UI Remote UI PDF Adobe Reader/Adobe Acrobat Reader. Adobe Reader/Adobe Acrobat Reader Adobe Systems Incorporated.. Canon. Remote UI GIF Adobe Systems Incorporated Photoshop. ..........................................................
More informationFileMaker ODBC and JDBC Guide
FileMaker 13 5 5 5 6 6 6 7 7 8 8 8 8 9 9 10 10 11 11 12 12 12 12 12 12 13 13 14 14 16 16 18 4 19 19 20 20 21 21 21 23 23 23 23 25 26 26 26 26 27 28 28 28 28 29 31 31 32 33 33 33 33 34 34 35 35 35 36 1
More informationInterstage5 SOAP서비스 설정 가이드
Interstage 5 Application Server ( Solaris ) SOAP Service Internet Sample Test SOAP Server Application SOAP Client Application CORBA/SOAP Server Gateway CORBA/SOAP Gateway Client INTERSTAGE SOAP Service
More information8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 )
8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) - DDL(Data Definition Language) : show, create, drop
More informationchapter1,2.doc
JavaServer Pages Version 08-alpha copyright2001 B l u e N o t e all rights reserved http://jspboolpaecom vesion08-alpha, UML (?) part1part2 Part1 part2 part1 JSP Chapter2 ( ) Part 1 chapter 1 JavaServer
More informationDocsPin_Korean.pages
Unity Localize Script Service, Page 1 Unity Localize Script Service Introduction Application Game. Unity. Google Drive Unity.. Application Game. -? ( ) -? -?.. 준비사항 Google Drive. Google Drive.,.. - Google
More informationthesis
( Design and Implementation of a Generalized Management Information Repository Service for Network and System Management ) ssp@nile nile.postech.ac..ac.kr DPE Lab. 1997 12 16 GMIRS GMIRS GMIRS prototype
More informationMicrosoft PowerPoint - 10Àå.ppt
10 장. DB 서버구축및운영 DBMS 의개념과용어를익힌다. 간단한 SQL 문법을학습한다. MySQL 서버를설치 / 운영한다. 관련용어 데이터 : 자료 테이블 : 데이터를표형식으로표현 레코드 : 테이블의행 필드또는컬럼 : 테이블의열 필드명 : 각필드의이름 데이터타입 : 각필드에입력할값의형식 학번이름주소연락처 관련용어 DB : 테이블의집합 DBMS : DB 들을관리하는소프트웨어
More information. PC DP-1VR P15 1ch 1 Input Tool 4ch RS-232C RS-232C. Input Tool P14 MUX-10F P16 MeasureReport P21 GO/NG 2 MeasurLink Real-Time P19 MeasurLink STATMea
12 Input Tool ( ) 14 DP-1VR 15-10F 16 3 17 EC 17 MeasurLink 18 MeasureReport 21 SPC 22 11 . PC DP-1VR P15 1ch 1 Input Tool 4ch RS-232C RS-232C. Input Tool P14 MUX-10F P16 MeasureReport P21 GO/NG 2 MeasurLink
More informationAnalytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras
Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Crash Unity SDK... Log & Crash Search. - Unity3D v4.0 ios
More informationOZ-LMS TM OZ-LMS 2008 OZ-LMS 2006 OZ-LMS Lite Best IT Serviece Provider OZNET KOREA Management Philosophy & Vision Introduction OZNETKOREA IT Mission Core Values KH IT ERP Web Solution IT SW 2000 4 3 508-2
More information歯sql_tuning2
SQL Tuning (2) SQL SQL SQL Tuning ROW(1) ROW(2) ROW(n) update ROW(2) at time 1 & Uncommitted update ROW(2) at time 2 SQLDBA> @ UTLLOCKT WAITING_SESSION TYPE MODE_REQUESTED MODE_HELD LOCK_ID1
More informationMySQL-Ch10
10 Chapter.,,.,, MySQL. MySQL mysqld MySQL.,. MySQL. MySQL....,.,..,,.,. UNIX, MySQL. mysqladm mysqlgrp. MySQL 608 MySQL(2/e) Chapter 10 MySQL. 10.1 (,, ). UNIX MySQL, /usr/local/mysql/var, /usr/local/mysql/data,
More informationuntitled
OZ Framework Manual OZ Framework... 2 POST... 3 DataModule POST... 3 FXDataModule POST Custom... 5 Servlet API (for OZ Java Server)... 12 DataModuleFactory... 12 DataModule... 13 FXDataModule... 19 Servlet
More informationuntitled
OZ Framework Manual OZ Framework... 2 POST... 3 DataModule POST... 3 FXDataModule POST Custom... 5 Servlet API (for OZ Java Server)... 12 DataModuleFactory... 12 DataModule... 13 FXDataModule... 19...
More information<목 차 > 제 1장 일반사항 4 I.사업의 개요 4 1.사업명 4 2.사업의 목적 4 3.입찰 방식 4 4.입찰 참가 자격 4 5.사업 및 계약 기간 5 6.추진 일정 6 7.사업 범위 및 내용 6 II.사업시행 주요 요건 8 1.사업시행 조건 8 2.계약보증 9 3
열차운행정보 승무원 확인시스템 구축 제 안 요 청 서 2014.6. 제 1장 일반사항 4 I.사업의 개요 4 1.사업명 4 2.사업의 목적 4 3.입찰 방식 4 4.입찰 참가 자격 4 5.사업 및 계약 기간 5 6.추진 일정 6 7.사업 범위 및 내용 6 II.사업시행 주요 요건 8 1.사업시행 조건 8 2.계약보증 9 3.시운전 및 하자보증 10
More information목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate
ALTIBASE HDB 6.1.1.5.6 Patch Notes 목차 BUG-39240 offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG-41443 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate 한뒤, hash partition
More informationCLX8380_KR.book
이 사용설명서와 제품은 저작권법에 의해 보호되어 있습니다. 삼성전자 ( 주 ) 의 사전 서면 동의 없이 사용설명서 및 제품의 일부 또는 전체를 복사, 복제, 번역 또는 전자매체나 기계가 읽을 수 있는 형태로 바꿀 수 없습니다. 이 사용설명서와 제품은 표기상의 잘못이나 기술적인 잘못이 있을 수 있으며 사전 통보 없이 이러한 내용들이 변경될 수 있습니다. CLX-8380ND,
More informationPowerPoint 프레젠테이션
Synergy EDMS www.comtrue.com opyright 2001 ComTrue Technologies. All right reserved. - 1 opyright 2001 ComTrue Technologies. All right reserved. - 2 opyright 2001 ComTrue Technologies. All right reserved.
More informationSK IoT IoT SK IoT onem2m OIC IoT onem2m LG IoT SK IoT KAIST NCSoft Yo Studio tidev kr 5 SK IoT DMB SK IoT A M LG SDS 6 OS API 7 ios API API BaaS Backend as a Service IoT IoT ThingPlug SK IoT SK M2M M2M
More information3장
C H A P T E R 03 CHAPTER 03 03-01 03-01-01 Win m1 f1 e4 e5 e6 o8 Mac m1 f1 s1.2 o8 Linux m1 f1 k3 o8 AJAX
More information3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT
3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT NOT NULL, FOREIGN KEY (parent_id) REFERENCES Comments(comment_id)
More informationPowerPoint 프레젠테이션
@ Lesson 2... ( ). ( ). @ vs. logic data method variable behavior attribute method field Flow (Type), ( ) member @ () : C program Method A ( ) Method B ( ) Method C () program : Java, C++, C# data @ Program
More informationPowerPoint Presentation
FORENSICINSIGHT SEMINAR SQLite Recovery zurum herosdfrc@google.co.kr Contents 1. SQLite! 2. SQLite 구조 3. 레코드의삭제 4. 삭제된영역추적 5. 레코드복원기법 forensicinsight.org Page 2 / 22 SQLite! - What is.. - and why? forensicinsight.org
More informationthesis
CORBA TMN Surveillance System DPNM Lab, GSIT, POSTECH Email: mnd@postech.ac.kr Contents Motivation & Goal Related Work CORBA TMN Surveillance System Implementation Conclusion & Future Work 2 Motivation
More informationOracle Database 10g: Self-Managing Database DB TSC
Oracle Database 10g: Self-Managing Database DB TSC Agenda Overview System Resource Application & SQL Storage Space Backup & Recovery ½ Cost ? 6% 12 % 6% 6% 55% : IOUG 2001 DBA Survey ? 6% & 12 % 6% 6%
More informationMicrosoft PowerPoint - web-part03-ch19-node.js기본.pptx
과목명: 웹프로그래밍응용 교재: 모던웹을 위한 JavaScript Jquery 입문, 한빛미디어 Part3. Ajax Ch19. node.js 기본 2014년 1학기 Professor Seung-Hoon Choi 19 node.js 기본 이 책에서는 서버 구현 시 node.js 를 사용함 자바스크립트로 서버를 개발 다른서버구현기술 ASP.NET, ASP.NET
More information제목 레이아웃
웹해킹이라고무시하는것들보소 2017.07.10 RUBIYA805[AT]GMAIL[DOT]COM SQL Injection 끝나지않은위협 2017.07.10 RUBIYA805[AT]GMAIL[DOT]COM Who am I 정도원 aka rubiya Penetration tester Web application bughuter Pwned 20+ wargame @kr_rubiya
More informationMySQL-Ch05
MySQL P A R T 2 Chapter 05 Chapter 06 Chapter 07 Chapter 08 05 Chapter MySQL MySQL. (, C, Perl, PHP),. 5.1 MySQL., mysqldump, mysqlimport, mysqladmin, mysql. MySQL. mysql,. SQL. MySQL... MySQL ( ). MySQL,.
More informationCopyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper
Windows Netra Blade X3-2B( Sun Netra X6270 M3 Blade) : E37790 01 2012 9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs,
More information1
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 WAS WebSphere SilverStream Apache Jserv Tomcat Resin Inprise Application Server BES Oracel OC4J(ORION) HPAS(Bluestone)8 JRun EAServer JEUS 3.0
More information@OneToOne(cascade = = "addr_id") private Addr addr; public Emp(String ename, Addr addr) { this.ename = ename; this.a
1 대 1 단방향, 주테이블에외래키실습 http://ojcedu.com, http://ojc.asia STS -> Spring Stater Project name : onetoone-1 SQL : JPA, MySQL 선택 http://ojc.asia/bbs/board.php?bo_table=lecspring&wr_id=524 ( 마리아 DB 설치는위 URL
More informationSQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자
SQL Developer Connect to TimesTen 유니원아이앤씨 DB 팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 2010-07-28 작성자 김학준 최종수정일 2010-07-28 문서번호 20100728_01_khj 재개정이력 일자내용수정인버전
More informationJ2EE Concepts
! Introduction to J2EE (1) - J2EE Servlet/JSP/JDBC iseminar.. 1544-3355 ( ) iseminar Chat. 1 Who Are We? Business Solutions Consultant Oracle Application Server 10g Business Solutions Consultant Oracle10g
More informationuntitled
1-2 1-3 1-4 Internet 1 2 DB Server Learning Management System Web Server (Win2003,IIS) VOD Server (Win2003) WEB Server Broadcasting Server 1-5 1-6 MS Internet Information Server(IIS) Web MS-SQL DB ( )
More information교육2 ? 그림
Interstage 5 Apworks EJB Application Internet Revision History Edition Date Author Reviewed by Remarks 1 2002/10/11 2 2003/05/19 3 2003/06/18 EJB 4 2003/09/25 Apworks5.1 [ Stateless Session Bean ] ApworksJava,
More informationETL_project_best_practice1.ppt
ETL ETL Data,., Data Warehouse DataData Warehouse ETL tool/system: ETL, ETL Process Data Warehouse Platform Database, Access Method Data Source Data Operational Data Near Real-Time Data Modeling Refresh/Replication
More informationJ2EE & Web Services iSeminar
9iAS :, 2002 8 21 OC4J Oracle J2EE (ECperf) JDeveloper : OLTP : Oracle : SMS (Short Message Service) Collaboration Suite Platform Email Developer Suite Portal Java BI XML Forms Reports Collaboration Suite
More informationI T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r
I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r Jakarta is a Project of the Apache
More informationData Sync Manager(DSM) Example Guide Data Sync Manager (DSM) Example Guide DSM Copyright 2003 Ari System, Inc. All Rights reserved. Data Sync Manager
Data Sync Manager (DSM) Example Guide DSM Copyright 2003 Ari System, Inc. All Rights reserved. Data Sync Manager are trademarks or registered trademarks of Ari System, Inc. 1 Table of Contents Chapter1
More information강의 개요
DDL TABLE 을만들자 웹데이터베이스 TABLE 자료가저장되는공간 문자자료의경우 DB 생성시지정한 Character Set 대로저장 Table 생성시 Table 의구조를결정짓는열속성지정 열 (Clumn, Attribute) 은이름과자료형을갖는다. 자료형 : http://dev.mysql.cm/dc/refman/5.1/en/data-types.html TABLE
More information<49534F20323030303020C0CEC1F520BBE7C8C4BDC9BBE720C4C1BCB3C6C320B9D7204954534D20BDC3BDBAC5DB20B0EDB5B5C8AD20C1A6BEC8BFE4C3BBBCAD2E687770>
ISO 20000 인증 사후심사 컨설팅 및 ITSM 시스템 고도화를 위한 제 안 요 청 서 2008. 6. 한 국 학 술 진 흥 재 단 이 자료는 한국학술진흥재단 제안서 작성이외의 목적으로 복제, 전달 및 사용을 금함 목 차 Ⅰ. 사업개요 1 1. 사업명 1 2. 추진배경 1 3. 목적 1 4. 사업내용 2 5. 기대효과 2 Ⅱ. 사업추진계획 4 1. 추진체계
More informationTITLE
CSED421 Database Systems Lab MySQL Basic Syntax SQL DML & DDL Data Manipulation Language SELECT UPDATE DELETE INSERT INTO Data Definition Language CREATE DATABASE ALTER DATABASE CREATE TABLE ALTER TABLE
More informationInterstage4 설치가이드
Interstage Application Server V501 Operation Guide Internet 1 1 1 FJApache FJApache (WWW (WWW server) server) - - file file - - 2 2 InfoProviderPro InfoProviderPro (WWW (WWW server) server) - - file file
More information단계
본문서에서는 Tibero RDBMS 에서제공하는 Oracle DB Link 를위한 gateway 설치및설정방법과 Oracle DB Link 사용법을소개한다. Contents 1. TIBERO TO ORACLE DB LINK 개요... 3 1.1. GATEWAY 란... 3 1.2. ORACLE GATEWAY... 3 1.3. GATEWAY 디렉터리구조...
More information안전을 위한 주의사항 제품을 올바르게 사용하여 위험이나 재산상의 피해를 미리 막기 위한 내용이므로 반드시 지켜 주시기 바랍니다. 2 경고 설치 관련 지시사항을 위반했을 때 심각한 상해가 발생하거나 사망에 이를 가능성이 있는 경우 설치하기 전에 반드시 본 기기의 전원을
Digital Video Recorder 간편설명서 XD3316 안전을 위한 주의사항 제품을 올바르게 사용하여 위험이나 재산상의 피해를 미리 막기 위한 내용이므로 반드시 지켜 주시기 바랍니다. 2 경고 설치 관련 지시사항을 위반했을 때 심각한 상해가 발생하거나 사망에 이를 가능성이 있는 경우 설치하기 전에 반드시 본 기기의 전원을 차단하고, 전원 플러그를 동시에
More information초보자를 위한 C++
C++. 24,,,,, C++ C++.,..,., ( ). /. ( 4 ) ( ).. C++., C++ C++. C++., 24 C++. C? C++ C C, C++ (Stroustrup) C++, C C++. C. C 24.,. C. C+ +?. X C++.. COBOL COBOL COBOL., C++. Java C# C++, C++. C++. Java C#
More informationNo Slide Title
J2EE J2EE(Java 2 Enterprise Edition) (Web Services) :,, SOAP: Simple Object Access Protocol WSDL: Web Service Description Language UDDI: Universal Discovery, Description & Integration 4. (XML Protocol
More information02 C h a p t e r Java
02 C h a p t e r Java Bioinformatics in J a va,, 2 1,,,, C++, Python, (Java),,, (http://wwwbiojavaorg),, 13, 3D GUI,,, (Java programming language) (Sun Microsystems) 1995 1990 (green project) TV 22 CHAPTER
More information1. Windows 설치 (Client 설치 ) 원하는위치에다운받은발송클라이언트압축파일을해제합니다. Step 2. /conf/config.xml 파일수정 conf 폴더에서 config.xml 파일을텍스트에디터를이용하여 Open 합니다. config.xml 파일에서, 아
LG U+ SMS/MMS 통합클라이언트 LG U+ SMS/MMS Client Simple Install Manual LG U+ SMS/MMS 통합클라이언트 - 1 - 간단설치매뉴얼 1. Windows 설치 (Client 설치 ) 원하는위치에다운받은발송클라이언트압축파일을해제합니다. Step 2. /conf/config.xml 파일수정 conf 폴더에서 config.xml
More information<32303132B3E2C1A632C8B8BFF6B5E531B1DE42C7FC2E687770>
국 가 기 술 자 격 검 정 무 단 전 재 금 함 형별 제한 시간 수험번호 성 명 다음 문제를 읽고 가장 알맞은 것을 골라 답안카드의 답란 (1, 2, 3, 4)에 표기하시오 워드프로세싱 용어 및 기능 1. 다음 중 워드프로세서의 입력 기능에 대한 설명으로 옳지 1 행두 금칙 문자로는 (, [,,< 등이 있다. 2 KS X 1001 완성형 한글
More information14-Servlet
JAVA Programming Language Servlet (GenericServlet) HTTP (HttpServlet) 2 (1)? CGI 3 (2) http://jakarta.apache.org JSDK(Java Servlet Development Kit) 4 (3) CGI CGI(Common Gateway Interface) /,,, Client Server
More information목차 006/ 008/ 009/ 011/ 012/ 013/ 014/ Part 1_ 컴퓨터가 제대로 작동하지 않을 때 문제00_ 윈도우7 복구(초기화) 방법 안내 문제01_ 컴퓨터의 전원 버튼을 눌러도 아무 반응이 없어요. 문제02_ 전원을 누르면 팬(쿨러)이 돌아가는
컴퓨터 유지관리 Q&A www.npoit.kr 이 www.fb.com/npoitcenter 책은 컴퓨터를 사용하며 자주 발생하는 문제에 대한 설명 npoit@npoit.kr 및 해결 방법을 담고 있습니다. 컴퓨터를 070-4241-8883 관리할 때 필요한 기초 상식들도 함께 있습니다. 목차 006/ 008/ 009/ 011/ 012/ 013/ 014/ Part
More informationwp1_120616.hwp
1과목 : 워드프로세싱 용어 및 기능 1. 다음 중 문서의 효력 발생에 대한 견해로 우리나라에서 채택하 고 있는 1 표백주의 2 발신주의 3 도달주의 4 요지주의 2. 다음 중 워드프로세서의 표시기능에 대한 설명으로 옳은 1 포인트는 화면을 구성하는 최소 단위로 1포인트는 보통 0.5mm이다. 2 자간이란 문자와 문자 사이의 간격을 의미하며 자간을 조절 하여
More information목차 1. 제품 소개... 4 1.1 특징... 4 1.2 개요... 4 1.3 Function table... 5 2. 기능 소개... 6 2.1 Copy... 6 2.2 Compare... 6 2.3 Copy & Compare... 6 2.4 Erase... 6 2
유영테크닉스( 주) 사용자 설명서 HDD014/034 IDE & SATA Hard Drive Duplicator 유 영 테 크 닉 스 ( 주) (032)670-7880 www.yooyoung-tech.com 목차 1. 제품 소개... 4 1.1 특징... 4 1.2 개요... 4 1.3 Function table... 5 2. 기능 소개... 6 2.1 Copy...
More information제목을 입력하세요.
1. 4 1.1. SQLGate for Oracle? 4 1.2. 4 1.3. 5 1.4. 7 2. SQLGate for Oracle 9 2.1. 9 2.2. 10 2.3. 10 2.4. 13 3. SQLGate for Oracle 15 3.1. Connection 15 Connect 15 Multi Connect 17 Disconnect 18 3.2. Query
More information슬라이드 1
NeoDeveloper 설치가이드 차례 1. 환경 3 2. 설치 3 2.1 웹서버설치 3 Tomcat 7 3 JDK 1.6 3 2.2 NeoDeveloper 설치 3 Neo Developer 서버구성 3 Demo용 User Application 구성 4 Neo Developer 서버 Data File 4 Client 개발 Tool 설치 4 3. 설정 5 3.1
More informationODS-FM1
OPTICAL DISC ARCHIVE FILE MANAGER ODS-FM1 INSTALLATION GUIDE [Korean] 1st Edition (Revised 4) 상표 Microsoft, Windows 및 Internet Explorer는 미국 및 / 또는 다른 국가에서 Microsoft Corporation 의 등록 상표입 Intel 및 Intel Core
More information다음 사항을 꼭 확인하세요! 도움말 안내 - 본 도움말에는 iodd2511 조작방법 및 활용법이 적혀 있습니다. - 본 제품 사용 전에 안전을 위한 주의사항 을 반드시 숙지하십시오. - 문제가 발생하면 문제해결 을 참조하십시오. 중요한 Data 는 항상 백업 하십시오.
메 뉴 다음 사항을 꼭 확인하세요! --------------------------------- 2p 안전을 위한 주의 사항 --------------------------------- 3p 구성품 --------------------------------- 4p 각 부분의 명칭 --------------------------------- 5p 제품의 규격
More informationPWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (
PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (http://ddns.hanwha-security.com) Step 1~5. Step, PC, DVR Step 1. Cable Step
More informationuntitled
Memory leak Resource 力 金 3-tier 見 Out of Memory( 不 ) Memory leak( 漏 ) 狀 Application Server Crash 理 Server 狀 Crash 類 JVM 說 例 行說 說 Memory leak Resource Out of Memory Memory leak Out of Memory 不論 Java heap
More information[ 목차 ] 5.1 데이터베이스프로그래밍개념 5.2 T-SQL T-SQL 문법 5.3 JAVA 프로그래밍 2
5 장 SQL 응용 데이터베이스실험실 1 [ 목차 ] 5.1 데이터베이스프로그래밍개념 5.2 T-SQL 5.2.1 T-SQL 문법 5.3 JAVA 프로그래밍 2 5.1 데이터베이스프로그래밍개념 프로그래밍 이라고하면프로그램소스를설계하고, 작성하고, 디버깅하는과정을말한다. 프로그램 혹은소프트웨어는컴퓨터에서주어진작업을하는명령어나열을말한다. 데이터베이스프로그래밍은명확한정의는없지만데이터베이스에데이터를정의하고,
More informationWindows 네트워크 사용 설명서
Windows 네트워크 사용 설명서 (Wireless Manager mobile edition 5.5) 그림의 예로 사용된 프로젝터는 PT-FW300NTEA 입니다. 한국어 TQBH0205-5 (K) 목차 소프트웨어 라이센스 계약 3 무선 연결 사용 시 참고 사항 4 보안 관련 참고 사항 6 소프트웨어 요구 사항 12 시스템 요구 사항 12 Wireless
More informationIntro to Servlet, EJB, JSP, WS
! Introduction to J2EE (2) - EJB, Web Services J2EE iseminar.. 1544-3355 ( ) iseminar Chat. 1 Who Are We? Business Solutions Consultant Oracle Application Server 10g Business Solutions Consultant Oracle10g
More informationPowerPoint 프레젠테이션
Web Browser Web Server ( ) MS Explorer 5.0 WEB Server MS-SQL HTML Image Multimedia IIS Application Web Server ASP ASP platform Admin Web Based ASP Platform Manager Any Platform ASP : Application Service
More informationPowerPoint 프레젠테이션
1 2 3 4 5 6-2- - - - - - -3- -4- ( Knowledge Cube, Inc. ) // www.kcube.co.kr -5- -6- (KM)? - Knowledge Cube, Inc. - - Peter Drucker - -7- KM Context KM Context KM Context KM Context KM Context KM KM KM
More informationhd1300_k_v1r2_Final_.PDF
Starter's Kit for HelloDevice 1300 Version 11 1 2 1 2 3 31 32 33 34 35 36 4 41 42 43 5 51 52 6 61 62 Appendix A (cross-over) IP 3 Starter's Kit for HelloDevice 1300 1 HelloDevice 1300 Starter's Kit HelloDevice
More information