Re: SQL0084 after upgrade to V7R1 on ODBC connection

Pete,
My first thoughts after an OS Upgrade and ODBC connection(s) start having
problem is that the ODBC driver needs to be upgraded to something more
current. MY 2nd thought in this case is that IBM at 6.1 and even more so
at 7.1 tightened things down to meet current standards. I know there are
some issues with JOINs that at 5.4 just produced warning msgs in the logs.
At 6.1 some flat broke and at 7.1 even more failed because the coding of
the SQLs did not meet Ind Standards.

On Mon, Oct 1, 2012 at 8:40 PM, Pete Helgren <pete@xxxxxxxxxx> wrote:

I have a customer with an app that connects to the i with ODBC. It is
an ancient application running on Windows NT but has worked flawlessly
for a decade. They upgraded to V7R1 from V6R1 and now they get the
following on any SQL invoked by the ODBC connection:

Message ID . . . . . . : SQL0084 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 10/01/12 Time sent . . . . . . :
16:31:12

Message . . . . : SQL statement not allowed.
Cause . . . . . : The SQL statement is not allowed for one of the
following
reasons: <Lists a bunch of reasons here>

Of course, stating what the offending statement IS apparently isn't part
of the error reporting so I don't know which of a few hundred SQL
statements it is complaining about. I am assuming it is the initial
CONNECT but I can't be sure.

Anyone run into this? I can find much in the Memo to Users that refers
to ODBC or SQL0084

Thanks,

--
Pete Helgren
Value Added Software, Inc
www.petesworkshop.com
GIAC Secure Software Programmer-Java

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.