Re: Is the table created or not?

More specifically...

You may have changed the command defaults at some point to COMMIT(*NONE)
and a PTF or even a new release has changed them back to IBM defaults.

Or perhaps you just manually changed the compile option when it was
compiled.

PRTSQLINF as mentioned in my other post would show you the differences
between old & new programs.

Charles

On Fri, Sep 7, 2018 at 7:58 AM Tommy Holden <Tommy.Holden@xxxxxxxxx> wrote:

It could have been compiled using COMMIT(*NONE) on the compile command

Thanks,
Tommy Holden

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of John Yeung
Sent: Friday, September 7, 2018 8:50 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Is the table created or not?

On Fri, Sep 7, 2018 at 9:44 AM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

QTEMP? Commitment control? Those are about the only things that come

to mind.

Thanks, I am pretty sure it's the commitment control (or our lack
thereof). Connecting with autocommit=True seems to have "fixed" the
problem. Though I still don't understand why it works without that in the
current version of the application.

John Y.
--
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:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=02%7C01%7CTommy.Holden%40tmcat.com%7C41d38ccd287e476078ba08d614c8d461%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636719250123337763&amp;sdata=AUYZgIIEoor6T1if48edA5s4US3lrpo7gtzo8qsoZj8%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=02%7C01%7CTommy.Holden%40tmcat.com%7C41d38ccd287e476078ba08d614c8d461%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636719250123337763&amp;sdata=Y2QCgoOxZOW8QNKGrzqvbvi3013fFbuKDZFiN4eP1%2Fg%3D&amp;reserved=0
.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Famzn.to%2F2dEadiD&amp;data=02%7C01%7CTommy.Holden%40tmcat.com%7C41d38ccd287e476078ba08d614c8d461%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636719250123337763&amp;sdata=28Wf4QX6yZRsH3IXW4F3NS2BSojtfwXHkLHIGhQ1UWc%3D&amp;reserved=0
--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD