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 ,. Manual Getting Started Getting Started Description 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% %OZQ_HOME% bin %OZQ_HOME% bin/res %OZQ_HOME% bin/soap Console.txt dbconfig.xml dbconfig.xsd OZQueryDesigner.exe OZRepositoryManager.ini OZUSLClientDes128.dll OZUSLClientSession.dll user.cif MultiLanguageList.xml QDJavaScriptConfig.xml qd.dll qd_error_msg.xml rm.dll rm_error_msg.xml server_error_msg.xml mssoap1.dll MSSOAP30.dll SOAPIS30.dll WHSC30.dll WISC10.dll WISC30.dll register_soap.bat unregister_soap.bat DB USL SOAP SOAP SOAP FORCS Co., LTD 13
14 OZ Query Designer User's Guide %OZQ_HOME% bin/soap/reso urces %OZQ_HOME% config %OZQ_HOME% doc %OZQ_HOME% lib SOAP assembly.properties launch.cfg LayoutConfig.xml OZOpenHistory.xml OZServerList.xml QDConfig.ini XMLDesignerConfig.xml xml.properties OZQueryAPI.chm activation.jar mail.jar crimson.jar dtdparser120.jar jcert.jar jnet.jar jsse.jar jsr173_api.jar log4j.jar ozsfw50.jar parser.jar xerces.jar dom4j jar jaxen jar xalan.jar xercesimpl.jar xml-apis.jar soap2_3_1.jar jazzlib.jar XML XML ) OZQueryAPI_ko_kr.chm XML DTD J2EE (HTTPS/SSL ) JRE 1.3.X HTTP XML Log XML XML XPath SOAP 14 FORCS Co., LTD
15 %OZA_HOME% license UniversalDriver js.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 sqljdbc.jar mysql5.1.5.jar unisqljdbc10.jar unsqljdbc205.zip Java Script 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 MSSQL 2008 JDBC Mysql JDBC UniSQL JDBC : JDBC "UniversalDriver" JDBC, RDB JDBC. RDB JDBC. FORCS Co., LTD 15
![OZ Query Designer User's Guide [] [OZ XStudio 5.](/docs-images/99/139027040/images/16-0.jpg "0] [OZ Query Designer 5.0] 'OZ Query Designer 5.0'.")
16 OZ Query Designer User's Guide [] [OZ XStudio 5.0] [OZ Query Designer 5.0] 'OZ Query Designer 5.0'.. 16 FORCS Co., LTD
17 . config launch.cfg. launch.cfg. CLASSPATH =.\lib\ozsfw50.jar;.\lib\log4j.jar;.\lib\xalan.jar;.\lib\xercesimpl.jar;.\lib\xmlapis.jar;.\lib\parser.jar;.\lib\xerces.jar;.\lib\dtdparser120.jar;.\lib\jcert.jar;.\lib\jnet.jar;.\lib\jsse.jar;.\lib\jazzlib.jar;.\lib\js.jar;.\lib\soap2_3_1.jar;.\lib\activation.jar;.\ lib\mail.jar;.\universaldriver\classes12.zip;.\universaldriver\db2java.zip;.\universal Driver\ifxjdbc.jar;.\UniversalDriver\jconn2.jar;.\UniversalDriver\msbase.jar;.\Univer saldriver\mssqlserver.jar;.\universaldriver\msutil.jar;.\universaldriver\mysql5.1.5.j ar;.\universaldriver\unisqljdbc10.jar;.\lib\jsr173_api.jar;.\lib\stax jar;.\lib\dom4j jar;.\lib\jaxen jar JRE_PATH =..\jre\bin\hotspot\jvm.dll JDBC CLASSPATH. JDBC lib JDBC launch.cfg. FORCS Co., LTD 17
18 OZ Query Designer User's Guide JDBC ODI. ODI. ( JDBC JDBC.) : Java Java launch.cfg Java. "-" Java, Java "-" launch.cfg. Java launch.cfg. CLASSPATH =.\lib\ozsfw50.jar;.\lib\log4j.jar;.\lib\xalan.jar;.\lib\xercesimpl.jar;.\li b\xml-apis.jar;.\lib\parser.jar;.\lib\xerces.jar;.\lib\dtdparser120.jar;.\lib\jcert.jar;.\lib\jnet.jar;.\lib\jsse.jar;.\lib\jazzlib.jar;.\lib\js.jar;.\lib\ soap2_3_1.jar;.\lib\activation.jar;.\lib\mail.jar;.\universaldriver\classe s12.zip;.\universaldriver\db2java.zip;.\universaldriver\ifxjdbc.jar;.\un iversaldriver\jconn2.jar;.\universaldriver\msbase.jar;.\universaldriver \mssqlserver.jar;.\universaldriver\msutil.jar;.\universaldriver\mysql jar;.\UniversalDriver\unisqljdbc10.jar;.\lib\jsr173_api.jar;.\lib\stax jar;.\lib\dom4j jar;.\lib\jaxen 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 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),,..... _DEBUG(), _ERROR(), _INFO(). FORCS Co., LTD 21
22 OZ Query Designer User's Guide ODI(OZ Data Info).. // - V5.0 // ODI ODI ODI ODI. Untitled#. - OZProduct.odi - OZProduct.odi - 22 FORCS Co., LTD
![[]. (Ctrl+N) ODI. (Ctrl+O) ODI.](/docs-images/99/139027040/images/23-0.jpg ".. (Ctrl+S). FORCS Co., LTD 23")
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.. [ ]. [ ] ' '. 24 FORCS Co., LTD
25 . ODI.. [ ] ODI.. [ ].,. [] ' ', ' ',. -,,.,. FORCS Co., LTD 25
26 OZ Query Designer User's Guide... : []. : 0 ~ ' '.,. 26 FORCS Co., LTD
27 []. [].. ODI. : 1 ~ 60. FORCS Co., LTD 27
28 OZ Query Designer User's Guide....,.. : "ForceLocal" " ",. ODI OpenType. Local. OZServer. ForceLocal. Force OZServer. 28 FORCS Co., LTD
29 Force OpenType ODI. -, SQL..... SQL FORCS Co., LTD 29
30 OZ Query Designer User's Guide 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. -, 30 FORCS Co., LTD
31 ,,. ODI 4. ODI.. (Ctrl+Z) FORCS Co., LTD 31
![. (Ctrl+C)., [ ].. (Ctrl+V).](/docs-images/99/139027040/images/32-1.jpg ". (Ctrl+F). []. (Ctrl+H). []. (Ctrl+G) 32 FORCS Co.")
32 OZ Query Designer User's Guide. : Undo. (Ctrl+Y),. (Ctrl+X). [].. (Ctrl+C)., [ ].. (Ctrl+V).. (Ctrl+F). []. (Ctrl+H). []. (Ctrl+G) 32 FORCS Co., LTD
![. []. (P)](/docs-images/99/139027040/images/33-0.jpg "ODI.")
33 . []. (P) ODI. (Alt+0). (Alt+1). (Alt+2) FORCS Co., LTD 33
34 OZ Query Designer User's Guide. (Alt+3). (F5). (Ctrl+F5). [ ], ' ' 'True'. [ ] FORCS Co., LTD
35 - (Ctrl+W). - (Ctrl+M).,. 9.,.. FORCS Co., LTD 35
36 OZ Query Designer User's Guide []. /. PC. 36 FORCS Co., LTD
![: PC [PC ] 'PC ' PC](/docs-images/99/139027040/images/37-0.jpg "IP Address, Mac")
37 : PC [PC ] 'PC ' PC IP Address, Mac Address, HDD Serial. [] PC. FORCS Co., LTD 37
38 OZ Query Designer User's Guide,,,,,.,,,, ' ',,,., 38 FORCS Co., LTD
39 ,,,.,,,.,,,,,, FORCS Co., LTD 39
40 OZ Query Designer User's Guide ODI(OZ Data Info),,. UI.. [] ' '. 40 FORCS Co., LTD
![UI..,,,,,,. " " [] []. []. : DB2.](/docs-images/99/139027040/images/41-0.jpg "DB,.,. FORCS Co., LTD 41")
41 UI..,,,,,,. " " [] []. []. : DB2. DB,.,. FORCS Co., LTD 41
42 OZ Query Designer User's Guide., DB2 [] [ ].,.. 42 FORCS Co., LTD
43 . ". - - ". ODI. ". - - ". FORCS Co., LTD 43
44 OZ Query Designer User's Guide. : & [] [] <Ctrl + C>. (, ) 44 FORCS Co., LTD
45 ,,. FORCS Co., LTD 45
46 OZ Query Designer User's Guide.... ODI. 46 FORCS Co., LTD
47 ,...,.. :,, FORCS Co., LTD 47
48 OZ Query Designer User's Guide.,,. <Ctrl + Space> "" <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space>,,.,,...,...,. _DEBUG(), _ERROR(), _INFO(). 48 FORCS Co., LTD
![. -. -. : [ ]. :. _DEBUG(" ") _ERROR(" ") _INFO(" ") DEBUG yyyy-mm-dd hh:mm:ss.sss ex) DEBUG 2008-05-20 20:17:45.](/docs-images/99/139027040/images/49-1.jpg "031 ERROR yyyy-mm-dd hh:mm:ss.sss ex) ERROR 2008-05-20 20:17:45.471 INFO yyyy-mm-dd hh:mm:ss.sss ex) INFO 2008-05-20 20:17:45.")
49 : [ ]. :. _DEBUG(" ") _ERROR(" ") _INFO(" ") DEBUG yyyy-mm-dd hh:mm:ss.sss ex) DEBUG :17: ERROR yyyy-mm-dd hh:mm:ss.sss ex) ERROR :17: INFO yyyy-mm-dd hh:mm:ss.sss ex) INFO :17: FORCS Co., LTD 49
50 OZ Query Designer User's Guide 50 FORCS Co., LTD
51 FORCS Co., LTD 51
52 OZ Query Designer User's Guide.. Repository. Repository.,, C:\Program Files\Forcs\OZ XStudio 5.0\OZ Query Designer 5.0. C:\Program Files\FORCS\OZ Xstudio 5.0\Repository. [ ]. 52 FORCS Co., LTD
![" [ ]".](/docs-images/99/139027040/images/53-0.jpg ". \"C:/Repository\" \"Working")
53 " [ ]".. "C:/Repository" "Working folder1" FORCS Co., LTD 53
![. [ ].](/docs-images/99/139027040/images/54-2.jpg "54 FORCS")
54 OZ Query Designer User's Guide.. [ ]. 54 FORCS Co., LTD
55 ' '. Button Description XML. XML... [ ]..... Option Description. FORCS Co., LTD 55
![. []. " ( ) [](/docs-images/99/139027040/images/56-2.jpg "]\". 56 FORCS")
56 OZ Query Designer User's Guide. : (.). : [].. []. " ( ) [ ]". 56 FORCS Co., LTD
57 .,.,..,.. FORCS Co., LTD 57
58 OZ Query Designer User's Guide [] - [ ] ODI.,,,. <Ctrl + Space>.,,. 58 FORCS Co., LTD
59 ,,, <Tab>.,,.. Icon Description FORCS Co., LTD 59
60 OZ Query Designer User's Guide ".". ".".,,.,,. <Ctrl + Space> "" <Ctrl + Space> "." <Ctrl + Space>,,.,,.. 60 FORCS Co., LTD
61 "." <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space>.,...,. ODI. ODI [ ]. FORCS Co., LTD 61
![,. [ ],](/docs-images/99/139027040/images/62-1.jpg "[ ].. [...],.")
62 OZ Query Designer User's Guide [ ] " ".,. [ ], [ ].. [...],. [] 62 FORCS Co., LTD
63 .,,. ( ), ( ), ( ), ( ), ( ).. FORCS Co., LTD 63
64 OZ Query Designer User's Guide ODI [ ]. [ ]. ( ). 64 FORCS Co., LTD
65 .. ( ).,,, FORCS Co., LTD 65
66 OZ Query Designer User's Guide,. ODI.,. 66 FORCS Co., LTD
67 (db.properties, datasource.properties), HTTP/ XML, CSV. " ". ( ) " ". " " []. FORCS Co., LTD 67
68 OZ Query Designer User's Guide " " (ex. C:\) (ex. C:\),. 68 FORCS Co., LTD
69 ..,... 1), : FORCS Co., LTD 69
70 OZ Query Designer User's Guide 2) /HTTP : XML XML, CSV CSV 3) XML : XML, DTD, XSD 4) SOAP : WSDL "C:\Program Files\Forcs\OZ XStudio 5.0\OZ Query Designer 5.0\bin", "C:\Program Files\Forcs\OZ XStudio 5.0\OZ Query Designer 5.0\db.properties". : ODI /, / ozserver.properties HOME. 70 FORCS Co., LTD
71 "/", "./../aa/../bb". (db.properties, datasource.properties) HOME. URL URL(ozp:///). URL. 1), : 2) /HTTP : XML XML, CSV CSV 3) XML : XML, DTD, XSD 4) SOAP : WSDL conf. FORCS Co., LTD 71
72 OZ Query Designer User's Guide : "ozp://" ODI,. 72 FORCS Co., LTD
73 FORCS Co., LTD 73
74 OZ Query Designer User's Guide,.. HTTP, XML...,. 74 FORCS Co., LTD
75 . (UDS) /HTTP XML SAP CLEAR QUEST 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. IBM Rational Clear Quest DB.,,,.. 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,,,.,,. True ""( ), FORCS Co., LTD
79 False Null Null Data( ), "null" Null Data.. Concurrent '#'. '#' #OZParam.#. ' ' 'True' '#'.., 1byte RDB ^ DB. Byte.. : '0'. :,,.. : " " " ", " ". " Default ". ( ) OZServer Local.. FORCS Co., LTD 79
80 OZ Query Designer User's Guide : "Numeric" "Decimal". DB Default 0. ( ) DB True 0. DB False 0.. ( :False) : 'True'. : " " " ". OpenType Local Default OZServer Local Default OZServer ODI.,,.. :.... :. 80 FORCS Co., LTD
81 OZServer Local Default OZServer Local.. :.. :.. ForceLocal ForceOZServer ForceOpenType.. :. ODI.,,. JDBC ODBC. [ ], [ ] [ ] []. (DB_).. JDBC.. ODBC/JDBC.. FORCS Co., LTD 81
82 OZ Query Designer User's Guide.. db.properties.. (Commit)... API ". RDB Store DataAction".. API ". RDB Store DataAction". //. : JDBC.. Oracle dblink DB2. DB JDBC. JDBC com.setautocommit(false) com.preparedstatement(sqlstr) =false OZ =true (SQL_) FORCS Co., LTD
83 DataAction.. ". // ". DataAction.. ". // ". DataAction.. ". // ".. (Row). : 0 ~ 'True', 'True'.. (JDBC preparedstatement.) : 'True' ". ". :,.. : 'True' ". ".. 'True'.. FORCS Co., LTD 83
84 OZ Query Designer User's Guide Concurrent Concurrent Row //. 'True' //,. : 'True' // ". // ". Byte.. : '0'. :,,.... : '0'. :,,... 'False'. : concurrent.. 'False'. : concurrent.. (DYNAMIC_) 84 FORCS Co., LTD
85 Concurrent Concurrent Row.. (Row). : 0 ~ ROW INDEX. '0' ROW INDEX : 0 ~ 'True'.. Byte.. : '0'. :,,.... : '0'. :,,.. FORCS Co., LTD 85
86 OZ Query Designer User's Guide SQL ( ) ( ). 'True', 'True'.. (JDBC preparedstatement.) : 'True' ". ". :,.. : 'True' ". ".. 'False'. : concurrent.. 'False'. : concurrent.. (SQL_) FORCS Co., LTD
87 . 'True', 'True'.. (JDBC preparedstatement.) : 'True' ". ". :,.. : 'True' ". ". (MULTISET)... ( ). Cursor, (UDS) FORCS Co., LTD 87
88 OZ Query Designer User's Guide (UDS: ) EJB,, Non-DB. UDS "API. ". (CLASS_) UDS. UDS.. (SET_) UDS. UDS UDS. DataAction.. ". // ". DataAction.. ". // ". DataAction.. ". // ".. (Row).. 'True'. 88 FORCS Co., LTD
89 Concurrent Concurrent Row. : 'True' ". ". Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. UDS. UDS.. FORCS Co., LTD 89
90 OZ Query Designer User's Guide,. -. (GROUP_).. (Shadow_) Consume Row Concurrent... Comsum Row. 'True'. 'True'. (Row).. 'True'. Byte.. : '0'. :,,. 90 FORCS Co., LTD
91 Concurrent Row.. : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent XML (FileXML_). FORCS Co., LTD 91
92 OZ Query Designer User's Guide Concurrent Concurrent Row. (Row). XML. XML.. 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. CSV (FileCSV_) 92 FORCS Co., LTD
93 .. (Row).. ( : Concurrent Concurrent Row LINEFEED). "LINEFEED" (\n). ODI CSV "LINEFEED".... 'True'. Byte.. : '0'. :,,... : '0'. :,,,. FORCS Co., LTD 93
94 OZ Query Designer User's Guide. 'False'. : concurrent.. 'False'. : concurrent.. : PGP CSV UDS.... HTTP. HTTP XML (HTTPXML_) Http.. (Row). XML. XML.. 'True'. 94 FORCS Co., LTD
95 Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. HTTP CSV (HTTPCSV_) Http.. (Row). FORCS Co., LTD 95
96 OZ Query Designer User's Guide Concurrent Concurrent Row. ( : LINEFEED). "LINEFEED" (\n). ODI CSV "LINEFEED".... 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent. 96 FORCS Co., LTD
97 .... SOAP. SOAP (SOAPStore_) SOAP. SOAP (SOAPSet_) Concurrent SOAP... 'True'. Byte.. : '0'. :,,. FORCS Co., LTD 97
98 OZ Query Designer User's Guide Concurrent Row XML.. : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent. XML.. SOAP XPath.. XPath.. XML DTD/XSD XML. XML DTD/XSD 98 FORCS Co., LTD
99 XML. XML DTD/XSD (DTDSet_, XSDSet_) Concurrent Concurrent Row XML... 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. FORCS Co., LTD 99
100 OZ Query Designer User's Guide. (Full Name). XML. XML... SAP SAP R/3 RFC(Remote Function Call). SAP ().. SAP. SAP. SAP SAP. SAP SAP FORCS Co., LTD
101 Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent..... FORCS Co., LTD 101
102 OZ Query Designer User's Guide CLEAR QUEST IBM Rational Clear Quest DB. CLEAR QUEST (CQStore_ ) CLEAR QUEST. CLEAR QUEST (CQSet_) Concurrent CLEAR QUEST. CLEAR QUEST.. (Row). : 0 ~ : 'True' ". ".. 'True'. Byte.. : '0'. :,, FORCS Co., LTD
103 Concurrent Row.. : '0'. :,,... 'False'. : concurrent.. 'False'. : concurrent.. CLEAR QUEST FORCS Co., LTD 103
104 OZ Query Designer User's Guide.. Include ODI LocalExplorer ODI Include. Include OZURL Include. URL. ODI OZ URL [Repository Root], [LocalExplorer]. ) ozp://// 104 FORCS Co., LTD
105 ODBC/JDBC.. Step 1 [] [ ]. Step 2 ' '. Step 3 [] "". FORCS Co., LTD 105
106 OZ Query Designer User's Guide ' ', ' SQL', ' SQL'. JDBC, ODBC, OLE DB... IP, Port. ID FORCS Co., LTD
107 DB db.properties DB. DB, DB DB. db.properties. / "Appendix. ". OLE DB. SQL / SQL SQL SQL. SQL SQL SQL. SQL SQL. SQL JDBC SQL SQL. ) INSERT, UPDATE, DELETE FORCS Co., LTD 107
108 OZ Query Designer User's Guide SQL SQL SQL. SQL. SQL. SQL. : SQL. ODBC JDBC,. ODBC ODBC ODBC MS Access, dbase, Foxpro. ODBC. ODBC. 108 FORCS Co., LTD
109 " " " ". " " "odbc". " " "ODBC ". " ", "". " ". JDBC JDBC JDBC MS-SQL, Oracle, Sybase. JDBC " ".. - MS-SQL FORCS Co., LTD 109
110 OZ Query Designer User's Guide " " " ". " " "mssql". " IP ", " ", " " IP,,. " ", "". " ". - Oracle 110 FORCS Co., LTD
111 " " " ". " " "oracle". " IP ", " ", " " IP,, SID. " ", "". " ". - Sybase FORCS Co., LTD 111
112 OZ Query Designer User's Guide " " " ". " " "sysbase". " " Sybase JDBC jconnect 'Tds'. Tds(Tabular Data Stream) Adative Server Sybase. " IP ", " ", " " IP,,. " ", "". " ". - Informix 112 FORCS Co., LTD
113 " " " ". " " "informix". " IP ", " ", " ", " " IP,,,. " ", "". " ". - Uni-SQL FORCS Co., LTD 113
114 OZ Query Designer User's Guide " " " ". " " "unisql". " IP ", " ", " " IP,,,. " ", "". " ". - DB2 114 FORCS Co., LTD
115 " " " ". " " "db2". " IP ", " ", " " IP,,,. " ", "". " ". - User-Definded User-Definded JDBC JDBC Connection URL. FORCS Co., LTD 115
116 OZ Query Designer User's Guide " " " ". " " "user". " ", " URL" JDBC Connection URL. " ", "". " ". OLE DB OLE DB OLE DB MS-SQL, Oracle, Sybase. OLE DB " ".. - MSSQL-OLEDB 116 FORCS Co., LTD
117 " " " ". " " "MSSQL-OLEDB". " IP ", " ", " " IP,,. " ", "". " ". - ORACLE-OLEDB FORCS Co., LTD 117
118 OZ Query Designer User's Guide " " " ". " " "ORACLE-OLEDB". "SID" SID. - SYBASE-OLEDB 118 FORCS Co., LTD
119 " " " ". " " "SYBASE-OLEDB". " ". - DB2-OLEDB FORCS Co., LTD 119
120 OZ Query Designer User's Guide " " " ". " " "DB2-OLEDB". " ". - INFORMIX-OLEDB 120 FORCS Co., LTD
121 " " " ". " " "INFORMIX-OLEDB". " ".. Step 1 'Foodmart' [ ]. FORCS Co., LTD 121
![". Step 3 [].](/docs-images/99/139027040/images/122-2.jpg "Step 4 (). \".")
122 OZ Query Designer User's Guide Step 2 " ". Step 3 []. Step 4 (). ". ". 122 FORCS Co., LTD
123 , SQL.. Step 1 IP,,,. ' ' [ ] ' '. FORCS Co., LTD 123
![OZ Query Designer User's Guide.. (Default).. :.. Step 2 ' ', [].](/docs-images/99/139027040/images/124-0.jpg "'IP', 'PortNo', 'UserName', 'Password',. [] ''. 124 FORCS Co.")
124 OZ Query Designer User's Guide.. (Default).. :.. Step 2 ' ', []. 'IP', 'PortNo', 'UserName', 'Password',. [] ''. 124 FORCS Co., LTD
125 Step 3. '' [ ]. Step 4. FORCS Co., LTD 125
126 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 126 FORCS Co., LTD
127 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).. FORCS Co., LTD 127
128 OZ Query Designer User's Guide : DB UI. 128 FORCS Co., LTD
129 FORCS Co., LTD 129
130 OZ Query Designer User's Guide. RDB... () / / [] [ ].. SQL., SQL. 130 FORCS Co., LTD
![[] - [] - [] ( ).. Step 1 []. :,,.](/docs-images/99/139027040/images/131-0.jpg "Step 2 [] - [ ] ( ) <F5>. []. FORCS Co.")
131 [] - [] - [] ( ).. Step 1 []. :,,. Step 2 [] - [ ] ( ) <F5>. []. FORCS Co., LTD 131
132 OZ Query Designer User's Guide :.. Step FORCS Co., LTD
![[] - [] - [ ] (. ) [],,.](/docs-images/99/139027040/images/133-0.jpg ". Step 1 [] &.., From. FORCS Co.")
133 [] - [] - [ ] (. ) [],,.. Step 1 [] &.., From. FORCS Co., LTD 133
134 OZ Query Designer User's Guide (. ) Step 2.,. ' '. DB Primary, Foreign Key JDBC (Oracle, MS-SQL ) : Primay, Foreign Key DB Primary, Foreign Key JDBC (ODBC ) : 134 FORCS Co., LTD
135 ' ' [] [] ' ' [ ] []. &. [ ]. FORCS Co., LTD 135
136 OZ Query Designer User's Guide ' '. :,.. 9i. <Delete> [ ]. 136 FORCS Co., LTD
137 . Step 3 &. <Shift> <Ctrl>, FORCS Co., LTD 137
138 OZ Query Designer User's Guide <Delete>. Step 4. [] - [ ] [ ]. [ ].,,. ' '. Step 5,. Step FORCS Co., LTD
![: MDB MS-SQL " ex) Car Sales [Car Sales]. ex) 9Sales [9Sales].](/docs-images/99/139027040/images/139-0.jpg "ex) Sales.Sales [Sales].Sales Step 7 [] - [ ] ( ) <F5>. []. FORCS Co.")
139 : MDB MS-SQL " ex) Car Sales [Car Sales]. ex) 9Sales [9Sales]. ex) Sales.Sales [Sales].Sales Step 7 [] - [ ] ( ) <F5>. []. FORCS Co., LTD 139
140 OZ Query Designer User's Guide Step FORCS Co., LTD
![. Step 1 [ ]. Step 2 [Member].](/docs-images/99/139027040/images/141-0.jpg "Step 3 []. FORCS Co., LTD 141")
141 . Step 1 [ ]. Step 2 [Member]. Step 3 []. FORCS Co., LTD 141
142 OZ Query Designer User's Guide : ' ' ' ' ' '. 142 FORCS Co., LTD
![Where. [ ] > >>,. :.. ' ' ' '.](/docs-images/99/139027040/images/143-0.jpg "' ' ' '. FORCS Co., LTD 143")
143 Where. [ ] > >>,. :.. ' ' ' '. ' ' ' '. FORCS Co., LTD 143
144 OZ Query Designer User's Guide < ' '. << ' '., ' '. CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP. : " " True.. ','.. // [ ],. 144 FORCS Co., LTD
145 SQL. SQL SELECT UI.. From.. Select.. Where.. Where.. Group by, Select.. Order by. <Shift> <Ctrl>,... From. FORCS Co., LTD 145
146 OZ Query Designer User's Guide UI >, >> <, <<. ' '. ' '.. '',. ' ' ' ' ' '. ' ' ' '.,. 146 FORCS Co., LTD
![UI > >>,,,.. [].. ' ' ' '. ' ' ' '. < ' '. << ' '.](/docs-images/99/139027040/images/147-0.jpg ", ' '... JDBC SQL (,,,, )..,., ','.. FORCS Co.")
147 UI > >>,,,.. [].. ' ' ' '. ' ' ' '. < ' '. << ' '., ' '... JDBC SQL (,,,, )..,., ','.. FORCS Co., LTD 147
148 OZ Query Designer User's Guide, &.,. " ". SQL Where. UI. 148 FORCS Co., LTD
149 AND / OR /NOT/IN/BETW EEN/ = /<>/( / ) /,... JDBC SQL (,,,, )..,.. SQL Group by. UI. ' '. FORCS Co., LTD 149
150 OZ Query Designer User's Guide ' ' ' ' >. <, << ' '. (Having). (AVG, COUNT, MAX, MIN, SUM) [ ].,. SQL Order by. 150 FORCS Co., LTD
151 UI. ' '. ' ' ' ' >, >>. <, << ' '.,. /,. ' '.. ' ' ' '. FORCS Co., LTD 151
152 OZ Query Designer User's Guide., UDS, XML, CSV,. Step 1 [ ]. Step 2 '' '' []. 152 FORCS Co., LTD
153 UI.. " ". : setfielddata(), setquerystring(),.. /.,. Functions : Mathematics, Sting opr., Database I/O, Date opr., Miscellaneous. Database :. Parameter :. FORCS Co., LTD 153
154 OZ Query Designer User's Guide Step 3 []. : ' '. 154 FORCS Co., LTD
![Step 2 ' ' ODI [], 'Include '.](/docs-images/99/139027040/images/155-1.jpg "'Include ' ODI. Step 3 ODI,, Include.")
155 ODI ODI. Include Step 1 [INCLUDE ODI] []. Step 2 ' ' ODI [], 'Include '. 'Include ' ODI. Step 3 ODI,, Include. Include,, [,, ]. FORCS Co., LTD 155
![Include [ODI ].](/docs-images/99/139027040/images/156-1.jpg "Include, [] Include,,.")
156 OZ Query Designer User's Guide Include Include [ODI ]. Include, [] Include,,. 156 FORCS Co., LTD
157 Include "Include ODI" ODI ODI. ODI ODI. ODI ODI,,. ODI., A.odi B.odi C.odi C.odi A.odi, B.odi. FORCS Co., LTD 157
158 OZ Query Designer User's Guide /. : (MemberGrade) : (Customer) Step FORCS Co., LTD
159 . SELECT customer.member_card FROM customer 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#' FORCS Co., LTD 159
160 OZ Query Designer User's Guide Step 3 (Customer) (MemberGrade). 160 FORCS Co., LTD
161 . MSSQL, SYBASE.. Step 1 " " " " [ ]. Step 2 ' '. FORCS Co., LTD 161
162 OZ Query Designer User's Guide Step 3.. SELECT * FROM sales SELECT * FROM customer Step 3 [] [ ] ( ) <F5> ' '. 162 FORCS Co., LTD
163 ' '. ' ' " _#". ' ' " _#". Step 3 ' ' "SET_NAME",. FORCS Co., LTD 163
![OZ Query Designer User's Guide Step 3 ' ' []... - 1 :.](/docs-images/99/139027040/images/164-0.jpg "SELECT * FROM sales SELECT * FROM customer - 2 :.")
164 OZ Query Designer User's Guide Step 3 ' ' [] :. SELECT * FROM sales SELECT * FROM customer - 2 :. SELECT * FROM sales SELECT * FROM customer 164 FORCS Co., LTD
165 . JDBC Vendor, MSSQL, ORACLE. DB ' ' [].. FORCS Co., LTD 165
166 OZ Query Designer User's Guide..,.. []. 166 FORCS Co., LTD
167 . "#OZParam.#".... null. ( : False). "OZParam". : " " True. FORCS Co., LTD 167
168 OZ Query Designer User's Guide.,. : Cursor..,.... (/// ). Step 1 " " " " [ ]. 168 FORCS Co., LTD
169 Step 23 ' ' [] []. Step 4. FORCS Co., LTD 169
![OZ Query Designer User's Guide Step 5 [] '](/docs-images/99/139027040/images/170-0.jpg "'. Step 6 ' ' \"SET_NAME\",. 170 FORCS Co.")
170 OZ Query Designer User's Guide Step 5 [] ' '. Step 6 ' ' "SET_NAME",. 170 FORCS Co., LTD
![Step 7 ' ' [].](/docs-images/99/139027040/images/171-1.jpg "Step 8 ' ' [] ' ' [].")
171 Step 7 ' ' []. Step 8 ' ' [] ' ' []. FORCS Co., LTD 171
172 OZ Query Designer User's Guide 172 FORCS Co., LTD
173 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); FORCS Co., LTD 173
174 OZ Query Designer User's Guide - 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); 174 FORCS Co., LTD
175 " // " DataAction(Insert, Delete, Update), (UDS). " // ", //. // [ ], [ ], [ ]. [ // ]. FORCS Co., LTD 175
176 OZ Query Designer User's Guide : // (Source Field, Source Value, Destination Field, Destination Value,, ),. - [ ] ' ' ' '. UI > >> Destination Field, Source Field,,. :.. ' ' ' '. ' ' ' '. < ' '. << ' '., ' '. 176 FORCS Co., LTD
![CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP. : " " True.. ','.. // [ ],.](/docs-images/99/139027040/images/177-0.jpg "' ' (, ) ' ' & []. \"ARG_SF\", \"ARG_SV\", \"ARG_DF\", \"ARG_DV\". \"ARG_S_\", \"ARG_D_\". FORCS Co.")
177 CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP. : " " True.. ','.. // [ ],. ' ' (, ) ' ' & []. "ARG_SF", "ARG_SV", "ARG_DF", "ARG_DV". "ARG_S_", "ARG_D_". FORCS Co., LTD 177
![OZ Query Designer User's Guide - " ". " ". [ ] [] //. // // " " " ". // -. -. - /,.](/docs-images/99/139027040/images/178-0.jpg "ex) 4 #@ARG_SV1#, '#@ARG_SV2#', '#@ARG_SV3#', '#@ARG_SV4#' - \" \" \"False\" \"\" \"null\". null.")
178 OZ Query Designer User's Guide - " ". " ". [ ] [] //. // // " " " ". // /,. ex) 4 #@ARG_SV1#, '#@ARG_SV2#', '#@ARG_SV3#', '#@ARG_SV4#' - " " "False" "" "null". null. 178 FORCS Co., LTD
179 "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# AND 2 = '#@ARG_D_2#' FORCS Co., LTD 179
180 OZ Query Designer User's Guide... 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#') "; setquerystring(sql); 180 FORCS Co., LTD
181 ( ) 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); = "True", = "False" FORCS Co., LTD 181
182 OZ Query Designer User's Guide :. ex) "'" + #@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; sql = " DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# 182 FORCS Co., LTD
183 AND = AND = "; 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# = " + #@ARG_DV1# + " AND #@ARG_DF2# = " + "'" + #@ARG_DV2# + "'" + "... AND #@ARG_DFn# = " + "'" + #@ARG_DVn# + "'"; FORCS Co., LTD 183
184 OZ Query Designer User's Guide 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", "",, FORCS Co., LTD
185 ( ) 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#' // = "False", = "True"/"False" FORCS Co., LTD 185
186 OZ Query Designer User's Guide "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); - string sql; sql = "DELETE FROM Customer WHERE #@ARG_DF1# = #@ARG_DV1# AND 186 FORCS Co., LTD
187 = '#@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 187
188 OZ Query Designer User's Guide 188 FORCS Co., LTD
189 FORCS Co., LTD 189
190 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 190 FORCS Co., LTD
191 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 191
192 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> 192 FORCS Co., LTD
193 . XML CSV. XML XML XML XML. XML. XML XML. XML. 'DATASET'. XML. 'RECORD'. FORCS Co., LTD 193
194 OZ Query Designer User's Guide. ". ". XML.. (, ) XML. [ ]. UTF-8. datasource.properties... 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 194 FORCS Co., LTD
195 CSV CSV CSV. CSV. CSV CSV.. TAB, SPACE, SEMICOLON, COLON, COMMA.. LINEFEED., []. CSV. 'VARCHAR'. NULL. FORCS Co., LTD 195
196 OZ Query Designer User's Guide.. 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. ". ". CSV.. (, ) CSV [ ]. " ". datasource.properties... CSV XML ' ' CSV XML. ". ". 196 FORCS Co., LTD
197 - - CSV CSV CSV CSV. ROW INDEX. '0' ROW INDEX : 0 ~ CSV. CSV CSV. FORCS Co., LTD 197
198 OZ Query Designer User's Guide. TAB, SPACE, SEMICOLON, COLON, COMMA.. LINEFEED., []. CSV. 'VARCHAR'. NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. "V. ". CSV.. (, ) CSV [ ]. " ". 198 FORCS Co., LTD
199 datasource.properties XML XML XML XML (). ROW INDEX. '0' ROW INDEX : 0 ~ XML. XML XML. FORCS Co., LTD 199
200 OZ Query Designer User's Guide XML. 'DATASET'. XML. 'RECORD'.. ". ". XML.. (, ) XML. [ ]. UTF-8. datasource.properties... (XML/CSV/ ). XML Step 1 [ ] [XML ]. 200 FORCS Co., LTD
201 Step 2 ' ' 'XML ' [ ]. FORCS Co., LTD 201
![CSV Step 1 [ ] [CSV ].](/docs-images/99/139027040/images/202-1.jpg "Step 2 ' ' 'CSV ' [ ].")
202 OZ Query Designer User's Guide Step 3 [] [ ] XML. CSV Step 1 [ ] [CSV ]. Step 2 ' ' 'CSV ' [ ]. 202 FORCS Co., LTD
203 Step 3 [] [ ] CSV. FORCS Co., LTD 203
204 OZ Query Designer User's Guide Step 1 [ ] [ ]. Step 2 ' ' 'CSV ' ' -CSV '. Step 3 ' ' ' -CSV ' [ ]. 204 FORCS Co., LTD
![Step 4 [] [ ].](/docs-images/99/139027040/images/205-1.jpg "FORCS Co.")
205 Step 4 [] [ ]. FORCS Co., LTD 205
206 OZ Query Designer User's Guide JSP ASP HTTP. HTTP XML CSV. XML XML (URL). HTTP. 206 FORCS Co., LTD
207 XML URL. ODI.. HTTP ( : 5) :. Server URL. URL 'TRUE'. XML. 'DATASET'. XML. 'RECORD'. URL GET POST.. ". ". XML.. : HTTP XML.. : [ ]. (, ) XML. [ ]. UTF-8. FORCS Co., LTD 207
208 OZ Query Designer User's Guide datasource.properties... CSV CSV (URL). HTTP. 208 FORCS Co., LTD
209 CSV URL. ODI.. HTTP ( : 5) :. Server URL. URL 'TRUE'.. TAB, SPACE, SEMICOLON, COLON, COMMA.. LINEFEED., []. CSV. 'FALSE' 'VARCHAR'. (TRUE/FALSE) NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV. URL GET POST. FORCS Co., LTD 209
210 OZ Query Designer User's Guide. ". ". CSV... : [ ]. (, ) CSV. [ ]. " ". datasource.properties... " ". HTTP HTTP HTTP (XML/CSV/ ). XML Step 1 XML (Sales.xml). 210 FORCS Co., LTD
![Step 2 [HTTP ]](/docs-images/99/139027040/images/211-0.jpg "[XML ].")
211 Step 2 [HTTP ] [XML ]. Step 3 'HTTP ' 'XML ' [ ]. FORCS Co., LTD 211
212 OZ Query Designer User's Guide Step 4 [] [HTTP ] XML. 212 FORCS Co., LTD
213 CSV Step 1 HTTP CSV. http CSV. CSV. FORCS Co., LTD 213
![OZ Query Designer User's Guide Step 2 [HTTP ]](/docs-images/99/139027040/images/214-0.jpg "[CSV ]. Step 3 'HTTP ' 'CSV ' [ ]. 214 FORCS Co.")
214 OZ Query Designer User's Guide Step 2 [HTTP ] [CSV ]. Step 3 'HTTP ' 'CSV ' [ ]. 214 FORCS Co., LTD
215 FORCS Co., LTD 215
216 OZ Query Designer User's Guide Step 4 [] [HTTP ] CSV. " ". 216 FORCS Co., LTD
217 FORCS Co., LTD 217
218 OZ Query Designer User's Guide SOAP SOAP(Simple Object Access Protocol). SOAP XML, XML (Object). SOAP OZ WSDL(Web Service Description Language). 218 FORCS Co., LTD
219 SOAP. : SOAP SOAP Toolkit 3.0. MSSOAP30.dll, WHSC30.dll bin/soap/register_soap.bat. WSDL part type 1:1 n:1 WSDL part type 1:1. XML "DateTime" "VARCHAR".. SOAP. SOAP FORCS Co., LTD 219
220 OZ Query Designer User's Guide SOAP WSDL SOAP. WSDL. datasource.properties FORCS Co., LTD
221 . : "WSDL " WSDL. WDSL Prefix NameSpace URI Prefix. SOAP WSDL.. Operation. Operation SOAPaction. Operation,, XPath, OZParam OZParam "#OZParam. #". SOAP XML. "OZParam" "#OZParam.<operation name>_<name>#". SOAP SOAP. SOAP Step 1 [SOAP ] [SOAP ]. FORCS Co., LTD 221
222 OZ Query Designer User's Guide Step 2 'SOAP ' SOAP, WSDL [ ], [] 'SOAP '. 222 FORCS Co., LTD
223 Step 3 SOAP [ ]. [] SOAP. XPath FORCS Co., LTD 223
224 OZ Query Designer User's Guide SOAP... 1, 1 ( ) 0, 0, 1 1, XPath XPath. XPath [ ] XPath [ XPath ]. XPath ( ), XPath XPath XPath XPath 224 FORCS Co., LTD
![XPath [ XPath ]. [ ] XPath XPath. XPath XPath [ ] XPath.](/docs-images/99/139027040/images/225-0.jpg "[ ],, XPath ( ) ( )., XPath. [ ],, XPath ( ) ( ). FORCS Co.")
225 XPath [ XPath ]. [ ] XPath XPath. XPath XPath [ ] XPath. [ ],, XPath ( ) ( )., XPath. [ ],, XPath ( ) ( ). FORCS Co., LTD 225
226 OZ Query Designer User's Guide,.. Step FORCS Co., LTD
227 FORCS Co., LTD 227
228 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 228 FORCS Co., LTD
229 XML XML DTD/XSD. XML XML. XML XML XML ( URL) XML (DTD XSD). XML. XML. DTD/XSD. FORCS Co., LTD 229
![OZ Query Designer User's Guide. "V. ". XML DTD. datasource.properties... : " " XSD [] ' '.](/docs-images/99/139027040/images/230-0.jpg "' ' Prefix Namespace URI. Prefix Namespace URI XSD Prefix Prefix. XSD Prefix. ' ' \"ns1, ns2, ns3 \". URI,.")
230 OZ Query Designer User's Guide. "V. ". XML DTD. datasource.properties... : " " XSD [] ' '. ' ' Prefix Namespace URI. Prefix Namespace URI XSD Prefix Prefix. XSD Prefix. ' ' "ns1, ns2, ns3 ". URI,. 230 FORCS Co., LTD
![: XML XML DTD Root Element, Root Element [] 'Root Element '.](/docs-images/99/139027040/images/231-0.jpg "Root Element [] XML XML. XML XML (DTD/XSD ). XSD DTD DTD.")
231 : XML XML DTD Root Element, Root Element [] 'Root Element '. Root Element [] XML XML. XML XML (DTD/XSD ). XSD DTD DTD. XML DTD FORCS Co., LTD 231
![1 [XML] [XML ].](/docs-images/99/139027040/images/232-1.jpg "Step 2 'XML ' []")
232 OZ Query Designer User's Guide Step 1 [XML] [XML ]. Step 2 'XML ' [] 'XML '. Step 3 XML [ ] 232 FORCS Co., LTD
![. [] XML. XPath XML.](/docs-images/99/139027040/images/233-0.jpg ".. 1, 1 ( ) 0, 0, 1 1, XPath")
233 . [] XML. XPath XML... 1, 1 ( ) 0, 0, 1 1, XPath FORCS Co., LTD 233
![OZ Query Designer User's Guide XPath. XPath [ ] XPath [ XPath ].](/docs-images/99/139027040/images/234-0.jpg "XPath ( ), XPath XPath XPath XPath XPath [ XPath ]. [ ] XPath XPath.")
234 OZ Query Designer User's Guide XPath. XPath [ ] XPath [ XPath ]. XPath ( ), XPath XPath XPath XPath XPath [ XPath ]. [ ] XPath XPath. XPath XPath 234 FORCS Co., LTD
![[ ] XPath. [ ],, XPath](/docs-images/99/139027040/images/235-0.jpg "( ) ( )., XPath. [ ],, XPath ( )) ( ).")
235 [ ] XPath. [ ],, XPath ( ) ( )., XPath. [ ],, XPath ( )) ( ). FORCS Co., LTD 235
236 OZ Query Designer User's Guide,.. Step FORCS Co., LTD
237 FORCS Co., LTD 237
238 OZ Query Designer User's Guide SAP SAP, SAP R/3. SAP,. SAP SAP SAP. SAP. SAP RFC(Remote Function Call: R/3 ). 238 FORCS Co., LTD
239 SAP. SAP SAP SAP ID () SAP SAP IP Address. SAP. SAP,. FORCS Co., LTD 239
240 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
241 - 'SAP ' [] 'SAP '. FORCS Co., LTD 241
!['SAP RFC Set '. RFC., [].](/docs-images/99/139027040/images/242-1.jpg ", '*', '?' [] RFC.")
242 OZ Query Designer User's Guide Step 3 SAP [ ] SAP 'SAP RFC Set '. RFC., []., '*', '?' [] RFC. 242 FORCS Co., LTD
243 [] (RFC). RFC []. Step 4. RFC [] RFC. FORCS Co., LTD 243
244 OZ Query Designer User's Guide [] RFC. RFC. Step 5 [] RFC. ODI. 244 FORCS Co., LTD
245 RFC, RFC FORCS Co., LTD 245
246 OZ Query Designer User's Guide 246 FORCS Co., LTD
247 FORCS Co., LTD 247
248 OZ Query Designer User's Guide CLEAR QUEST CLEAR QUEST IBM Rational Clear Quest DB. CLEAR QUEST PC IBM Rational Clear Quest. CLEAR QUEST. CLEAR QUEST. CLEAR QUEST.. CLEAR QUEST SQL. 248 FORCS Co., LTD
249 CLEAT QUEST IBM CLEAT QUEST DB. CLEAT QUEST IBM CLEAT QUEST DB. CLEAT QUEST CLEAR QUEST CLEAR QUEST. CLEAR QUEST... FORCS Co., LTD 249
250 OZ Query Designer User's Guide. CLEAR QUEST CLEAR QUEST. CLEAR QUEST. Step 1 [CLEAR QUEST] [ ]. Step 2 'CLEAR QUEST ' CLEAR QUEST [ ] CLEAR QUEST. 250 FORCS Co., LTD
251 Step 3. Step 4 [] CLEAR QUEST. FORCS Co., LTD 251
252 OZ Query Designer User's Guide Step 5 "CLEAR QUEST" [ ]. Step 6 'CLEAR QUEST ' []. Step FORCS Co., LTD
253 Step 8 (. ) CLEAR QUEST UI. Step 1 [CLEAR QUEST] [ ]. FORCS Co., LTD 253
254 OZ Query Designer User's Guide Step 2 'CLEAR QUEST ' CLEAR QUEST, [] CLEAR QUEST. Step 3 "CLEAR QUEST" [ ] 'CLEAR QUEST '. 254 FORCS Co., LTD
255 CLEAR QUEST. 'CLEAR QUEST ' [ ]. [] [ ]. FORCS Co., LTD 255
![OZ Query Designer User's Guide [ ].](/docs-images/99/139027040/images/256-0.jpg "[ ] ( ), ( ) (, ).... [ ] ( ), ( ) (, ).")
256 OZ Query Designer User's Guide [ ]. [ ] ( ), ( ) (, ).... [ ] ( ), ( ) (, ). 256 FORCS Co., LTD
257 NOT SQL. "NOT".. : "Between". "IN". ' '.. " ". SQL. SQL. FORCS Co., LTD 257
258 OZ Query Designer User's Guide ( ). CLEAR QUEST. 258 FORCS Co., LTD
!['CLEAR QUEST ' []. [] [ ].](/docs-images/99/139027040/images/259-0.jpg ". ( ). FORCS Co., LTD 259")
259 'CLEAR QUEST ' []. [] [ ].. ( ). FORCS Co., LTD 259
260 OZ Query Designer User's Guide 260 FORCS Co., LTD
261 FORCS Co., LTD 261
262 OZ Query Designer User's Guide (, UDS, /HTTP, XML DTD ) 2,.. - GDS, / FORCS Co., LTD
263 .,. 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 263
264 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, A FLAT TV 21" 800, FORCS Co., LTD
265 A FLAT TV 25" 1,500,000 - < B > () #.# == "B"... B 100,000 B V 180, < C > () #.# == "C"... C 500 C :. FORCS Co., LTD 265
266 OZ Query Designer User's Guide UDS. [ ] [ ]., []. 266 FORCS Co., LTD
![[ ] ' '. [] ' '.](/docs-images/99/139027040/images/267-0.jpg "Consume Row.")
267 [ ] ' '. [] ' '. Consume Row.. Comsum Row. 'True'. 'True'. FORCS Co., LTD 267
![Guide. " ".. [ ].](/docs-images/99/139027040/images/268-1.jpg "[].. 268 FORCS Co.")
268 OZ Query Designer User's Guide. " ".. [ ]. [] FORCS Co., LTD
![[], [ ].](/docs-images/99/139027040/images/269-0.jpg "FORCS Co.")
269 [], [ ]. FORCS Co., LTD 269
270 OZ Query Designer User's Guide 270 FORCS Co., LTD
271 FORCS Co., LTD 271
272 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 272 FORCS Co., LTD
273 ResultSet., UDS UDS.. UDS "API ". FORCS Co., LTD 273
274 OZ Query Designer User's Guide UDS,. (DLL) [ ]. UDS. UDS.. UDS. Step 1 [ (UDS)] [ ]. 274 FORCS Co., LTD
275 Step 2 ' ' []. Step 3 []. Step 2 []. Step 3 [] [ ]. FORCS Co., LTD 275
![OZ Query Designer User's Guide Step 4 [ ].](/docs-images/99/139027040/images/276-2.jpg "Step 5 []. [] [] [ ] ( ) <F5>. 276 FORCS Co.")
276 OZ Query Designer User's Guide Step 4 [ ]. Step 5 []. [] [] [ ] ( ) <F5>. 276 FORCS Co., LTD
![[]. :...,.](/docs-images/99/139027040/images/277-0.jpg "Step 1 [ (UDS)] [ ].")
277 []. :...,. Step 1 [ (UDS)] [ ]. FORCS Co., LTD 277
![Step 3 [] [ ]. [ ]. Step 4 [ ].](/docs-images/99/139027040/images/278-2.jpg "Step 5 [ ] ' '. 278 FORCS Co.")
278 OZ Query Designer User's Guide Step 2 ' ' " ",. Step 3 [] [ ]. [ ]. Step 4 [ ]. Step 5 [ ] ' '. 278 FORCS Co., LTD
![. []. FORCS](/docs-images/99/139027040/images/279-1.jpg "Co., LTD")
279 . []. FORCS Co., LTD 279
280 OZ Query Designer User's Guide 280 FORCS Co., LTD
281 FORCS Co., LTD 281
282 OZ Query Designer User's Guide...,, /HTTP, XML DTD 2. ROWIDX, COLUMN, VALUE,.,.. - ROWIDX : - COLUMN : - VALUE : 1 2 ROWIDX, COLUMN, VALUE.,, Row Index FORCS Co., LTD
283 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 283
![Step 1 [] [ ].](/docs-images/99/139027040/images/284-1.jpg "Step 2 [ ].")
284 OZ Query Designer User's Guide. Step 1 [] [ ]. Step 2 [ ]. 284 FORCS Co., LTD
![Step 3 ' ' [].](/docs-images/99/139027040/images/285-0.jpg "Step 4. Step 5 ( ).")
285 Step 3 ' ' []. Step 4. Step 5 ( ). ROWIDX, COLUMN, VALUE. FORCS Co., LTD 285
286 OZ Query Designer User's Guide 286 FORCS Co., LTD
287 FORCS Co., LTD 287
288 OZ Query Designer User's Guide. ODI, OZR, OZA,,, FORCS Co., LTD
![Step 1 ' ' [ ]. Step 2 ' ' ' '.](/docs-images/99/139027040/images/289-0.jpg "Button Description XML. FORCS Co.")
289 Step 1 ' ' [ ]. Step 2 ' ' ' '. Button Description XML. FORCS Co., LTD 289
290 OZ Query Designer User's Guide XML... [ ]..... ' '. Option IP URL Description. OZ Server. Daemon TCP, Servlet HTTP. Daemon OZ Server IP. Daemon OZ Server Port. Servlet OZ Server URL..... : " " FORCS Co., LTD
![' '. Step 3 [].. 'admin'. :,.](/docs-images/99/139027040/images/291-0.jpg "1) \" \".,. FORCS Co., LTD 291")
291 ' '. Step 3 [].. 'admin'. :,. 1) " ".,. FORCS Co., LTD 291
![OZ Query Designer User's Guide. [], (,.](/docs-images/99/139027040/images/292-0.jpg ") [], []. 2) \" \". : [ ] \" \",, [],[].")
292 OZ Query Designer User's Guide. [], (,.) [], []. 2) " ". : [ ] " ",, [],[]. 292 FORCS Co., LTD
![Step 4. [ ].](/docs-images/99/139027040/images/293-1.jpg "FORCS Co.")
293 Step 4. [ ]. FORCS Co., LTD 293
![OZ Query Designer User's Guide ODI. [] [] ( ). [] [] ( '.](/docs-images/99/139027040/images/294-0.jpg ") ' Button Description. : Disable, ' '. 294 FORCS Co.")
294 OZ Query Designer User's Guide ODI. [] [] ( ). [] [] ( '. ) ' Button Description. : Disable, ' '. 294 FORCS Co., LTD
295 . : Disable, ' '.. : Disable. Option Description.. "ozp://", "ozpserver://". / 10, 20. :. ' ' "Max history count" ' ' 20. conf/ozserverlist.xml. "MaxHistoryCount", "<SERVER Name=..." " MaxHistoryCount", "<LOCAL MaxHistoryCount=". FORCS Co., LTD 295
296 OZ Query Designer User's Guide.. [] [] ( ) FORCS Co., LTD
![,.,,,,. [ ]. ' ' [].](/docs-images/99/139027040/images/297-0.jpg "FORCS Co., LTD 297")
297 ,.,,,,. [ ]. ' ' []. FORCS Co., LTD 297
298 OZ Query Designer User's Guide & ' '. []. <Ctrl> <Shift>. ' '. []. ' ' 298 FORCS Co., LTD
![: odi. [].](/docs-images/99/139027040/images/299-0.jpg "' ' [].")
299 : odi. []. ' ' []. ' ' ' ' ( ). FORCS Co., LTD 299
![, [] ' '.](/docs-images/99/139027040/images/300-2.jpg "[]. 300")
300 OZ Query Designer User's Guide., [] ' '. []. 300 FORCS Co., LTD
![[ ] ' ' ' '. [].](/docs-images/99/139027040/images/301-0.jpg "FORCS Co.")
301 [ ] ' ' ' '. []. FORCS Co., LTD 301
302 OZ Query Designer User's Guide,,. Admin 'None',, BuiltIn RDB. ' '.,.,.,.. []. 302 FORCS Co., LTD
![' ' [Check In]. ' ' [].](/docs-images/99/139027040/images/303-0.jpg ". : Admin 'None' Admin,.. [], ' ' [].")
303 ' ' [Check In]. ' ' [].. : Admin 'None' Admin,.. [], ' ' []. FORCS Co., LTD 303
304 OZ Query Designer User's Guide. [ ], ' ' [ ]. ' '. 304 FORCS Co., LTD
![. [ ].](/docs-images/99/139027040/images/305-0.jpg "[ ]., FORCS Co.")
305 . [ ]. [ ]., FORCS Co., LTD 305
306 OZ Query Designer User's Guide.,,,,. ". ". 306 FORCS Co., LTD
![[ ]. [ ] " ",.,, [].](/docs-images/99/139027040/images/307-0.jpg "FORCS Co., LTD 307")
307 [ ]. [ ] " ",.,, []. FORCS Co., LTD 307
308 OZ Query Designer User's Guide,,. 308 FORCS Co., LTD
309 . (.) " ". None,, " " " ". "", " ",., [] []. FORCS Co., LTD 309
310 OZ Query Designer User's Guide 310 FORCS Co., LTD
311 FORCS Co., LTD 311
312 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
313 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 313
314 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
315 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 315
316 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 316 FORCS Co., LTD
317 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 317
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
untitled
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
untitled
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
untitled
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
untitled
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
untitled
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.
untitled
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
untitled
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 [] []
untitled
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
10.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
Connection 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
untitled
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
ORANGE 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
FileMaker 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.
Interstage5 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
untitled
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
untitled
(shared) (integrated) (stored) (operational) (data) : (DBMS) :, (database) :DBMS File & Database - : - : ( : ) - : - : - :, - DB - - -DBMScatalog meta-data -DBMS -DBMS - -DBMS concurrency control E-R,
FileMaker 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,
초보자를 위한 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.,,
uFOCS
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
PCServerMgmt7
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
1217 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
<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770>
i ii iii iv v vi 1 2 3 4 가상대학 시스템의 국내외 현황 조사 가상대학 플랫폼 개발 이상적인 가상대학시스템의 미래상 제안 5 웹-기반 가상대학 시스템 전통적인 교수 방법 시간/공간 제약을 극복한 학습동기 부여 교수의 일방적인 내용전달 교수와 학생간의 상호작용 동료 학생들 간의 상호작용 가상대학 운영 공지사항,강의록 자료실, 메모 질의응답,
Chap7.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
OPCTalk 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
untitled
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,
untitled
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,
chapter1,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
Remote 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. ..........................................................
NoSQL
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
thesis
( 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
DocsPin_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
교육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,
13주-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
Analytics > 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 & Cras](/thumbs/101/151500399.jpg "Analytics > 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
untitled
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
제목을 입력하세요.
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
오늘날의 기업들은 24시간 365일 멈추지 않고 돌아간다. 그리고 이러한 기업들을 위해서 업무와 관련 된 중요한 문서들은 언제 어디서라도 항상 접근하여 활용이 가능해야 한다. 끊임없이 변화하는 기업들 의 경쟁 속에서 기업내의 중요 문서의 효율적인 관리와 활용 방안은 이
C Cover Story 05 Simple. Secure. Everywhere. 문서관리 혁신의 출발점, Oracle Documents Cloud Service 최근 문서 관리 시스템의 경우 커다란 비용 투자 없이 효율적으로 문서를 관리하기 위한 기업들의 요구는 지속적으로 증가하고 있다. 이를 위해, 기업 컨텐츠 관리 솔루션 부분을 선도하는 오라클은 문서관리
User's Guide Manual
1. 롯데 통합구매 시스템 사용자 매뉴얼 (공급사용) 2006.01-1 - 문서 이력(Revision History) Date Version Description Author(s) 2006/01 V1.0 사용자 매뉴얼 - 공급사용 롯데CFD 주) 이 사용자 안내서의 내용과 롯데 통합구매 시스템은 저작권법과 컴퓨터 프로그램 보호법으로 보호 받고 있으며, 롯데CFD의
J2EE & 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
8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 )
8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) - DDL(Data Definition Language) : show, create, drop
<목 차 > 제 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
MySQL-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,.
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
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)
OZ-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
CLX8380_KR.book
이 사용설명서와 제품은 저작권법에 의해 보호되어 있습니다. 삼성전자 ( 주 ) 의 사전 서면 동의 없이 사용설명서 및 제품의 일부 또는 전체를 복사, 복제, 번역 또는 전자매체나 기계가 읽을 수 있는 형태로 바꿀 수 없습니다. 이 사용설명서와 제품은 표기상의 잘못이나 기술적인 잘못이 있을 수 있으며 사전 통보 없이 이러한 내용들이 변경될 수 있습니다. CLX-8380ND,
1
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
목차 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
No 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
3장
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
SK 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
목차 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...
DBMS & 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.
ETL_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
thesis
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
MySQL-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,
FileMaker 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
제목 레이아웃
웹해킹이라고무시하는것들보소 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
Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 11 년 10 월 26 일수요일
Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 Introduce Me!!! Job Jeju National University Student Ubuntu Korean Jeju Community Owner E-Mail: ned3y2k@hanmail.net Blog: http://ned3y2k.wo.tc Facebook: http://www.facebook.com/gyeongdae
Intro 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
PowerPoint 프레젠테이션
@ 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
PowerPoint 프레젠테이션
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.
Microsoft PowerPoint - 10Àå.ppt
10 장. DB 서버구축및운영 DBMS 의개념과용어를익힌다. 간단한 SQL 문법을학습한다. MySQL 서버를설치 / 운영한다. 관련용어 데이터 : 자료 테이블 : 데이터를표형식으로표현 레코드 : 테이블의행 필드또는컬럼 : 테이블의열 필드명 : 각필드의이름 데이터타입 : 각필드에입력할값의형식 학번이름주소연락처 관련용어 DB : 테이블의집합 DBMS : DB 들을관리하는소프트웨어
hd1300_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
Microsoft 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
Data 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
. 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
MAX+plus II Getting Started - 무작정따라하기
무작정 따라하기 2001 10 4 / Version 20-2 0 MAX+plus II Digital, Schematic Capture MAX+plus II, IC, CPLD FPGA (Logic) ALTERA PLD FLEX10K Series EPF10K10QC208-4 MAX+plus II Project, Schematic, Design Compilation,
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 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
歯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
PowerPoint 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
초보자를 위한 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#
untitled
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
목차 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
10X56_NWG_KOR.indd
디지털 프로젝터 X56 네트워크 가이드 이 제품을 구입해 주셔서 감사합니다. 본 설명서는 네트워크 기능 만을 설명하기 위한 것입니다. 본 제품을 올바르게 사 용하려면 이 취급절명저와 본 제품의 다른 취급절명저를 참조하시기 바랍니다. 중요한 주의사항 이 제품을 사용하기 전에 먼저 이 제품에 대한 모든 설명서를 잘 읽어 보십시오. 읽은 뒤에는 나중에 필요할 때
untitled
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...
1
1 1....6 1.1...6 2. Java Architecture...7 2.1 2SDK(Software Development Kit)...8 2.2 JRE(Java Runtime Environment)...9 2.3 (Java Virtual Machine, JVM)...10 2.4 JVM...11 2.5 (runtime)jvm...12 2.5.1 2.5.2
소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수
사용 설명서 TeraStation Pro II TS-HTGL/R5 패키지 내용물: 본체 (TeraStation) 이더넷 케이블 전원 케이블 TeraNavigator 설치 CD 사용 설명서 (이 설명서) 제품 보증서 www.buffalotech.com 소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를
Interstage4 설치가이드
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
Windows 네트워크 사용 설명서
Windows 네트워크 사용 설명서 (Wireless Manager mobile edition 5.5) 그림의 예로 사용된 프로젝터는 PT-FW300NTEA 입니다. 한국어 TQBH0205-5 (K) 목차 소프트웨어 라이센스 계약 3 무선 연결 사용 시 참고 사항 4 보안 관련 참고 사항 6 소프트웨어 요구 사항 12 시스템 요구 사항 12 Wireless
@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
Week13
Week 13 Social Data Mining 02 Joonhwan Lee human-computer interaction + design lab. Crawling Twitter Data OAuth Crawling Data using OpenAPI Advanced Web Crawling 1. Crawling Twitter Data Twitter API API
1. efolder 시스템구성 A. DB B. apache - mod-perl - PHP C. SphinxSearch ( 검색서비스 ) D. File Storage 2. efolder 설치순서 A. DB (MySQL) B. efolder Service - efolder
Embian efolder 설치가이드 efolder 시스템구성 efolder 설치순서 Installation commands 1. efolder 시스템구성 A. DB B. apache - mod-perl - PHP C. SphinxSearch ( 검색서비스 ) D. File Storage 2. efolder 설치순서 A. DB (MySQL) B. efolder
<32303132B3E2C1A632C8B8BFF6B5E531B1DE42C7FC2E687770>
국 가 기 술 자 격 검 정 무 단 전 재 금 함 형별 제한 시간 수험번호 성 명 다음 문제를 읽고 가장 알맞은 것을 골라 답안카드의 답란 (1, 2, 3, 4)에 표기하시오 워드프로세싱 용어 및 기능 1. 다음 중 워드프로세서의 입력 기능에 대한 설명으로 옳지 1 행두 금칙 문자로는 (, [,,< 등이 있다. 2 KS X 1001 완성형 한글
SQL 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 재개정이력 일자내용수정인버전
wp1_120616.hwp
1과목 : 워드프로세싱 용어 및 기능 1. 다음 중 문서의 효력 발생에 대한 견해로 우리나라에서 채택하 고 있는 1 표백주의 2 발신주의 3 도달주의 4 요지주의 2. 다음 중 워드프로세서의 표시기능에 대한 설명으로 옳은 1 포인트는 화면을 구성하는 최소 단위로 1포인트는 보통 0.5mm이다. 2 자간이란 문자와 문자 사이의 간격을 의미하며 자간을 조절 하여
Business Agility () Dynamic ebusiness, RTE (Real-Time Enterprise) IT Web Services c c WE-SDS (Web Services Enabled SDS) SDS SDS Service-riented Architecture Web Services ( ) ( ) ( ) / c IT / Service- Service-
Oracle 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%
<49534F20323030303020C0CEC1F520BBE7C8C4BDC9BBE720C4C1BCB3C6C320B9D7204954534D20BDC3BDBAC5DB20B0EDB5B5C8AD20C1A6BEC8BFE4C3BBBCAD2E687770>
ISO 20000 인증 사후심사 컨설팅 및 ITSM 시스템 고도화를 위한 제 안 요 청 서 2008. 6. 한 국 학 술 진 흥 재 단 이 자료는 한국학술진흥재단 제안서 작성이외의 목적으로 복제, 전달 및 사용을 금함 목 차 Ⅰ. 사업개요 1 1. 사업명 1 2. 추진배경 1 3. 목적 1 4. 사업내용 2 5. 기대효과 2 Ⅱ. 사업추진계획 4 1. 추진체계
Domino Designer Portal Development tools Rational Application Developer WebSphere Portlet Factory Workplace Designer Workplace Forms Designer
Domino, Portal & Workplace WPLC FTSS Domino Designer Portal Development tools Rational Application Developer WebSphere Portlet Factory Workplace Designer Workplace Forms Designer ? Lotus Notes Clients
슬라이드 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
ODS-FM1
OPTICAL DISC ARCHIVE FILE MANAGER ODS-FM1 INSTALLATION GUIDE [Korean] 1st Edition (Revised 4) 상표 Microsoft, Windows 및 Internet Explorer는 미국 및 / 또는 다른 국가에서 Microsoft Corporation 의 등록 상표입 Intel 및 Intel Core
TITLE
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
<4D6963726F736F667420506F776572506F696E74202D2030342E20C0CEC5CDB3DD20C0C0BFEB20B9D720BCADBAF1BDBA20B1E2BCFA2831292E70707478>
웹과 인터넷 활용 및실습 () (Part I) 문양세 강원대학교 IT대학 컴퓨터과학전공 강의 내용 전자우편(e-mail) 인스턴트 메신저(instant messenger) FTP (file transfer protocol) WWW (world wide web) 인터넷 검색 홈네트워크 (home network) Web 2.0 개인 미니홈페이지 블로그 (blog)
다음 사항을 꼭 확인하세요! 도움말 안내 - 본 도움말에는 iodd2511 조작방법 및 활용법이 적혀 있습니다. - 본 제품 사용 전에 안전을 위한 주의사항 을 반드시 숙지하십시오. - 문제가 발생하면 문제해결 을 참조하십시오. 중요한 Data 는 항상 백업 하십시오.
메 뉴 다음 사항을 꼭 확인하세요! --------------------------------- 2p 안전을 위한 주의 사항 --------------------------------- 3p 구성품 --------------------------------- 4p 각 부분의 명칭 --------------------------------- 5p 제품의 규격
Copyright 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,
초보자를 위한 자바 2 21일 완성 - 최신개정판
.,,.,. 7. Sun Microsystems.,,. Sun Bill Joy.. 15... ( ), ( )... 4600. .,,,,,., 5 Java 2 1.4. C++, Perl, Visual Basic, Delphi, Microsoft C#. WebGain Visual Cafe, Borland JBuilder, Sun ONE Studio., Sun Java
untitled
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 ( )
PowerPoint 프레젠테이션
(Host) set up : Linux Backend RS-232, Ethernet, parallel(jtag) Host terminal Target terminal : monitor (Minicom) JTAG Cross compiler Boot loader Pentium Redhat 9.0 Serial port Serial cross cable Ethernet
LCD Display
LCD Display SyncMaster 460DRn, 460DR VCR DVD DTV HDMI DVI to HDMI LAN USB (MDC: Multiple Display Control) PC. PC RS-232C. PC (Serial port) (Serial port) RS-232C.. > > Multiple Display