Support for "in row" feature and research for any other new options in Sybase ASE 15.7+
1.) A feature request for Sybase ASE 15.7+ in the Create Table visual editor to include support in-row in the Column Properties for LOB's like TEXT data type etc.
2.) The in row property should also be scripted in Script to Window -> Create
3.) Check for any more new changes in Sybase ASE 15.7
Sample Create Table SQL :
1) Support 'in row' from an extraction perspective
2) Can we add 'in row' as a column property in the table editor UI?
Also take a look at materialized views.
Also take a look at materialized views.
I've added the extraction and scripting for tables. I have added the column property to the GUI for sybase ase 15.7 and above. I am unable to find detailed enough docs on what datatypes this property is allowed on, so am not going to restrict it in the GUI but it would seem to only be available for lob type datatypes. If the user attempts to give the option to a datatype that does not permit they will receive the appropriate sql exception.
As for the Materialized views, I am not sure what you are asking me to do.... this is not something that we supported in the past as an object. Do you wish to file a new issue for supporting materialized views in sybase ase 15.7?
I've added the extraction and scripting for tables. I have added the column property to the GUI for sybase ase 15.7 and above. I am unable to find detailed enough docs on what datatypes this property is allowed on, so am not going to restrict it in the GUI but it would seem to only be available for lob type datatypes. If the user attempts to give the option to a datatype that does not permit they will receive the appropriate sql exception.
As for the Materialized views, I am not sure what you are asking me to do.... this is not something that we supported in the past as an object. Do you wish to file a new issue for supporting materialized views in sybase ase 15.7?
Issue #10689 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
2 issue links |
relates to #12347
Issue #12347Support for "in row" feature for Sybase ASE 15.7+ in ER Modeler |
relates to #11113
Issue #11113Support for materialized view in Sybase ASE 15.7+ |
1) Support 'in row' from an extraction perspective
2) Can we add 'in row' as a column property in the table editor UI?