code analysis


DB2Excel

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)


Desktop search, code analysis

I've been contracted to do some analysis of the client's code. Naturally, the first thing I did was load up all their source into Callgraph, and generate HTML of all their source. :) Now I have something that is preprocessed, formatted, easy to read, and with hyperlinks between calls and procedures. The best part is, plain text searches of this output HTML are more useful and reliable than unprocessed code would be.

That leads me to my topic. I wrote a little find/grep script with generates a nice HTML list with links to files which contain my search string. It works great, but it takes about 10-20 minutes per search. The need for a desktop index/search application is something that I've avoided until right now.


Syndicate content