I am revisiting some tests we did with sql'izing universe tables. When I 1st looked at this, as I remember, it was a problem because once a file became a table, all 'file' updates ( write ) were subject to data type verification - a problem because on this legacy system data consistency was not a design concern. >From the docs it appears that since that time, the default behaviour is to not apply data type checking on file writes to a table unless the OPENCHECK statement is used instead of the OPEN statement. However, on a test table that contains a single date column I can write any garbage I want and no errors are ever generated even though I am using the OPENCHECK statement. An sql INSERT or UPDATE with bad data will generate the expected error but a WRITE won't.
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 ? Gerry ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
