Use Adaptive Server® version 15.7 ESD #1 to create in-row large object (LOB) columns. However, because proxy tables do not store information about remote in-row LOB columns in their metadata, when information about the LOB column on the source or target table is unavailable, Adaptive Server stores data off-row on the target table.
These commands support proxy tables with in-row LOB data:
Command |
Supported when: |
|---|---|
alter database ... for proxy_update |
The underlying proxy tables contain in-row LOB columns. |
alter table add | modify .... in row, ... |
These commands are forwarded directly to the remote server. |
create database...with default location...for proxy update |
The underlying proxy tables contain in-row LOB columns. |
create existing table .. (column_name in row, . . . ) at external_location |
|
create proxy_table ... at external_location |
The remote table contains in-row LOB columns. |
create table .. (column_name in row, . . . ) at external_location |
The remote table contains in-row LOB columns; any proxy columns created do not contain in-row properties. |
insert into {local | proxy} table select {local | proxy} table |
The target data is stored in-row, if the size of the data is within the in-row limit. |
select into proxy_table from local_table |
The target data is stored in-row, if the size of the data is within the in-row limit. |
select into existing table proxy_table from local_table |
The target data is stored in-row, if the size of the data is within the in-row limit. |
select into proxy_table (column_name in row, ... ) from local_table |
The target data is stored in-row, if the size of the data is within the in-row limit. |
select into local_table (column_name in row ... ) from proxy_table |
The target data is stored in-row. |
update proxy_table set lob_column = |
The target data is stored in-row, if the size of the data is within the in-row limit. |
These commands do not support proxy tables with in-row LOB data:
create database proxy_database ... inrow_lob_length = n
alter database proxy_database ... set inrow_lob_length = n
During these select into and bulk copy (bcp) operations, target data is stored in-row if the size of the data is within the in-row limit, and the source data is in-row (otherwise the target data is stored off-row):
select into local_table (column_name in row (n) ... ) from proxy_table (target data will be stored in-row)
select into proxy_table from local_table
select into proxy_table (column_name in row (n)... ) from local_table
select into existing_table proxy_table from local_table
select into local_table from proxy_table
select into proxy_table_1 from proxy_table_2
bcp database_name ... proxy_table in bcp_file ...
