3619866 - Where clause is not being sent to remote server - SAP ASE

There is a proxy table on ASE pointing to a remote table located on DB2 via DirectConnect (TRS).

When running a select query on ASE,  where clause is not being sent to DB2.

CIS traces indicate that ASE received the statement text with where clause:

=====

00:0030:00000:03314:2025/06/06 12:21:22.22 server  TDS_LANG, spid 3314: command text: select cola, colb, colc from tb01 where cold ="123456"

=====

But CIS optimized and sent to DC TRS the following statement without the where clause:

======

00:0030:00000:03314:2025/06/06 12:21:22.29 server  REM_SCAN, spid 3314, server TRSXXXX, optimized statement: SELECT cola, colb, colc, cold FROM tb01

======

Server class reported by "sp_helpserver" is correct: "direct_connect".

When comparing the output from "dbcc showcaps" between this server with another server that is working fine then we can see differences in the capabilities.

If creating a new server entry for remote server and a new proxy table then query works fine.

• SAP Adaptive Server 16.0 SP03 PL12
• MFC DirectConnect 15.0.1 (DB2)
• TRS

OMNI, CIS, site handler, proxy table, MFC, DirectConnect, Direct Connect, dbcc showcaps, capabilities, where clause , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem