| Lattice.SPGen Stored Procedure Generator 1.3 |
| |
|

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:
1. Collect metadata from different datasource(Oracle, DB2, SQL Server)
2. Build xml metadata input definition file
3. Generate stored procedures using xslt with different xsl stlysheet.
Features added in version 1.3
* Option to generate business entity class per table
* Option to generate one big sql script file or each file per table
* Option to generate XML metadata definition file
Main features:
* Control output stored procedures format in runtime by modifying XSL style sheet.
* Change stored procedure’s name, exclude stored procedure’s columns on the fly.
* Auto-generate package header and body for Oracle.
* Auto-generate stored procedures to insert data rows and return identity id for SQL server and sequence number for Oracle.
* Auto-generate stored procedures to select, update, delete single data row based on primary key definitions.
* Auto-generate stored procedures to select all rows based on foreign key definitions.
* Auto-generate stored procedures to select all rows of tables and views.
* Support composite primary key
Lattice.SPGen 1.3 supports the following RDBMS:
* MS SQL Server 2000 and 7, MSDE 2000.
* Oracle 8i and 9i.
* IBM DB2 UDB
Below is the link to download the software:
http://www.latticesoft.com/DesktopDefault.aspx?tabindex=4&tabid=13
Lattice Business Software
http://www.latticesoft.com
|
Related keywords: stored procedure, stored procedure generator, stored procedure builder, stored procedure creator, stored procedure wizard, SQL Server, Oracle, DB2, database tool, stored procedure development, oracle package, code generation, xslt, xml,
|
|
|
| |
|
|
| Top Software Development / Others softs |
|
1)
Free Hex Editor 3.12
Free Hex Editor - Binary File Editing Software for Windows. Edit your exe code.
License:Freeware,
$0 to buy Size:
2072KB
2)
GPS-Simulator 2.0
simulates GPS NMEA 0183 data via serial port, bluetooth or network
License:Demo,
$99 to buy Size:
5005KB
3)
Flash page flip component 1.1
Flipping book - Page flip flash component
License:Commercial,
$25 to buy Size:
170KB
4)
TOAD for Oracle Freeware 8.5
Tool for Oracle Application Developers
License:Freeware,
$0 to buy Size:
11115KB
5)
Access MDE Unlocker 1.5
Unlock an Access MDE database allowing design changes to forms/reports!
License:Demo,
$55 to buy Size:
436KB
6)
exeJ 1.01
Create a "batch-like" executable (.exe file) for your java application.
License:Freeware,
$399 to buy Size:
200KB
7)
VSS.net 1.67
Access Visual SourceSafe(tm) over the Internet
License:Freeware,
$0 to buy Size:
617KB
8)
Docklight RS232 Terminal - RS232 Monitor 1.6
Test, analysis and simulation for serial communication protocols (RS232, ...)
License:Shareware,
$67 to buy Size:
3098KB
9)
SkinEngine 1.11
Easy to add skinnalbe GUI to your C++, Delphi, VB and .NET application
License:Shareware,
$99.00 to buy Size:
5942KB
10)
HTML Color Picker and Hex Color Code Finder 1.02
Color codes manager, all HEX and RGB formats (HTML, PhotoShop, C++, Delphi...)
License:Shareware,
$19 to buy Size:
2347KB
|
|
|
| New Software Development / Others softs |
|
1)
microOLAP Database Designer for PostgreSQL 1.2.4
Visual development system for PostgreSQL database design and modeling
License:Shareware,
$124.95 to buy Size:
9013KB
2)
Freeware .NET Obfuscator Skater Light 2.6.00
Freeware .NET Obfuscator Skater Light Edition is free .NET code protection tool
License:Freeware,
$0 to buy Size:
1127KB
3)
PromoSoft 1.7
Automate the process of promoting your sharware/freeware/demo applications.
License:Shareware,
$95 to buy Size:
4149KB
4)
BrowserObject PHP Basic Edition June.2008
BrowserObject PHP is best to detect client's browser capabilities and settings.
License:Commercial,
$369 to buy Size:
KB
5)
IP2Location IP-COUNTRY-REGION-CITY-ISP-DOMAIN Database June 2008
IP-COUNTRY-REGION-CITY-ISP-DOMAIN database translates IP address to domain name.
License:Data Only,
$499 to buy Size:
200KB
6)
SMTP/POP3 Email Engine for COBOL 5.0
SMTP/POP3/IMAP COBOL email component library to send and receive mail.
License:Shareware,
$115 to buy Size:
541KB
7)
IP2Location IP-COUNTRY-REGION-CITY Database June 2008
IP2Location(tm) IP-COUNTRY-REGION-CITY translates IP address to country, region and city.
License:Data Only,
$199 to buy Size:
200KB
8)
IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE Database June 2008
IP address to country, region, city, latitude, longitude and zip code.
License:Data Only,
$499 to buy Size:
200KB
9)
EControl Syntax Editor SDK 2.50
Powerful text editor control with syntax highlighting, text folding...
License:Shareware,
$200 to buy Size:
7381KB
10)
United States ZIP Code Database (Gold Edition) June.2008
United States ZIP Codes Database Subscription in text, Excel, Access and dBASE V
License:Data Only,
$59.95 to buy Size:
27KB
|
|
|
|
|