Lattice.SPGen Stored Procedure Generator 1.3 Free Download

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
|
|
|
|
| Top Others / Software Development programs |
-
1)
Free Serial Port Monitor 3.31
Free software serial port monitor, Com Rs232 sniffer with communication packet data analyzer. This monitoring utility can spy, capture, view, analyze, test com ports activity performing com port connection and traffic analysis
|
-
2)
Hexadecimal to ASCII Converter 4.3.4
Convert hexadecimal strings to ASCII text with a single click. Small application window allows simultaneous use with your favourite IDE, text editor, Word, etc..
|
|
|
|
|
-
5)
ActiveComport Serial Port Toolkit 2.0
Serial port toolkit to enable applications or scripts to communicate with a modem or other serial port device. Features full com port control, binary and ASCII data transfer, support for RS 232 and RS 485 standards and ISDN modem support.
|
-
6)
Docklight RS232 Terminal - RS232 Monitor 1.6
Docklight is a test, analysis and simulation tool for serial communication protocols (RS232, RS485/422 and others). * Simulating serial protocols * Logging RS232 data * Detecting specific data sequences * Responding to incoming data
|
-
7)
ANPR 1. 0. 10. 5
LPReditor, offers a robust, transportable, automatic license plate recognition (LPR) capability, designed exclusively for system integrators, value-added resellers, and volume end-users. LPReditor is built entirely on industry-standard modules
|
-
8)
ActiveGanttVB Scheduler Component 2.6.2
Add Scheduling capabilities to your Application. This component makes it easy to build rosters, TV/movie scheduling, classroom scheduling, equipment/location rental, payroll, assembly line production, and many other applications.
|
-
9)
VEDIT 6.13.1
VEDIT edits any text, data, binary file in ASCII,
Hex or EBCDIC; even 100+ Gigabyte files. Ideal for database and mainframe editing, program
development. Fast, compact and configurable. Windows, DOS, Linux
|
|
|
| New Others / Software Development programs |
-
1)
GraphEditPlus 1.2
GraphEditPlus will make each DirectShow developer's life much easier. Edit multiple graphs, see every bit of each mediatype, control your filters and generate C++ or C# code of a working application. DirectShow development was never so easy before!
|
|
|
|
|
|
|
|
|
-
6)
Pacestar UML Diagrammer 6.02.2014
Pacestar UML Diagrammer helps you to quickly and easily generate all varieties of UML2 diagrams. Develop, document, and communicate your designs in a systematic yet flexible AND commonly understood notation.
|
-
7)
United States ZIP Code Database (Gold Edition) June.2008
United States ZIP codes database subscription includes ZIP code, city name, alias name, state code, phone area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude, elevation, MSA, PMSA and Census 2000 data.
|
-
8)
United States ZIP Code Database (Premium Edition) June.2008
United States ZIP codes database one month subscription service. The database includes ZIP code, city name, alias name, state code, area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude and county elevation.
|
|
|
|
|
|
|