SQL access to system specific data

摘要

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.