RE: Set SQL Server Mode

[JLong@xxxxxxxxxx]

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