This is a discussion on Is it possible to edit schema with VSG v3.1? within the Informix forums, part of the Database Server Software category; --> Hi, Background info: UniData 5.2 Personal Edition for Windows from IBM. I've successfully exported UniData data to MS SQL ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |