|
Home > Archive > SQL Anywhere database > June 2005 > computed columns
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| hbrofman 2005-06-18, 1:23 pm |
| i have a database with a computed column. the colums are
all there for existing records. when i inload new records
via the load table command in isql, these records have
(NULL) in the computed column.
isn't this supposed to be automatic? should not a computed
colum be updated any time the field it is computed off of
changes?
| |
| Glenn Paulley 2005-06-19, 9:23 am |
| hbrofman wrote in news:42b45319.3d49.1681692777@sybase.com:
> i have a database with a computed column. the colums are
> all there for existing records. when i inload new records
> via the load table command in isql, these records have
> (NULL) in the computed column.
>
> isn't this supposed to be automatic? should not a computed
> colum be updated any time the field it is computed off of
> changes?
>
By default, dbunload creates LOAD TABLE statements with the COMPUTES
clause set to OFF. Turn COMPUTES to ON to enable automatic computation of
computed columns.
--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
| |
| hbrofman 2005-06-19, 8:23 pm |
| thanks, that was it.
in order to trigger the re-computes, i had to update a field
in each row that did not have the computation done. isn't
there a better way?
thanks
harvey
| |
| Glenn Paulley 2005-06-20, 9:23 am |
| hbrofman wrote in news:42b61ba8.7d34.1681692777@sybase.com:
> thanks, that was it.
>
> in order to trigger the re-computes, i had to update a field
> in each row that did not have the computation done. isn't
> there a better way?
>
> thanks
> harvey
>
Show me your LOAD TABLE statement.
--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
|
|
|
|
|