Having worked in DB2 for Linux, UNIX, and Windows support for a few years, I have noticed that there is seldom an easy way to view data contained in tables in a readable format or one which can be used to generate graphs or charts easily without the need for complex tools. Many customers also ask me, 'What is the quickest and easiest way to view or parse DB2 data so that I can generate graphs and charts to make sense of the data?'
Common end-user applications such as Microsoft Excel and Lotus 1-2-3 can be used to import this data. This article will show you how to use ODBC / OLE-DB and.wsf files to import DB2 data. Mechanisms Open Database Connectivity (ODBC) - An industry API which allows applications to transparently connect to data sources and access the data. An IBM DB2 ODBC driver is provided with DB2 installations ranging from the Runtime Client to Enterprise Server Edition (ESE). Object Linking and Embedding for Databases (OLE DB) - A Microsoft API which allows applications to transparently connect to and access a data source. An IBM OLE DB driver is provided with DB2 installations ranging from the Runtime Client to ESE.
Worksheet File Format (WSF) - From the DB2 Information Center: Numeric data in WSF format files is stored using Intel machine format. This format allows Lotus WSF files to be transferred and used in different Lotus operating environments. As a result of this consistency in internal formats, exported WSF files from DB2 products can be used by Lotus 1-2-3. Importing into an Excel spreadsheet using ODBC To import into an Excel spreadsheet using ODBC, follow these steps: • Open up an Excel spreadsheet and select New Database Query. New database. Conclusion This article explains how to import data into Microsoft Excel and Lotus 1-2-3 in a quick and easy manner. After importing table data a few times you will not even have to refer to this article as the process is quite simple.
This should allow you to quickly formulate graphs and charts. If you have defined table functions to gather various snapshots or have defined event monitors that are being written to a table, then importing this data allows you to generate a graphical representation of your monitoring data based on columns quite easily, especially for those familiar with Excel or 1-2-3. Acknowledgements Special thanks to Connie Lam from DD2 UDB Advanced Support for providing her input and reviewing this article.
Autocom delphi 2013 r3 keygen crack download 2017. Which is alot better.
Related topics • Visit the to expand your DB2 skills. • Visit to link to a world of resources for the DBA, including articles, tutorials, documentation, support links, community links, and more. • Download a free trial version of. • Now you can use DB2 for free. Download, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edtion and provides a solid base to build and deploy applications.