70 likes | 155 Views
Discover the functionalities of IBM DB2 and NetDB2 web application, with detailed insights on login interface, tools, and centers available.
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.