×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi John,
The spelling and capitalization appear to be correct. Why, for instance,
can the system find the "SQLSetConnectAttr" function, but not the
"SQLSetConnection"?
I looked in the RPG definitions in my copybook, and I don't have
SQLSetConnection() defined. So I looked C definitions (provided by IBM)
in the QSYSINC/H,SQLCLI member (V5R4M0), and there's no mention of
SQLSetConnection() there either.
I then went to the i5/OS Information Center for V5R4, and searched it
for "SQLSetConnection", but there were no hits.
So, at this point, I'm willing to bet that you've stumbled across an API
that's supported in other DB2 implementations, but isn't support in the
DB2 UDB for System i. In other words, if you buy IBM DB2 for Windows,
Linux, etc, you'll get this API. But they don't have it in i5/OS.
I did check out the link that you provided, and it says that this API is
used when mixing embedded SQL and CLI, to tell the embedded SQL which
handle to use. That doesn't make much sense, really, because if you
look at the code that's generated by embedded SQL, it doesn't call the
CLI API, therefore it'd make no sense for it to use a CLI connection handle.
So, I take that as further evidence that this API isn't supported on
i5/OS, and isn't intended for the i5/OS implementation of DB2.
Here's where CLI is discussed in the i5/OS Information Center... it
might be easier for you to use, since it only lists the stuff supported
in i5/OS:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/cli/rzadpkickoff.htm
midrange.com
