Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Data types : Working with non-updatable data types
 

Working with non-updatable data types

Because non-updatable columns can be read, they can also be dumped to a .d data file. But, these .d data files cannot be loaded with the load .d utility because of their non-updatable column status. The non-updatable values are applied by the server and therefore cannot be retained from the client. Use foreign database tools to dump and load tables with non-updatable columns that are controlled by the server. Alternatively, write a program to read data from your .d data file with non-updatable types into a temp table omitting the non-updatable columns using the EXCEPT phrase when you write them.