70 likes | 143 Vues
Introduction to NetDB2. IST210. DB2 and NetDB2. IBM DB2 is a commercial-strength database management system NetDB2 is a web application that allows users to execute SQL statements against DB2. NetDB2 Login. Interface. NetDB2 Interface. The interface has four separate areas as follows:.
E N D
Introduction to NetDB2 IST210
DB2 and NetDB2 • IBM DB2 is a commercial-strength database management system • NetDB2 is a web application that allows users to execute SQL statements against DB2.
NetDB2 Interface • The interface has four separate areas as follows:
Areas • Control Panel: This menu contains all the tools and facility that Net DB2 offers. • Tools • My Tables • My Procedures • My UDF • Load utility • Facility • SQL Center (By default, after you have logged onto Net DB2, you will be presented with SQL Center facility) • Script Center • Stored Procedure Center • UDF Center • General Input Window: Custom SQL statements and text can be entered in this window by 1) typing or 2) cut and paste from a text file.. • SQL Result: This is the communication area that Net DB2 uses to provide status information after execution of SQL statement(s) entered in the General Input window or the Load utility. • Information: Net DB2 tools use this area to display appropriate results.