Look below the list of columns, beside the choices for portable and physical data types.
#How to modify data in spss 16 modeler drivers
To use the set of data types for the DBMS in your model, set the drivers to that system in the Driver Options dialog box.ĭetermine which database driver is set for the diagram.ĭouble-click a table, and in the Database Properties window under Categories click Columns. If you don't see the data types that you expect, you may need to change the driver that you have set in the Driver Options dialog box. For example, if you have the driver set as Access, any data types available in Access are available as physical data types in your model. To understand more about the data types for your driver, see the documentation for its target database management system (DBMS).Ĭhange which set of physical data types is availableĭifferent database management systems support different physical data types. Physical data types are dictated by the database driver set for the model.
Portable data types are generically defined types that map to similar, compatible physical data types in different database systems. For example, if you have the driver set as Access, any data types available in Microsoft Office Access are available as physical data types in your model.īelow the list of columns, click either Portable data types or Physical data types. Physical data types are the data types the target database supports. In the Database Properties window, under Categories, click Columns.Ĭlick the cell in the Data Type column that you want to change.Ĭlick the down arrow next to the current data type and choose a different data type from the list.Ĭhoose between portable and physical data types Set data types for the columns in a database model tableĭouble-click the shape for the table that has the columns that you want to set data types for. See Can't find the database modeling features? for more information. Note: The Database Model diagram is only available in certain versions of Visio.
0 kommentar(er)
