Hi guys,
I tried to create a program that will generate code that will export table contents to excel
and wanted other people to test my project. (P.S. Please excuse my coding, I'm just a starter with progress :}).
This program is created using Openedge 10.1B and tested using Microsoft Excel 2007
DB2Excel is a program that automatically generates code for importing data to excel.
Step 1: db2Excel Collects tables from the database and makes them available for selection.
(if needed for schema preview, you can edit the source code to view system tables)
Step 2: After the table is selected. Press the button "show fields" to display the fields
of the selected table.
Select one or more field results to use for excel. (note: browsers are multi-selected)
Step 3: You can add additional expression by selecting + right-click one or more fields from either browsers.
Step 4: Provide corresponding operator & values to the query created.
Step 5: After enough information is given, Press 'Generate' to create a procedure for you query.
Note: Filename is needed with this operation.
Step 6: After generation of code, Click 'Excecute' button preview how the program will run.
Advantages:
1. May be very useful as data migration utility.
2. Shortens coding time from 5 minutes to less than a minute (especially when you have include all fields of tables with many fields).
Any Comments or Suggestion are very welcome.
Please email me at gsanchezBiz@gmail.com
Thanks!