Carmen,
Here's how I was working with it. We still had some other issues but
with Scott's assistance I did get this and a few other things.
D SQLSetEnvAttr...
D PR 10i 0 Extproc('SQLSetEnvAttr')
D 10i 0 value
D 10i 0 value
D 10i 0 const
D 10i 0 value
d henv s like(SQLHENV)
/free
rc = SQLSetEnvAttr(henv:SQL_ATTR_SERVER_MODE:SQL_TRUE:1);
**** Rest of the Story ****
/end-free
***Here's a previous post to me from Scott where you can get more
information.
Here's a link to the page of the Information Center that describes the
API:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/cli/rzadpfnerror.htm
Since you're trying to get error info on an SQLConnect, you won't have a
statement handle, so supply the constant SQL_NULL_HSTMT for the 3rd
parameter.
If you like, you can get my entire RPG copybook for SQL CLI from the
following link:
http://www.pentontech.com/IBMContent/Documents/article/53024_153_ProcWithParm.zip
***
Hope it helps
Jack Long
CBK Ltd.
"Carmen Nuland" <cnuland@xxxxxxxxxxxxxx>
02/26/2008 11:14 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc
Subject
RE: Set SQL Server Mode
This is the response from we received from IBM:
"It sounds like you are using the NativeJDBC provider to make a JDBC
connection using CLI to the DB2 UDB on the System i. The System I
implicitly uses SQL Server Mode when creating a native database
connection.
(So, I think that means we're calling the JDBC routines in Java to access
the same system, which turns SQL Server Mode on.)
Once SQL Server Mode is set on, any embedded SQL does not run. From what
I've read, it sounds like if I can start the SQL Server Mode right away at
the beginning of the job that it will allow embedded SQL to run in the
job.
Or, if I can figure out how to turn it on, I could turn it off, too. I
just
can't figure out how to do it, and can't find an example in RPG code."
Does that help clarify?
Carmen
-----Original Message-----
From: Scott Klement [mailto:rpg400-l@xxxxxxxxxxxxxxxx]
Sent: Monday, February 25, 2008 2:21 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Set SQL Server Mode
What do you mean by "RPG program calling a Java method"? And how does
this relate to the SQL server mode?
Do you mean that you're calling the JDBC routines in Java to access the
same system (your local System i)?
Carmen Nuland wrote:
We need to set the SQL Server Mode in an RPG program calling a Java
method.
We found this information, but can't seem to find any examples in RPG
using
either method (there seem to only be C examples).
There are two ways to enable SQL server mode on the AS/400:
* Have your CLI application use the SQL_Attr_Server_Mode
option on the
SQLSetEnvAttr
function.
* Use the QWTCHGJB (Change Job) system API to enable SQL
server mode.
Has anyone else used this?
Carmen
midrange.com
