RE: [U2] UniVerse SQL Tables

2008-04-29 Thread David Jordan
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

RE: [U2] UniVerse SQL Tables

2008-04-29 Thread u2ug
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

Re: [U2] UniVerse SQL Tables

2008-04-29 Thread Clifton Oliver
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

RE: [U2] UniVerse SQL Tables

2008-04-29 Thread u2ug
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

Re: [U2] UniVerse SQL Tables

2008-04-28 Thread Clifton Oliver
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

Re: [U2] UniVerse SQL Tables

2008-04-28 Thread Ray Wurlod
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

Re: [U2] UniVerse SQL Tables

2008-04-28 Thread Clifton Oliver
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

RE: [U2] UniVerse SQL Tables

2008-04-28 Thread u2ug
: 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

RE: [U2] UniVerse SQL Tables

2008-04-28 Thread u2ug
:[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

RE: [U2] UniVerse SQL Tables

2008-04-28 Thread u2ug
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

RE: [U2] UniVerse SQL Tables

2008-04-28 Thread Ray Wurlod
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/