Article ID: 819528 - View products that this article applies to.
If you try to use tablename.* syntax in a parameterized query with the OLE DB Provider for DB2 (DB2OLEDB), the query is unsuccessful and you always receive the following error message:
For example, the following SQL statement is unsuccessful:
SQLSTATE: 07001, SQLCODE: -313
In contrast, the following SQL statement is successful (the only difference is in the SELECT clause):
SELECT e.* FROM LIBNAME.PUBLISHERS p, LIBNAME.EMPLOYEE e WHERE e.PUB_ID = p.PUB_ID AND p.STATE = ?
If you view a Network Monitor capture of the problem, you can see that the OLE DB Provider for DB2 does not send a SQLDTA command to the target DB2 system that contains the parameter information.
SELECT * FROM LIBNAME.PUBLISHERS p, LIBNAME.EMPLOYEE e WHERE e.PUB_ID = p.PUB_ID AND p.STATE = ?
The OLE DB Provider for DB2 SQL parser does not correctly handle the tablename.* syntax.
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft Host Integration Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/328152/ )How to obtain the latest service pack for Host Integration Server 2000
Hotfix informationThe English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name ---------------------------------------------------------- 29-Apr-2003 00:33 18.104.22.1680 311,568 Crtpkg.dll 29-Apr-2003 00:33 22.214.171.1240 680,208 Db2oledb.dll 29-Apr-2003 00:33 126.96.36.1990 78,096 Mseidb2c.dll 29-Apr-2003 00:33 188.8.131.520 885,008 Mseidb2d.dll 29-Apr-2003 00:33 184.108.40.2060 24,848 Mseidpm.dll 29-Apr-2003 00:33 220.127.116.110 262,416 Mseidrda.dll 29-Apr-2003 00:33 18.104.22.1680 147,728 Mseidt.dll 29-Apr-2003 00:33 22.214.171.1240 65,808 Crtpkg.exe 29-Apr-2003 00:34 126.96.36.1990 82,192 Ddmserv.exe
Note Because of file dependencies, the most recent fix that contains the preceding files may also contain additional files.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was corrected in Microsoft Host Integration Server 2000 Service Pack 2.
To work around this problem, use an alternative to the tablename.* syntax. The asterisk ( *) syntax will return all fields from all tables used in the query, or the field names can be specifically referenced. For example (shown in the following SQL Statement):
SELECT e.AU_LNAME, e.AU_FNAME, e.AU_ID FROM LIBNAME.PUBLISHERS p, LIBNAME.EMPLOYEE e WHERE e.PUB_ID = p.PUB_ID AND p.STATE = ?
The SQLSTATE:07001, SQLCODE:-313 error has the following meaning on DB2/400:
SQL0313 SQLCODE -313 SQLSTATE 07001, 07004
Explanation: Number of host variables not valid.
Contact us for more help
Connect with Answer Desk for expert help.