SAP Knowledge Base Article - Preview

2800741 - pdb_execute_sql returns string value as binary when it runs a query on system tables -SRS

Symptom

  • Is there a way to make the query output of "pdb_execute_sql" readable from Rep Agent for MS SQL Server (RAM)?
  • Queries into MSSQL server using RAM isql command line provide binary output. 
  • See below as an example, to find out a table's indexes:  

    1> pdb_execute_sql "select name from sys.indexes where object_id = OBJECT_ID('dbo.T1')"
    2> go
    name 
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    0x750073006d006c0069006e006b006100670065005f00750073006100670065002400750073006d
    006c0069006e006b006100670065005f0031003400350035003300390036003300300034003100 
    0x750073006d006c0069006e006b006100670065005f007300750062007300630072006900620065
    00720073005f0046004b00

    (2 rows affected)


Read more...

Environment

 SAP Replication Server Options for MS SQL Server all versions

Product

SAP Replication Server, option for Microsoft SQL Server all versions

Keywords

MS server, SQL Server, SRS, SRO , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.