Is it possible to edit schema with VSG v3.1?

Posted in 2003

Doug Baroter — 2 Nov 2003 14:57:05 -0800 — source: Usenet: comp.databases.informix

Hi, Background info: UniData 5.2 Personal Edition for Windows from IBM. I've successfully exported UniData data to MS SQL Server 2000 via IBM ODBC driver and VSG's schema translation mechanism. Now, I do have a question about VSG v3.1, currently, for any view created, each column is set to NULLABLE, well, my requirement is such that I want the [ID] column to be NONNULLABLE or NULLABLE value set to N | 0. This version of VSG does not seem to have the feature of resetting NULLABLE value. Is this understanding correct? If so, how could I achieve the same thing from UDT? VOC file? I'd appreciate some concrete guidance since I'm new to the "beast" (bear with me, thanks :) Thanks. DL