SEO

John Miller wrote:

> Here is my suggestion.
>
>
> create table x ( c1 serial, c2 lvarchar);
>
> insert into x select 0,tabname from systables;
>
> create view x_view( c1, c2 ) as select c1, c2::char(2048) from x;
>
>
> select * from dbs@server:x_view;
>
>
>
> Hope it helps,

Nope. That will give you error -999.

Create a synonym? Nope, that will give you error -999.

Create a view on a synonym? Nope, that will give you error -999.

You can see a pattern already right? :-)

Attempt a remote query on ANY extended data type and you will get error
-999. Over time, you will come to loath just the thought of error -999. ;-)

The SP idea works, but is very limited, as you can't access the data as a
table, i.e. by joining and filtering, etc.

You can "trick" the DB server by one of the following two methods, but you
cannot use SELECT * on the resultant table, or you will get error -999. You
must SELECT all non-extended data type columns explicitly. Oh, and views
never get fooled:

1. RENAME your table, create a single column table with the same name,
create a synonym to that table, drop that table and RENAME your original
table back so that the synonym now points to the actual table.

2. Create a single column table, create a synonym to that table, drop that
table and create a synonym with the same name that points to your original
table so that the synonym now points to the actual table via the second
synonym.

The second method is useful if you cannot afford downtime for the table.

And if anyone mentions error -you-know-what...., well I'll develop that
tick in my right eye again. ,-|

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list