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
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.
SAP Knowledge Base Article - Preview