-users@listserver.u2ug.org
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-
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
Hi Gerry
I think there is an option in UvConfig that allows bad data to be written to
a table despite constraints. I have not been able to write bad data to an
SQL Table as you have done in the test program.
Regards
David Jordan
Managing Consultant
---
u2-users mailing list
u2-users@listse
types are incompatible in this
operation
Scanned command was INSERT INTO TAB1 ( KEY1 , VAL1 , VAL2 , VAL3 , VAL4
) VALUES ( "INS5" , "2008-01-01" , "14:22:04" , 1.2 , "snickety" )
UniVerse/SQL: Column "VAL4" data type does not match insert value.
==
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
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/
ginal 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.
Wha
:[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 w
Ray Wurlod
Sent: 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 OPEN
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
u2-users@listse
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 i
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
u2-users@listse
12 matches
Mail list logo