RE: Set SQL Server Mode

["Carmen Nuland" <cnuland@xxxxxxxxxxxxxx>]

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