Gerry
If you define a column as integer and that attribute is not an integer, then
the write will lead to a fatal error if you do not have opencheck or on
error options built into your code. If you do not define a column as
multivalue, then it will have a problem with multivalues.
If you do not
222
3 records listed.
COMO completed. 09:00:26 29 APR 2008
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: April 29, 2008 2:44 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse SQL Tables
Gerry
If you define
The parameter is OPENCHK.
OPENCHK - the modifies the behavior of operations upon files open
via the BASIC OPEN statement. When set to zero, I/O to files open
with the BASIC OPEN statement ignore integrity constraints. If non-
zero those files will observe the constraints. This tunable does
Subject: Re: [U2] UniVerse SQL Tables
The parameter is OPENCHK.
OPENCHK - the modifies the behavior of operations upon files open
via the BASIC OPEN statement. When set to zero, I/O to files open
with the BASIC OPEN statement ignore integrity constraints. If non-
zero those files will observe
Not unless you've written a ten line test program to prove that.
On Apr 27, 2008, at 10:50 PM, u2ug wrote:
Can we safely assume that any file writes on sql tables are not
subject
to data type checks or will this pop up to bite us at some point ?
---
u2-users mailing list
OPENCHK is also a parameter in uvconfig. It allows you to configure the system
to bypass integrity checks when the file is opened with OPEN - but not when the
file is opened with OPENCHK. Thus your understanding is conditionally correct,
depending on the setting of OPENCHK in uvconfig. This
Not unless you've written a ten line test program to prove that.
On Apr 27, 2008, at 10:50 PM, u2ug wrote:
Can we safely assume that any file writes on sql tables are not
subject
to data type checks or will this pop up to bite us at some point ?
---
u2-users mailing list
: April 28, 2008 3:07 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse SQL Tables
OPENCHK is also a parameter in uvconfig. It allows you to configure the
system to bypass integrity checks when the file is opened with OPEN -
but not when the file is opened with OPENCHK. Thus your
:[EMAIL PROTECTED] On Behalf Of Clifton Oliver
Sent: April 28, 2008 2:59 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse SQL Tables
Not unless you've written a ten line test program to prove that.
On Apr 27, 2008, at 10:50 PM, u2ug wrote:
Can we safely assume that any file writes
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of u2ug
Sent: April 28, 2008 8:54 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse SQL Tables
Yes I know about the OPENCHECK config setting which was why I was
intentionally using the OPENCHECK statement.
What you
All I can offer is that it used to work in version 9.6. I haven't touched it
since. Sounds like something to take up with IBM through your support provider.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
11 matches
Mail list logo