Lattice.SPGen Stored Procedure Generator Version 1.2 Released!

Lattice.SPGen is a stored procedure generator that supports Microsoft SQL Server, Oracle and IBM DB2 UDB. Lattice.SPGen will process each table and view in the database which you selected and created stored procedures to insert, update, delete, select (single or multiple records) using the fields you choose as well as using stored procedure’s name you desire. Below is how it works:


  • Collect metadata from different datasource(Oracle, DB2, SQL Server)

  • Build xml metadata input definition file

  • Generate stored procedures using xslt with different xsl stlysheet.


    • Lattice.SPGen comes with a user-friendly graphic user interface. It offers various features like supporting oracle, MS SQL server and IBM DB2 UDB and helps in generating package headers and body for oracle, return identity id or sequence number from insert stored procedure. See the screenshot below for an example.




    More productivity, less expense!

    You only have to buy one licence for your whole department or division. Think of all the money you can save with an investment of only $49!


    Don't take our word for it; download the Lattice.SPGen demo today and see for yourself!

    Lattice Business Software
    http://www.latticesoft.com

    End:

    keywords: stored procedur generator, stored procedure builder, stored procedure creator, Oracle package generator/creatoe, DB2 stored procedure generator, Oracle stored procedure generator, DB2 stored procedure builder, MS SQL Server, database tool