	What is an SQLThing?
	Primarily, SQLThing is an interface to DB2 on the iSeries platform. It allows you to run and test SQL statements, see your AS/400 job log and have control over the execution environment that your statements run in. The primary focus of the first versions of the SQLThing tool were only for execution and testing of SQL statements. However, with SQLThing Enterprise Edition Client Server Development has added many features to help programmers and power users extract and collate information on their AS/400 systems. These features include a stored procedure editor, report writing capabilities, a three dimensional spreadsheet, graphing capabilities, export of information to PC file formats, VB and Java code generation and a host of others. How does SQLThing Work SQLThing is a client server program for the iSeries. The SQLThing executable runs on a Windows 2000, NT or Windows 9x machine and communicates with the AS/400 via ODBC. SQLThing requires that you use an ODBC driver that is ODBC 3.0 or greater compliant, such as IBM Client Access Express ODBC Driver. Internally, SQLThing uses ActiveX Data Objects and direct calls to the ODBC interface to communicate with the AS/400. When started, SQLThing will prompt for a Data Source Name, User ID and Password. Once the user has filled in these requirements, SQLThing will make two initial connections to the AS/400. One connection is used for utility processing like retrieving files and libraries or job log information. The other connection is used as the primary connection for SQL testing, running exports or other functions.

What is an SQLThing?

Primarily, SQLThing is an interface to DB2 on the iSeries platform. It allows you to run and test SQL statements, see your AS/400 job log and have control over the execution environment that your statements run in. The primary focus of the first versions of the SQLThing tool were only for execution and testing of SQL statements. However, with SQLThing Enterprise Edition Client Server Development has added many features to help programmers and power users extract and collate information on their AS/400 systems. These features include a stored procedure editor, report writing capabilities, a three dimensional spreadsheet, graphing capabilities, export of information to PC file formats, VB and Java code generation and a host of others.

How does SQLThing Work

SQLThing is a client server program for the iSeries. The SQLThing executable runs on a Windows 2000, NT or Windows 9x machine and communicates with the AS/400 via ODBC. SQLThing requires that you use an ODBC driver that is ODBC 3.0 or greater compliant, such as IBM Client Access Express ODBC Driver.

Internally, SQLThing uses ActiveX Data Objects and direct calls to the ODBC interface to communicate with the AS/400. When started, SQLThing will prompt for a Data Source Name, User ID and Password. Once the user has filled in these requirements, SQLThing will make two initial connections to the AS/400. One connection is used for utility processing like retrieving files and libraries or job log information. The other connection is used as the primary connection for SQL testing, running exports or other functions.