Specify defaults for displaying data in the Table Data Editor preferences page.
Select Window|Preferences from the main menu bar.
The Preferences dialog box appears.
In the left pane, expand Sybase, Inc, then expand Database Development and select Table Data Editor.
Select options for the Table Data editor:
Table Data editor preferences
| Field | Explanation |
|---|---|
| Show warning message when editing table data | Specify whether users receive a warning when their input is converted automatically to comply with column requirements (default). For example, if the column type is char(5) and the user enters abcdef, the f is truncated in the database, and a warning that input has been converted displays. |
Column format | Customize the labels for a table column. Click Set Variables and select information to include in the column label. Default is to show the datatype. See Example for a sample of the selected format. |
| Show row number | Select to display row number for each row. (Default.) |
| Display null value as | Enter characters to display when the value is NULL. Default is NULL. |
| Limit number of rows retrieved | Select to improve Table Data editor performance, and to avoid running out of memory when retrieving data from very large tables, for example, a hundred million rows. (Default and recommended.) |
| Maximum rows to retrieve | Enter maximum number of rows to retrieve. Default is 100. |
| Limit size of content retrieved | Select to improve Table Data editor performance and to avoid running out of memory when retrieving very wide data. Datatypes long binary, long varchar, and types based on them including text, image, and xml, can be 50MB or more. Deselect to allow editing of data for columns of all types and widths. NoteEditing columns whose data size is limited can cause errors when inserting, updating, or deleting. |
| Maximum bytes to retrieve | Enter maximum width of data to retrieve. Default is 32767 bytes. |
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com