A method, apparatus and program storage device for enabling SQL statement access to remote system specific data and functions is provided. A method is developed to utilize wrapper stored procedures and the table formatted output of native commands in order to access the output via direct SQL statements. The output of native commands is generated by wrapper stored procedures and then directed to a temporary file by the method. The client may then access the contents of the file with direct SQL queries. This procedure allows the transformed access procedure to perform more efficiently than conventional procedures, while providing same results.
A development tool enables a device database to be created, managed, and deployed to a device as part of the a device project. The device database may have an installation property which provides logic for installing the device database at the device. Additionally, stored procedures and triggers may be registered with the device database. The registered stored procedures and triggers may be embedded in the device database and deployed to the device along with the device database.
A development tool enables a device database to be created, managed, and deployed to a device as part of the a device project. The device database may have an installation property which provides logic for installing the device database at the device. Additionally, stored procedures and triggers may be registered with the device database. The registered stored procedures and triggers may be embedded in the device database and deployed to the device along with the device database.
