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.