I'm seeing some strange behaviour when using proxy tables on v10.0.1.4075, or at least I think it's strange, maybe it's perfectly normal and I'm missing something obvious :) When I'm joining from a local table to a proxy table I have to trim my local field to make the join work correctly. Is there something I need to do when creating the proxy server, or is this just as expected ?

If I create a table and add some data to a database

create table db2_prod (db2_product char(10));
insert INTO DB2_PROD VALUES ('FOO       ');

Then create a similar table on another database

create table db1_prod (db1_product char(10));
insert INTO DB1_PROD VALUES ('FOO       ');

And create a proxy connection to the first database

create server DB2 class 'SAODBC' using 'Driver=SQL Anywhere 10;DSN="";ENG=mydb;UID=dba;PWD=sql;commlinks=tcpip{host=LOCALHOST,to=15;Dobroadcast=NONE;port=2639}';
create existing table PRX_DB2_PROD AT 'DB2.mydb.dba.DB2_PROD';

Now this sql returns a result

SELECT * FROM DB1_PROD join prx_db2_prod on trim(db1_product)=db2_product

But this one doesn't

SELECT * FROM DB1_PROD join prx_db2_prod on db1_product=db2_product

Update

I can just about cope with the above behaviour by using the trim, however I'm trying to copy data from the proxy table and my copied data is being trimmed as it comes across.

This sql

select * into #bar from prx_db2_prod

Copies db2_product from the proxy table into a local table as

'FOO'

instead of

'FOO       '

Update

I was sure this would be unrelated (it seems to be more related to powerbuilder) but while searching I found this.

Newsgroup link

Using the native driver for Sybase System 10 to acess a fixed character field char(12) the query returned just the field content: 8 characters. Accessing the same field using an ODBC Driver the same query returned the field content plus 3 spaces padding, resulting in 12 characters There are some difference on spaces padding when using native or ODBC drivers?

So I created my own ODBC connection and created the proxy server using that instead of 'SAODBC'

 create server DB2 class 'ODBC' using 'mydb'

And now the fields aren't trimmed and everything works, however I don't really want to go around creating my own ODBC connections, help ??? :)